Lead Data Migration Engineer

Capgemini•Dallas, TX

2d•$103,330 - $128,656•Hybrid

About The Position

Capgemini is seeking an experienced Data Migration Engineer who executes data migration tasks, builds pipelines, and supports validation efforts under guidance from senior engineers.

Requirements

10 years of experience in data engineering or related roles
Proficiency in SQL and at least one programming language (Python preferred)
Solid experience in writing complex SQL queries
Hands-on experience with performance optimization and tuning approaches (SQL Tuning)
Familiarity with ETL tools (Informatica) and data platforms
Understanding of data modeling and databases
Familiarity with distribution application design and development (Java, .Net, Python would be a plus)
Familiarity with large, complex system design
Public Cloud experience (Microsoft Azure preferred)
Experience working 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

Benefits

Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
Paid time off and paid holidays
Paid parental leave
Family building benefits like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Disaster Relief