Software Developer

MC CONSULTING PTE. LTD.; Singapore; On-site; SGD 140,000 - 200,000; Full time

Job summary

MC CONSULTING PTE. LTD. in Singapore seeks an experienced ETL/Data Integration Consultant to design, develop and optimize enterprise data integration solutions for banking environments.

You will leverage Informatica PowerCenter and IBM InfoSphere Data Architect to deliver data models and governance frameworks. You will tune SQL performance across Oracle, SQL Server, and Teradata, and manage batch scheduling with Control-M/Autosys, while collaborating with stakeholders in an Agile setting to

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

SQL

ETL Development

Data Warehouse

Agile

Data Governance

Data Lineage

Data Quality

UNIX

Tools

Informatica PowerCenter

IBM InfoSphere Data Architect

IBM Information Governance Catalog

Oracle SQL

SQL Server

Teradata

Control-M

Autosys

UNIX

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