Data Migration Specialist

Job Description

• We are seeking an experienced Data Migration Specialist to design, develop, and execute end-to-end data migration activities across enterprise applications.
• The successful candidate will work closely with business stakeholders, solution architects, developers, and testing teams to ensure accurate, secure, and timely migration of data from legacy systems into target platforms while maintaining data quality and integrity.

Key Responsibilities::

Migration Planning

• 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.

Data Analysis & Mapping

• Analyse source and target data models.
• Define field-level data mappings and transformation rules.
• Identify data cleansing requirements.
• Validate business rules with functional stakeholders.

Data Extraction, Transformation & Loading (ETL)

• 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.

Data Quality

• Perform data profiling and quality assessment.
• Identify duplicate, incomplete, or inconsistent data.
• Execute cleansing and enrichment activities.
• Ensure compliance with data governance standards.

Testing & Validation

• Support SIT, UAT, and production rehearsals.
• Perform reconciliation between source and target systems.
• Validate migrated data with business users.
• Resolve migration defects.

Cutover & Deployment

• Execute production migration activities.
• Support mock migrations and dress rehearsals.
• Coordinate with infrastructure and application teams.
• Support hypercare after go-live.

Documentation

• Prepare migration runbooks.
• Maintain mapping documents.
• Document migration procedures.
• Produce reconciliation reports.
• Maintain audit evidence.

Required Skills::

• 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::

• SQL
• ETL development
• Data profiling
• Data cleansing
• Data reconciliation
• Data modelling
• Database administration basics
• Performance tuning
• Migration automation

Databases::

• Oracle
• SQL Server
• PostgreSQL
• MySQL
• DB2

ETL / Integration Tools::

• Informatica
• Talend
• SSIS
• Azure Data Factory
• AWS Glue
• IBM DataStage

Cloud (Preferred)

• Microsoft Azure
• AWS
• Google Cloud Platform

Scripting::

• Python
• PowerShell
• Shell scripting