Enterprise Data Lake Systems Analyst

JEET ANALYTICS PTE. LTD.; Singapore; On-site; SGD 70,000 - 120,000; Full time

Job summary

JEET ANALYTICS PTE. LTD. in Singapore is seeking an experienced Data Engineer to design, integrate and support enterprise-scale data platforms and data-lake solutions.

The role focuses on building and optimizing complex ETL pipelines, orchestrating data flows from multiple sources, and ensuring data quality and governance across the stack. You will work with Hadoop, Hive, Impala, Teradata, Oracle and Netezza, and collaborate with cross-functional teams to deliver scalable data initiatives for

Qualifications

• Experience designing and implementing enterprise data integration and Data Lake solutions.
• Proficient in ETL with Informatica, DataStage and SQL.
• Familiar with Hadoop ecosystem and multiple databases (Teradata, Oracle, Netezza).

Responsibilities

• Design and implement 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 complex datasets and resolve data discrepancies.
• Support SIT/UAT, production validation and defect resolution.
• Optimize SQL queries and high-volume batch workloads.
• Collaborate with cross-functional teams to deliver data initiatives.

Skills

ETL development

Informatica

DataStage

SQL

Big data

Hadoop

Data governance

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