Senior Data Engineer: Modernize ETL with Python & AI

Capgemini; Bridgewater (MA); Hybrid; USD 80,000 - 106,000; Full time

Benefits offered by this job

Flexible work

Health insurance

401(k)

Paid time off

Job summary

Capgemini in Smithfield, RI is seeking a Senior Data Engineer to drive data modernization, assess Informatica workflows, and lead Python-based ETL development. You will design scalable pipelines and collaborate with cross-functional teams to deliver reliable data solutions.

You will mentor junior engineers, apply AI-assisted tooling to accelerate analysis, and help migrate from legacy platforms to modern data architectures.

Qualifications

• 6–9 years of data engineering experience.
• Proficient in Informatica, Python ETL and SQL.
• Experience with AWS-based data solutions and Java Spring Batch.

Responsibilities

• Analyze and modernize Informatica workflows.
• Design scalable Python ETL pipelines and SQL data models.
• Lead migration from legacy ETL to Python-based solutions.
• Develop batch processing with Java Spring Batch.
• Profile data, assess impact, and optimize workflows.
• Collaborate with architects and analysts; mentor junior engineers.

Skills

Informatica

Python ETL

SQL

Java Spring Batch

AWS

AI-assisted development

Job description

Capgemini in Smithfield, RI is seeking a Senior Data Engineer to drive data modernization, assess Informatica workflows, and lead Python-based ETL development. You will design scalable pipelines and collaborate with cross-functional teams to deliver reliable data solutions.

You will mentor junior engineers, apply AI-assisted tooling to accelerate analysis, and help migrate from legacy platforms to modern data architectures.