Data Engineer

MC CONSULTING PTE. LTD.; Singapore; On-site; SGD 180,000 - 280,000; Full time

Job summary

MC CONSULTING PTE. LTD. seeks a Senior ETL/Data Integration Consultant to design, develop, and optimize enterprise data solutions for banking environments using Informatica PowerCenter.

The role requires hands-on expertise with IBM InfoSphere Data Architect and IBM Information Governance Catalog, plus strong SQL tuning across Oracle/SQL Server/Teradata and scheduling with Control-M or Autosys in an Agile setup.

Qualifications

• Minimum 10 years of experience in Software Consulting, Data Integration, or ETL Development.
• Minimum 5 years of experience supporting enterprise banking projects.
• Hands-on expertise in Informatica PowerCenter development and administration.
• Strong experience with IBM InfoSphere Data Architect.
• Experience using IBM Information Governance Catalog.
• Advanced SQL development and performance tuning in Oracle, SQL Server, and Teradata.
• Strong understanding of Enterprise Data Warehouse architecture and dimensional modelling.
• Experience implementing Data Lineage and Data Quality frameworks.
• Experience with Control-M or Autosys scheduling tools.
• Working knowledge of UNIX scripting.
• Experience working in Agile delivery environments.

Responsibilities

• Design, develop, and enhance enterprise ETL solutions using Informatica PowerCenter.
• Build and maintain high-performance data integration frameworks for large-scale banking environments.
• Develop logical and physical data models using IBM InfoSphere Data Architect.
• Implement Data Governance, Business Glossary, Data Lineage, and Data Quality solutions using IBM Information Governance Catalog.
• Perform SQL performance tuning across Oracle, SQL Server, and Teradata environments.
• Optimize ETL workflows, batch processing, and production scheduling using Control-M and Autosys.
• Support banking regulatory reporting and enterprise data governance initiatives.
• Collaborate with business stakeholders to gather requirements and translate them into technical solutions.
• Ensure successful deployment, production support, and continuous performance improvements.

Skills

Enterprise data warehousing

Dimensional modelling

Data governance

Data lineage

Data quality

Agile delivery

UNIX scripting

Stakeholder collaboration

Banking domain experience

Tools

Informatica PowerCenter

IBM InfoSphere Data Architect

IBM Information Governance Catalog

Oracle SQL

SQL Server

Teradata

Control-M

Autosys

UNIX

Agile

Data Governance

Data Lineage

Data Quality

Job description

Key Responsibilities

• Design, develop, and enhance enterprise ETL solutions using Informatica PowerCenter.
• Build and maintain high-performance data integration frameworks for large-scale banking environments.
• Develop logical and physical data models using IBM InfoSphere Data Architect.
• Implement Data Governance, Business Glossary, Data Lineage, and Data Quality solutions using IBM Information Governance Catalog.
• Perform SQL performance tuning across Oracle, SQL Server, and Teradata environments.
• Optimize ETL workflows, batch processing, and production scheduling using Control-M and Autosys.
• Support banking regulatory reporting and enterprise data governance initiatives.
• Collaborate with business stakeholders to gather requirements and translate them into technical solutions.
• Ensure successful deployment, production support, and continuous performance improvements.

Mandatory Requirements

Applicants must meet all of the following requirements:

• Minimum 10 years of experience in Software Consulting, Data Integration, or ETL Development.
• Minimum 5 years of experience supporting enterprise banking projects.
• Hands-on expertise in Informatica PowerCenter development and administration.
• Strong experience with IBM InfoSphere Data Architect.
• Experience using IBM Information Governance Catalog.
• Advanced SQL development and performance tuning in Oracle, SQL Server, and Teradata.
• Strong understanding of Enterprise Data Warehouse architecture anddimensional modelling.
• Experience implementing Data Lineage and Data Quality frameworks.
• Experience with Control-M or Autosys scheduling tools.
• Working knowledge of UNIX scripting.
• Experience working in Agile delivery environments.

Preferred Experience

• Candidates with experience in any of the following areas will have an advantage:
• Banking Credit Risk projects.
• Loss Given Default (LGD) initiatives.
• Consumer Banking migration programmes.
• Regulatory reporting.
• Data Governance implementation.
• Banking Collections systems.

Required Technical Skills

• Informatica PowerCenter
• IBM InfoSphere Data Architect
• IBM Information Governance Catalog
• Oracle SQL
• SQL Server
• Teradata
• ETL Development
• Data Warehouse
• Control-M
• Autosys
• UNIX
• Agile
• Data Governance
• Data Lineage
• Data Quality