Data Engineer

Role overview

We are looking for a seasoned Data Engineer based in Singapore for an office-based role. This position calls for 6+ years of practical experience in enterprise data warehousing, ETL/ELT engineering, and large-scale data platforms. The work involves creating, improving, and supporting robust data pipelines and reusable frameworks across Teradata data warehouse systems and Hadoop-based ecosystems.

What you will do

• Design and support ETL/ELT workflows with Teradata SQL, Informatica PowerCenter, Apache Spark, QueryGrid, and Trino.
• Develop efficient pipelines that move and reshape data for Teradata data warehouses and datamarts.
• Create automation-friendly engineering frameworks using GCFR, BTEQ, and shell scripting.
• Tune complex ETL and processing jobs to reduce resource usage and improve overall performance.
• Build and maintain Java-based CDC solutions that process OLR logs from SAP (Oracle) systems and load data into Teradata.
• Develop reusable and configurable CDC ingestion frameworks for enterprise integration needs.
• Support MDM solutions for user data uploads, including validation, enrichment, and approval flows.
• Work with Hadoop stack tools such as Hive, Impala, Spark, Kafka, Iceberg, NiFi, Ranger, Atlas, and Flink for ingestion, processing, and governance.
• Set up orchestration and scheduling so data is delivered reliably and on time.
• Partner with business, analytics, and application teams to convert requirements into scalable data solutions.
• Maintain strong data quality, consistency, and governance across platforms.
• Investigate issues, perform root-cause analysis, and resolve production problems in pipelines and ETL jobs.
• Continuously enhance standards, frameworks, and automation practices within the data engineering function.

Requirements

• A bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
• At least 6 years of experience in data engineering, ETL development, or enterprise data warehouse environments.
• Strong practical knowledge of Teradata SQL and EDW/ETL design.
• Hands-on exposure to Informatica PowerCenter for enterprise ETL work.
• Working experience with Hadoop ecosystem technologies such as Apache Spark, Hive, Kafka, NiFi, Iceberg, and Impala.
• Deep understanding of performance tuning and optimization for large-scale data pipelines.
• Experience with shell scripting, BTEQ, and automation frameworks.
• Good grasp of orchestration, scheduling, and workflow automation for data pipelines.
• Experience with CDC concepts, preferably implemented using Java.
• Ability to build ingestion, transformation, and automation frameworks in enterprise settings.
• Sound knowledge of data modeling, ETL design patterns, and data warehousing principles.
• Experience integrating data from enterprise systems such as SAP (Oracle).
• Familiarity with MDM solutions, including validation and approval workflows.
• Strong analytical and debugging skills, plus the ability to solve complex issues.
• Clear communication and stakeholder management skills.
• Experience working in Agile or other large-scale delivery environments.

Additional information

This is a full-time, office-based role in Singapore, Singapore. The role focuses on enterprise data engineering across Teradata and Hadoop environments, with emphasis on automation, governance, performance, and scalable integration frameworks.

What we value

We are looking for someone who can work across technical and business teams, strengthen data reliability, and contribute to enterprise-grade engineering standards while helping modernize data platforms and pipelines.