mc consulting pte. ltd.
Kallang / Global
Kallang / Global
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
Singapore / Global
Singapore / Global
Singapore / Global
Singapore / Global
Singapore / Global
Singapore / Global