Associate Data Engineer - ETL Pipelines & Cloud Data (Hybrid)

Capgemini; Pittsburg (CA); Hybrid; USD 75,000 - 83,000; Full time

Benefits offered by this job

Vacation 12-25 days

Medical, dental, and vision coverage

401(k) retirement savings

Job summary

Capgemini is seeking an Associate Data Engineer to design, develop, test, and maintain data integration solutions across enterprise platforms. You will build ETL/ELT processes, data pipelines, and validations while ensuring quality and governance.

The role collaborates with solution architects and analysts in Agile delivery teams, supports cloud migration, and develops SQL queries, Python scripts, and data quality controls as part of a broader data engineering practice.

Qualifications

• Experience designing and maintaining ETL/ELT jobs and data pipelines.
• Proficient in SQL development and query optimization.
• Basic Python scripting.
• Familiarity with data warehousing concepts.
• Experience with cloud data platforms (Azure, AWS, GCP).
• Knowledge of data quality and validation techniques.
• Familiarity with Agile delivery.
• Bachelor's degree in CS/IT/Engineering/Math or related.

Responsibilities

• Develop and maintain ETL/ELT jobs, workflows, and data pipelines.
• Perform data extraction, transformation, and loading from multiple source systems.
• Create and execute unit tests, integration tests, and data validation scripts.
• Support UAT and issue resolution.
• Monitor data pipelines and troubleshoot processing issues.
• Develop SQL queries and stored procedures.
• Assist in cloud migration and modernization initiatives.
• Collaborate with solution architects, BI, and senior data engineers in Agile teams.

Skills

ETL/ELT

SQL

Python

Relational databases

Data quality

Cloud platforms

Agile

DevOps/DataOps

Data warehousing

Airflow

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, Mathematics, or a related discipline

Tools

Snowflake

Azure Synapse

Databricks

BigQuery

Redshift

Spark

Hadoop

Kafka

Airflow

Data Factory

Informatica

Talend

SSIS

Job description

Capgemini is seeking an Associate Data Engineer to design, develop, test, and maintain data integration solutions across enterprise platforms. You will build ETL/ELT processes, data pipelines, and validations while ensuring quality and governance.

The role collaborates with solution architects and analysts in Agile delivery teams, supports cloud migration, and develops SQL queries, Python scripts, and data quality controls as part of a broader data engineering practice.