Role Overview
The Data Migration Consultant supports the Technical Sub Lead and Technical Lead in delivering the migration solution for a specific technical domain or market. Operating at an assistant manager level, this role combines hands-on ETL development and data analysis with emerging coordination responsibilities. The Data Migration Consultant is expected to be a strong individual contributor, producing quality technical deliverables while beginning to guide and review the work of junior analysts within the assigned scope.
Key Responsibilities
- Develop, test, and maintain ETL pipelines for the assigned data domain or country, ensuring accuracy, performance, and auditability in line with approved functional specifications
- Implement data transformation and cleansing logic, adhering to defined migration standards and technical guidelines set by the Sub Lead
- Conduct unit and integration testing of migration pipelines, document defects, and support resolution in a timely manner
- Maintain technical artefacts including ETL specifications, data dictionaries, and technical runbooks for the assigned scope
- Execute source system data profiling to identify and document anomalies, nulls, duplicates, and referential integrity issues
- Implement data quality checks and reconciliation controls within ETL pipelines, investigating and resolving reconciliation breaks identified during dry runs and UAT
- Participate in performance testing of migration pipelines, supporting optimisation of queries and transformation logic for throughput
- Contribute to the technical cutover runbook and execute assigned tasks during dry-run and live cutover windows
- Support rollback procedures and post-migration technical validation for the assigned domain
- Review work produced by Analysts, providing constructive feedback and guidance to support their development
- Escalate technical risks and blockers to the Sub Lead promptly, with clear documentation of the issue and impact
Technical Expertise Required
- Proficiency in at least one ETL or data integration tool such as Informatica, DataStage, Python/PySpark, or Azure Data Factory
- Strong SQL skills with experience working with relational databases such as Oracle, SQL Server, or DB2, preferably in a banking context
- Solid understanding of the data migration lifecycle from extraction through to reconciliation and cutover
- Familiarity with data profiling techniques, data quality frameworks, and reconciliation methodologies
- Exposure to core banking platforms such as Temenos, Flexcube, Finacle, or Mambu is advantageous
Qualifications & Experience
- Minimum 3 years of experience in data engineering, ETL development, or data migration delivery
- Bachelor's degree in Computer Science, Information Technology, or a related engineering discipline
- Banking or financial services experience is advantageous
- Demonstrated ability to deliver technical workstreams independently within defined standards and timelines
- Early experience reviewing or guiding junior team members is a plus
Core Competencies
- Strong analytical mindset with attention to detail and commitment to data accuracy
- Ability to manage own workload effectively within a structured delivery environment
- Clear and concise communication skills, able to escalate issues and report progress to senior team members
- Collaborative team player who contributes positively to team delivery and knowledge sharing
- Eagerness to grow into broader technical leadership responsibilities over time