Senior Data Engineer - Informatica & Spark ETL

HMI TECH PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

HMI TECH PTE. LTD. is seeking an experienced Data Engineer to design, develop and maintain ETL workflows and data pipelines for enterprise-scale systems.

You will work with Informatica PowerCenter, Python, Spark, Hive, and SQL across Oracle/Teradata/SQL Server environments. Responsibilities include performance tuning, production support, creating design documents, and collaborating with BAs, QA, and stakeholders.

Qualifications

• Experience with ETL/Data Warehousing concepts and large-scale data platforms.
• Proficiency in Informatica PowerCenter, SQL across Oracle/Teradata/SQL Server, Python, Spark.
• Strong analytical, problem-solving, and communication skills.
• Experience in Agile/Scrum environments and production support.
• Unix shell scripting and data integration best practices.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Develop data pipelines using Python, Spark, Hive, and HDFS.
• Perform ETL/ELT from multiple source systems.
• Write and optimize SQL queries for Oracle, Teradata, or SQL Server.
• Prepare design documents, mappings, and data flow documentation.
• Perform performance tuning, troubleshooting, and production support.
• Coordinate with BAs, QA, and stakeholders through the project lifecycle.
• Participate in Agile ceremonies and contribute to sprint planning and delivery.
• Support production deployments and incident resolution.

Skills

Informatica PowerCenter

SQL

Python

Apache Spark

Hive & HDFS

ETL/Data Warehousing concepts

Unix Shell Scripting

Production Support

Agile/Scrum

Education

Bachelor's degree in Engineering, Computer Science, Information Technology, or a related field

Tools

Apache Sqoop

Apache NiFi

Control-M or AutoSys

Git/Bitbucket

Jenkins

Job description

HMI TECH PTE. LTD. is seeking an experienced Data Engineer to design, develop and maintain ETL workflows and data pipelines for enterprise-scale systems.

You will work with Informatica PowerCenter, Python, Spark, Hive, and SQL across Oracle/Teradata/SQL Server environments. Responsibilities include performance tuning, production support, creating design documents, and collaborating with BAs, QA, and stakeholders.