Job Title: Migration ETL Developer – Informatica (Cloud IDMC) Specialist
Department: Technology & Operations / Digital Transformation
Location: Zurich
Reports To: Technical Lead
Employment Type: Full-time
Role Purpose
The Migration ETL Developer will play a critical technical role at the client’s 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 (onpremise 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 the client’s 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

Migration ETL Developer – Informatica (Cloud IDMC) Specialist

Job Description

Recent Jobs.