Data Migration Engineer - ETL Pipelines (Hybrid)

Capgemini; Town of Texas, Northern (WI, KY); Hybrid; USD 56,000 - 88,000; Full time

Benefits offered by this job

Flexible work

401(k) and ESOP

Paid time off

Job summary

Capgemini is seeking a Junior Data Migration Engineer to join our Westlake TX team. The role focuses on building and maintaining ETL/ELT pipelines, performing data extraction, transformation, and loading tasks, and supporting validation under guidance from senior engineers.

You will collaborate with a team to define data mappings, execute data validation, and resolve data quality issues while contributing to migration tests and runbooks.

Qualifications

• 3-6 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.
• Hand-on experience with performance optimization and tuning approaches, SQL Tuning.
• Familiarity with ETL tools (Informatica) and data platforms.

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

SQL

Python

Data engineering

ETL/ELT

Data validation

Azure

Large data sets

Tools

Informatica

Job description

Capgemini is seeking a Junior Data Migration Engineer to join our Westlake TX team. The role focuses on building and maintaining ETL/ELT pipelines, performing data extraction, transformation, and loading tasks, and supporting validation under guidance from senior engineers.

You will collaborate with a team to define data mappings, execute data validation, and resolve data quality issues while contributing to migration tests and runbooks.