Enterprise Data Lake Systems Analyst

UNISYNC SYSTEMS PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

UNISYNC SYSTEMS PTE. LTD. is seeking an experienced Data Engineer to design, integrate, and support enterprise-scale data platforms and data-lake solutions.

You will develop and optimize ETL pipelines, integrate multiple data sources, and implement data-quality controls to ensure reliable data for analytics. Responsibilities include building and enhancing data integration, working with Hadoop-based environments, and collaborating with global teams to deliver large-scale data initiatives.

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

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