Data Migration Specialist: End-to-End ETL & Validation

Amtis - Digital, Technology, Transformation; West Midlands; On-site; GBP 42,000 - 62,000; Full time

Job summary

Amtis - Digital, Technology, Transformation is seeking an experienced Data Migration Analyst to support a programme of complex data migration and integration activities. You will cover the full migration lifecycle from understanding legacy data and mapping rules through ETL, testing, reconciliation and post-migration support.

The role requires proven experience in data migration or data integration, strong data mapping and ETL expertise, and hands-on work with migration tools.

Qualifications

• Proven experience in a Data Migration or Data Integration role.
• Strong understanding of data mapping, ETL and data transformation.
• Experience with data migration tools and complex system migrations.

Responsibilities

• Supporting end‑to‑end migration of data from legacy into new environments.
• Analysing source-system data and identifying data quality issues.
• Defining and documenting mappings between legacy and target systems.
• Extracting, transforming and loading data in line with migration requirements.
• Translating business requirements into technical data mappings and rules.
• Developing and executing migration test plans and scripts.
• Reconciling migrated data to ensure completeness and accuracy.
• Troubleshooting migration issues and supporting post‑migration activity.
• Maintaining clear documentation covering mappings, transformations and quality checks.
• Working closely with business users, technical teams, vendors and programme stakeholders.
• Contributing to migration strategy, planning and execution.

Skills

Data migration

Data integration

ETL

Python

Excel

Tools

Python

Excel

Data migration tools

Job description

Amtis - Digital, Technology, Transformation is seeking an experienced Data Migration Analyst to support a programme of complex data migration and integration activities. You will cover the full migration lifecycle from understanding legacy data and mapping rules through ETL, testing, reconciliation and post-migration support.

The role requires proven experience in data migration or data integration, strong data mapping and ETL expertise, and hands-on work with migration tools.