Junior Data Migration Engineer: Build ETL Pipelines

Capgemini; Bridgewater (MA); Hybrid; USD 56,000 - 88,000; Full time

Job summary

Capgemini is seeking a Junior Data Migration Engineer to join our Westlake TX / Merrimack NH team. You will develop and maintain ETL/ELT pipelines, perform data extraction, transformation and loading tasks, and validate data under guidance from senior engineers.

You will help define data mappings, run data quality checks, and collaborate during migration testing in a hybrid on-site environment. The role requires 3-6 years in data engineering, strong SQL and Python skills, and familiarity with

Qualifications

• 3-6 years of experience in data engineering or related roles.
• Proficiency in SQL and Python.
• Ability to write complex SQL queries.
• Experience with performance tuning and SQL optimization.
• 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.
• Public Cloud experience (Microsoft Azure preferred).

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

ETL

Informatica

Data Modeling

Java

.NET

Azure

Tools

Informatica

Job description

Capgemini is seeking a Junior Data Migration Engineer to join our Westlake TX / Merrimack NH team. You will develop and maintain ETL/ELT pipelines, perform data extraction, transformation and loading tasks, and validate data under guidance from senior engineers.

You will help define data mappings, run data quality checks, and collaborate during migration testing in a hybrid on-site environment. The role requires 3-6 years in data engineering, strong SQL and Python skills, and familiarity with