Data Engineer: Modern ETL Pipelines (Python/Java) | Hybrid

Capgemini; Smithfield, Northern (RI, KY); Hybrid; USD 56,000 - 88,000; Full time

Benefits offered by this job

Healthcare

401(k)

Paid time off

Paid holidays

Paid parental leave

Adoption assistance

Surrogacy

Cryopreservation

Backup care

Tutoring

Mentoring

Learning programs

ERGs

Job summary

Capgemini in Smithfield RI is hiring a Data Engineer to modernize ETL workflows, analyze Informatica, and develop Python-based ETL pipelines with SQL. The role includes building batch-processing with Java Spring Batch and supporting migration to cloud architectures.

You will collaborate with business, data, and engineering teams to translate requirements into scalable solutions, participate in testing, deployment, and production support, and leverage AI-assisted tools to improve delivery.

Qualifications

• ETL development and migration experience (preferably Informatica).
• Strong Java and Spring Boot.
• Python ETL.

Responsibilities

• Analyze existing Informatica workflows, mappings, and data transformations to support modernization efforts.
• Develop and maintain ETL pipelines using Python and SQL.
• Build and enhance batch-processing solutions using Java Spring Batch.
• Support migration of legacy data workflows to modern cloud-based architectures.
• Perform data analysis, data validation, and reconciliation activities to ensure data quality.
• Utilize AI-assisted development tools such as GitHub Copilot and Generative AI solutions to improve delivery efficiency.
• Collaborate with business, data, and engineering teams to translate requirements into scalable solutions.
• Participate in testing, deployment, and production support activities.

Skills

ETL development

Java

Spring Boot

Python ETL

Tools

Informatica

Job description

Capgemini in Smithfield RI is hiring a Data Engineer to modernize ETL workflows, analyze Informatica, and develop Python-based ETL pipelines with SQL. The role includes building batch-processing with Java Spring Batch and supporting migration to cloud architectures.

You will collaborate with business, data, and engineering teams to translate requirements into scalable solutions, participate in testing, deployment, and production support, and leverage AI-assisted tools to improve delivery.