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