Data Migration Engineer

Capgemini•Dallas, TX

1d•$80,420 - $106,050•Onsite

About The Position

Data Engineer will be part of the data store migration factory team that will be responsible to perform for the end to end datastore migration from on prem Data Lake to AWS hosted Lake House. This is a high visibility and crucial project for us.

Requirements

Bachelors or Masters in Computer Science Applied Mathematics Engineering or a related quantitative field
Minimum of 5 years of professional hands on keyboard coding experience in a collaborative team based environment.
Ability to trouble shoot SQL and basic scripting experience.
Professional proficiency in Python or Java
Deep familiarity with the full Software Development Life Cycle SDLC and CICD best practices
Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation a Temporal Data Modeling Managing state changes over time eg 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

Responsibilities

Pipeline Migration a Logic Scheduling Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
Data Transfer Executing the physical migration of underlying datasets while ensuring data integrity.
Stakeholder Engagement Acting as a technical liaison to internal clients facilitating handoff and signoff conversations with data owners to ensure migrated assets meet business requirements.
Consumption Pattern Migration a Code Conversion Translating and optimizing legacy SQL and Spark based consumption patterns raw and modeled for compatibility with Snowflake and Iceberg
Usage analysis understand usage patterns to deliver the required data products.
Data Reconciliation Quality 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 Engineer will also need to 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
Life and disability insurance
Employee assistance programs