Enterprise Data Lake Architect - ETL & Data Quality

REGTECH INSIGHT PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

REGTECH INSIGHT PTE. LTD. in Singapore seeks an experienced Data Engineer to design, integrate and support enterprise-scale data platforms and data-lake solutions.

You will develop and optimize ETL pipelines, reconcile data from multiple sources, and implement data-quality controls to ensure accuracy and governance. You will work with technologies such as Informatica, DataStage, SQL, Hadoop, Hive, Impala, Teradata and Oracle environments, collaborating with business and technical teams to

Responsibilities

• Design and enhance enterprise data integration and Data Lake solutions.
• Develop and optimize ETL workflows using Informatica, DataStage and SQL.
• Perform source-to-target mapping, data transformation, reconciliation and validation.
• Work with Hadoop, Hive, Impala, Teradata, Oracle and Netezza environments.
• Implement data-quality, metadata and data-governance controls.
• Analyze complex datasets and resolve data discrepancies and integration issues.
• Support SIT/UAT, production validation and technical defect resolution.
• Optimize SQL queries, ETL processes and high-volume batch workloads.
• Collaborate with technical, business and offshore/onshore teams to deliver enterprise data initiatives

Job description

REGTECH INSIGHT PTE. LTD. in Singapore seeks an experienced Data Engineer to design, integrate and support enterprise-scale data platforms and data-lake solutions.

You will develop and optimize ETL pipelines, reconcile data from multiple sources, and implement data-quality controls to ensure accuracy and governance. You will work with technologies such as Informatica, DataStage, SQL, Hadoop, Hive, Impala, Teradata and Oracle environments, collaborating with business and technical teams to