Lead Consultant(Development) (IN)

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.