Data Migration Engineer

Capgemini • Dallas, TX

2h • Onsite

About The Position

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world. This role involves pipeline migration, data transfer, stakeholder engagement, consumption pattern migration, and data reconciliation to ensure migrated data meets business requirements and is functionally equivalent to production flows. The Data Engineer will also work with internal data management platforms and must be adaptable to learning new workflows and language constructs.

Requirements

• Minimum of 3-5 years of professional hands-on keyboard coding experience in a collaborative team-based environment.
• Ability to troubleshoot SQL and basic scripting experience.
• Professional proficiency in Python or Java.
• Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices.
• K8s deployment experience.
• Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation: Temporal Data Modeling (Managing state changes over time, e.g., SCD Type 2), Schema Management (Expertise in Schema Evolution, Ref Iceberg Apache, and enforcement strategies), Performance Optimization (Advanced knowledge of data partitioning and clustering), Architectural Theory (Balancing Normalization vs Denormalization and the strategic use of Natural vs Surrogate Keys).

Nice To Haves

• While candidates are not expected to be experts in every tool, the collective team must cover the following technologies: Extraction Logic, Kafka, ANSI SQL, FTP, Apache Spark.

Responsibilities

• Logic Scheduling Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
• Executing the physical migration of underlying datasets while ensuring data integrity.
• Acting as a technical liaison to internal clients facilitating handoff and signoff conversations with data owners to ensure migrated assets meet business requirements.
• Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
• Understanding usage patterns to deliver the required data products.
• A rigorous approach to data validation is required. Candidates must work with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows.
• Work with internal data management platforms team and must have an aptitude for learning new workflows and language constructs as necessary.

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
• Vacation: 12-25 days, depending on grade
• Company paid holidays
• Personal Days
• Sick Leave
• Medical, dental, and vision coverage
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed