ETL Developer / ETL Developeress

Job Opportunity: Migration ETL Developer

The Migration ETL Developer will play a pivotal technical role in our client's core banking transformation programs. This position focuses on designing, developing, and executing secure, high-quality data migration flows into target systems such as Temenos T24. Utilizing Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC), the developer will ensure efficient extraction, transformation, cleansing, and loading of sensitive banking data while adhering to strict data governance and privacy standards.

Key Responsibilities:

• Design, develop, and maintain robust ETL workflows using Informatica (both on-premise and cloud - IDMC) to support large-scale data migration from diverse source systems.
• Utilize PowerExchange to access Mainframe source systems as 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, uncovering 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 the completeness, accuracy, and consistency of migrated datasets.
• Troubleshoot and resolve performance bottlenecks, connectivity issues, and job failures across development, testing, and production environments.
• Securely manage client-sensitive data in compliance with Swiss banking regulations (FIDLEG, MAR, GDPR) and the client's internal data protection policies.
• Document ETL designs, data lineage, interface specifications, and support the 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.
• Demonstrated hands-on expertise with Informatica PowerCenter and Informatica Cloud (IDMC preferred), including connectors, task flows, and monitoring dashboards.
• Strong proficiency in SQL, PL/SQL, and relational databases (Oracle, Microsoft SQL Server, DB2).
• Proven experience in data profiling, quality assessment, and reconciliation techniques.
• Solid understanding of dimensional modeling, 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 that meet both functional and non-functional requirements.
• Ensure all data movements are auditable, reversible, and error-handled in accordance with bank standards.
• Guarantee successful end-to-end data reconciliation across migration waves.

Apply online using the form below. Please note that only applications matching the job profile will be considered.