Ideagen is the invisible force behind many things we rely on every day - from keeping airplanes soaring in the sky, to ensuring the food on our tables is safe, to helping doctors and nurses care for the sick. So, when you think of Ideagen, think of it as the silent teammate that's always working behind the scenes to help those people who make our lives safer and better. 

Everyday millions of people are kept safe using Ideagen software. We have offices all over the world including America, Australia, Malaysia and India with people doing lots of different and exciting jobs. 

Ideagen believe that by recruiting diverse and talented individuals, we create an inclusive community for all. We are committed to empowering all colleagues to maximize their potential and express their unique characteristics, experience, and knowledge to achieve their ambitions.

Ideagen is looking for a Data Engineer who will build automated pipelines and solutions for data migration/data import or other operations requiring data ETL.

• Perform analysis on core products to support migration planning and development.
• Work closely with the Team Lead and collaborating with other stakeholders to gather requirements and
• build well architected data solutions.
• Produce supporting documentation, such as: specifications, data models, relation between data and others,
• required for the effective development, usage and communication of the data operations solutions with
• different stakeholders.
• Experience working with databases on-premises and/or cloud-based environments such as MSSQL, MySQL, PostgreSQL, AzureSQL, Aurora MySQL & PostgreSQL, AWS RDS etc.
• Experience building ETL/ELT pipelines
• Strong problem solving and analytical skills, high attention to detail
• Passion for analytics, real-time data, and monitoring
• Critical Thinking and collaboration skills
• Self-starter and a quick learner, ready to learn new technologies and tools that the job demand

Essential:

· Strong experience (4-8 years of relevant experience) working with databases on-premises and/or cloud-based environments such as MSSQL, MySQL, PostgreSQL, AzureSQL, Aurora MySQL & PostgreSQL, AWS RDS etc.

· Strong knowledge of databases, data modeling and data life cycle

· Proficient in understanding data and writing complex SQL

· Experience with any ETL/ELT tool or platforms - SnapLogic (preferred), SSIS, Talend, Informatica, Azure Data Factory, AWS Glue, IBM InfoSphere etc.

· Experience working with REST API in data pipelines

· Strong problem solving and high attention to detail

· Passion for analytics, real-time data, and monitoring

· Critical Thinking, good communication and collaboration skills

· Focus on high performance and quality delivery

· Highly self-motivated and continuous learner

Desirable:

· Experience working with no-SQL databases like MongoDB

· Experience working with Microsoft Power Platform (PowerAutomate and PowerApps) or any similar

automation / RPA tool

· Experience with cloud data platforms like snowflake, data bricks, AWS, Azure etc.

· Awareness of emerging ETL and Cloud concepts such as Amazon AWS or Microsoft Azure

· Experience working with Scripting languages, such as Python, R, JavaScript, etc.

Behaviour

• Ambitious - Drive, Planning & Execution
• Adventurous - Flexibility & Resilience and Savvy Thinking
• Community - Collaboration & Communication