Hybrid Data Migration Engineer: Lead Pipelines & Validation

Capgemini; Dallas (TX); Hybrid; USD 103,000 - 129,000; Full time

Benefits offered by this job

Medical/dental/vision

401(k)

Paid time off

Job summary

Capgemini seeks an experienced Data Migration Engineer to execute data migration tasks, build pipelines, and support validation under guidance from senior engineers. The role involves developing ETL/ELT pipelines, performing extract, transform, load, and validation, and collaborating on migration testing.

Responsibilities include defining data mappings, resolving data quality issues, and documenting processes.

Qualifications

• 10 years of experience in data engineering or related roles.
• Proficiency in SQL and at least one programming language Python preferred.
• Experience with complex SQL queries.
• Hands-on with performance optimization and SQL tuning.
• Familiarity with ETL tools Informatica and data platforms.
• Understanding of data modeling and databases.
• Familiarity with Java/Net/Python; Java experience is a plus.
• Familiarity with large system design.
• Public Cloud experience; Microsoft Azure preferred.
• Experience with large data sets.
• Strong problem solving and analytical skills.

Responsibilities

• Develop and maintain ETL/ELT pipelines.
• Perform data extraction, transformation, and loading tasks.
• Assist in defining data mappings and transformation rules.
• Execute data validation and reconciliation checks.
• Identify and resolve data quality issues.
• Collaborate with team members on migration testing.
• Document processes and support runbooks/playbooks.

Skills

10+ years exp

SQL

Python

Data modeling

System design

Big data

Analytical skills

Tools

Informatica

Azure

Job description

Capgemini seeks an experienced Data Migration Engineer to execute data migration tasks, build pipelines, and support validation under guidance from senior engineers. The role involves developing ETL/ELT pipelines, performing extract, transform, load, and validation, and collaborating on migration testing.

Responsibilities include defining data mappings, resolving data quality issues, and documenting processes.