Enterprise Data Lake Systems Analyst

UNISONEDGE CONSULTING PTE. LTD.; Singapore; On-site; SGD 70,000 - 120,000; Full time

Job summary

UNISONEDGE CONSULTING 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 controls.

You will collaborate with technical, business and offshore/onshore teams to deliver enterprise data initiatives and ensure data accuracy across environments like Hadoop, Hive, Impala, Teradata, Oracle and Netezza.

Qualifications

• Experience designing and implementing enterprise-scale data platforms and data lakes.
• Proficiency with ETL tools and SQL-based data transformations.
• Familiarity with data governance, quality controls, and metadata management.

Responsibilities

• Design and enhance enterprise data integration and Data Lake solutions.
• Develop and optimize ETL workflows with 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 datasets and resolve data discrepancies and integration issues.
• Support SIT/UAT, production validation and 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

Informatica

DataStage

SQL

Data governance

Hadoop/Hive/Impala

Teradata

Oracle

Netezza

Data quality

Tools

Informatica

DataStage

SQL

Hadoop

Hive

Impala

Teradata

Oracle

Netezza

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