Enterprise Data Lake Systems Analyst

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

Job summary

UNISYNC SYSTEMS PTE. LTD. 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, integrate multiple data sources, and implement data-quality and validation controls.

Responsibilities include working with Informatica, DataStage and SQL to design data integration, performance optimize large batch workloads, and collaborate with global teams to deliver scalable data initiatives.

Qualifications

• Experience designing and implementing enterprise data platforms and data lakes.
• Strong ETL development experience with Informatica and DataStage.
• Proficient in SQL and data transformation, reconciliation, and validation.
• Familiarity with Hadoop ecosystem (Hadoop, Hive, Impala) and data warehousing environments (Teradata, Oracle, Netezza).

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

Skills

ETL pipelines

Data integration

Data governance

Data quality

Hadoop

Tools

Informatica

DataStage

SQL

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