Enterprise Data Lake Systems Analyst

REGTECH INSIGHT PTE. LTD.; Singapore; Presencial; SGD 90.000 - 150.000; Jornada completa

Descripción de la vacante

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

Responsabilidades

• 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

Descripción del empleo

We are seeking an experienced Data Engineer to design, integrate and support enterprise-scale data platforms and data-lake solutions. The role involves developing and optimizing complex ETL pipelines, integrating multiple upstream and downstream data sources, performing data transformation and reconciliation, and implementing data-quality and validation controls.

Key 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