Enterprise Data Lake Systems Analyst

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

Job summary

RISKDATA CONSULTING PTE. LTD. seeks an experienced Data Engineer to design, build and support enterprise data platforms and Data Lake solutions in Singapore. You will develop scalable ETL workflows, reconcile data across multiple sources and ensure data quality and governance across the stack.

The role involves optimizing complex ETL pipelines, collaborating with onshore/offshore teams, and supporting SIT/UAT and production validation for high-volume workloads.

Qualifications

• Experience designing data platforms and ETL pipelines.
• Hands-on with Informatica, DataStage and SQL for data integration.
• Familiarity with Hadoop ecosystem and data lake concepts.
• Knowledge of data quality, governance and reconciliation practices.
• Ability to analyze complex datasets and resolve data issues.

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

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