Data Migration Specialists/ Consultants (Ref 26537)

Responsibilities

• Define end-to-end data migration strategy and execution approach.

• Perform source system analysis and data discovery.

• Develop migration plans, timelines, and cutover activities.

• Assess migration risks and mitigation strategies.

• Analyse source and target data models.

• Define field-level data mappings and transformation rules.

• Identify data cleansing requirements.

• Validate business rules with functional stakeholders.

• Develop and execute ETL processes.

• Extract data from multiple source systems.

• Transform data according to business requirements.

• Load data into target applications.

• Monitor migration performance and resolve failures.

• Perform data profiling and quality assessment.

• Identify duplicate, incomplete, or inconsistent data.

• Execute cleansing and enrichment activities.

• Ensure compliance with data governance standards.

• Support SIT, UAT, and production rehearsals.

• Perform reconciliation between source and target systems.

• Validate migrated data with business users.

• Resolve migration defects.

• Execute production migration activities.

• Support mock migrations and dress rehearsals.

• Coordinate with infrastructure and application teams.

• Support hypercare after go-live.

• Prepare migration runbooks.

• Maintain mapping documents.

• Document migration procedures.

• Produce reconciliation reports.

• Maintain audit evidence.

Requirements

• Bachelor in Computer Science / Technology with at least 5 years of experience in data migration or data engineering.

• Experience delivering large-scale transformation or migration programmes.

• Hands-on experience with ETL tools.

• Experience migrating structured and unstructured data.

• Strong SQL skills.

• Experience with data validation and reconciliation.

• Experience working in Agile and Waterfall delivery environments.

• Technical Skills required :

1. SQL

2. ETL development

3. Data profiling

4. Data cleansing

5. Data reconciliation

6. Data modelling

7. Database administration basics

8. Performance tuning

9. Migration automation

10. Databases : Oracle , SQL Server, PostgreSQL, MySQL, DB2

11. ETL / Integration Tools : Informatica, Talend, SSIS, Azure Data Factory, AWS Glue, IBM DataStage

12. Ideally with Cloud experience : Microsoft Azure, AWS, Google Cloud Platform

13. Scripting : Python, PowerShell, Shell scripting

Licence no: 12C6060