Data Migration Specialist

ELLIOTT MOSS CONSULTING PTE. LTD.

Dublin

On-site

EUR 65,000 - 95,000

Full time

4 days ago
Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

ELLIOTT MOSS CONSULTING PTE. LTD.

seeks an experienced Data Migration Specialist to design, develop, and execute end-to-end data migration activities across enterprise applications in Ireland. You will work with business stakeholders, solution architects, developers, and testing teams to ensure accurate, secure, and timely migration while maintaining data quality and integrity across complex data landscapes.

Qualifications

  • 5+ years 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.

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.
  • Develop and execute ETL processes and load data.
  • Monitor migration performance and resolve failures.
  • Perform data profiling and quality assessment.
  • Validate migrated data with business users.
  • Coordinate with infrastructure and application teams during cutover.
  • Prepare migration runbooks and maintain mapping documents.

Skills

Data migration
Large-scale transformation
ETL tools
Structured & unstructured data
SQL
Data validation
Agile & Waterfall

Tools

Informatica
Talend
SSIS
Azure Data Factory
AWS Glue
IBM DataStage
Cloud
Microsoft Azure
AWS
Google Cloud Platform

Job description

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
Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Senior Data Migration Specialist — ETL & Data Quality Expert
Senior Data Migration Specialist — ETL & Data Quality Expert

ELLIOTT MOSS CONSULTING PTE. LTD. • Dublin

On-site
EUR 65,000 - 95,000
Senior Data Engineer
Senior Data Engineer

PlaceMe Recruitment • Galway

On-site
USD 69,000 - 117,000
Senior Database, Data Warehouse Consultant
Senior Database, Data Warehouse Consultant

Jobtailor • Dublin

On-site
EUR 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Reperio Human Capital • Ireland

On-site
EUR 50,000 - 90,000
Data Architect
Data Architect

Test Triangle Limited • Ireland

Hybrid
EUR 90,000 - 130,000
Data Architect
Data Architect

Test Triangle • Newbridge

Hybrid
EUR 90,000 - 130,000
IT System Engineer - Migration
IT System Engineer - Migration

Technopride Ltd • Dublin

Hybrid
EUR 55,000 - 75,000
Software Development Engineer II — AWS DMS Schema Conversion Team, DMS Schema Conversion
Software Development Engineer II — AWS DMS Schema Conversion Team, DMS Schema Conversion

Amazon • Dublin

On-site
EUR 70,000 - 90,000
Software Development Engineer II — AWS DMS Schema Conversion Team, DMS Schema Conversion
Software Development Engineer II — AWS DMS Schema Conversion Team, DMS Schema Conversion

Amazon Web Services (AWS) • Dublin

On-site
EUR 120,000 - 160,000
Database Engineer, AWS DMS
Database Engineer, AWS DMS

Amazon Web Services (AWS) • Dublin

On-site
EUR 90,000 - 120,000