Migration ETL Developer

Tech Aalto Pte ltd; Singapore; On-site; SGD 217,000 - 310,000; Full time

Job summary

Tech Aalto Pte Ltd seeks a Migration ETL Developer to drive secure data migration in core banking projects. You will design and implement ETL/ELT workflows using Informatica PowerCenter and IDMC, focusing on extraction, transformation, cleansing, and loading of sensitive data into target systems.

Join a collaborative delivery team, support validation cycles, maintain data lineage, and ensure compliance with Swiss GDPR/MAR-like governance while working in a fast-paced agile environment.

Qualifications

• Minimum 7-10 years of ETL development experience in enterprise banking or financial services.
• Hands-on experience with Informatica PowerCenter and Informatica Cloud (IDMC preferred).
• Strong SQL/PLSQL skills and relational databases (Oracle, SQL Server, DB2).
• Experience in data profiling, quality assessment, and reconciliation techniques.
• Understanding of dimensional modelling, metadata management, and CDC concepts.
• Familiarity with DevOps, CI/CD pipelines, and Git.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica (on-premise and IDMC) for large-scale data migration.
• Experience with PowerExchange for Mainframe source access is a plus.
• Implement scalable ETL/ELT processes for batch and near-real-time data movement.
• Conduct data profiling to identify quality issues and anomalies.
• Collaborate with Business Analysts and Data Architects to translate mappings into ETL logic.
• Perform reconciliation and delta analysis between source and target systems.
• Troubleshoot performance, connectivity, and job failures across environments.
• Handle client data in compliance with Swiss data protection regulations (FIDLEG, MAR, GDPR).
• Document ETL designs, data lineage, and interface specs; support go-live handover.
• Participate in agile sprints, code reviews, SIT/UAT, and production cutover.

Skills

ETL development

Informatica PowerCenter

Informatica IDMC

SQL

PL/SQL

Data profiling

Dimensional modelling

CDC

CI/CD pipelines

DevOps

Tools

PowerExchange

Job description

Migration ETL Developer

Job Title: Migration ETL Developer – Informatica (Cloud IDMC) Specialist Department: Technology & Operations / Digital Transformation Location: IN /CH Reports To: Technical Lead Employment Type: Full-time

Role Purpose

The Migration ETL Developer will play a critical technical role in core banking transformation programmes, focusing on the design, development, and execution of secure, high-quality data migration flows into target systems such as Temenos T24. Using Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC), the developer will ensure efficient extraction, transformation, cleansing, and loading of sensitive banking data while maintaining strict compliance with data governance and privacy standards.

Key Responsibilities

• Design, develop, and maintain robust ETL workflows using Informatica (on-premise and cloud - IDMC ) to support large-scale data migration from heterogeneous source systems.
• Experience in using Powerexchange to access Mainframe source system would be an added advantage.
• Implement scalable data integration jobs covering extract, transform, cleanse, enrich, and load (ETL/ELT) processes within both batch and near-real-time environments.
• Conduct data profiling to assess source data quality, uncover inconsistencies, duplicates, missing values, and structural anomalies affecting migration integrity.
• Collaborate with Business Analysts and Data Architects to interpret mapping specifications and translate them into executable ETL logic.
• Perform reconciliation and delta analysis between source and target systems to validate completeness, accuracy, and consistency of migrated datasets.
• Troubleshoot and resolve performance bottlenecks, connectivity issues, and job failures across development, testing, and production environments.
• Securely handle client-sensitive data in line with Swiss banking regulations (FIDLEG, MAR, GDPR) and internal data protection policies.
• Document ETL designs, data lineage, interface specifications, and support operational handover post-go-live.
• Participate in agile sprints, code reviews, testing cycles (SIT/UAT), and production cutover activities.

Essential Qualifications

• Minimum 7-10 years of ETL development experience in enterprise banking or financial services environments.
• Proven hands-on expertise with Informatica PowerCenter and Informatica Cloud (IDMC preferred), including connectors, taskflows, and monitoring dashboards.
• Strong skills in SQL, PL/SQL, and relational databases (Oracle, Microsoft SQL Server, DB2).
• Demonstrated experience in data profiling, quality assessment, and reconciliation techniques.
• Solid understanding of dimensional modelling, metadata management, and CDC (Change Data Capture) concepts.
• Familiarity with DevOps practices, CI/CD pipelines, and version control (Git).

Preferred Attributes

• Prior involvement in core banking migrations (e.g., to T24, FinSuite, or equivalent).
• Exposure to cloud platforms (AWS, Azure) and integration with IDMC.
• Basic knowledge of banking domains: client master, accounts, holdings, transactions, limits.
• Awareness of Swiss regulatory requirements impacting data handling and reporting.

Technical Accountabilities

• Deliver high-performance, well-documented ETL solutions meeting functional and non-functional requirements.
• Ensure all data movements are auditable, reversible, and error-handled according to bank standards.
• Guarantee successful end-to-end data reconciliation across migration waves.