Senior ETL Developer: Data Pipelines & Automation Lead

Capgemini; Atlanta (GA); On-site; USD 85,000 - 95,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, vision coverage

401(k) retirement plans

Life and disability insurance

Employee assistance programs

Job summary

Capgemini is seeking a skilled data engineer to design, develop, and maintain scalable ETL workflows for data ingestion and integration. You will build data processing solutions using Python and optimize Oracle PL/SQL packages and queries, while automating deployments with Ansible.

You will collaborate with business analysts, architects and DBAs to ensure data governance and high-quality data pipelines, supporting production deployments and incident resolution.

Qualifications

• Design, develop and maintain scalable ETL workflows for data ingestion, transformation and integration.
• Build data processing solutions using Python and related frameworks/libraries.
• Develop and optimize Oracle PL/SQL packages, procedures, functions, triggers and queries.
• Automate deployment, configuration management and operational processes using Ansible.
• Perform data modeling, data validation and reconciliation.

Responsibilities

• Design, develop and maintain scalable ETL workflows.
• Build data processing solutions using Python.
• Develop and optimize Oracle PL/SQL packages and queries.
• Automate deployments and configurations with Ansible.
• Monitor ETL jobs and troubleshoot performance issues.
• Collaborate with analysts, architects, DBAs and development teams.
• Implement data governance, security and compliance standards.

Skills

ETL workflows

Python

Oracle PL/SQL

Ansible

Data modeling

Data validation

Batch processing

Data governance

Tools

Python

Oracle PL/SQL

Ansible

Job description

Capgemini is seeking a skilled data engineer to design, develop, and maintain scalable ETL workflows for data ingestion and integration. You will build data processing solutions using Python and optimize Oracle PL/SQL packages and queries, while automating deployments with Ansible.

You will collaborate with business analysts, architects and DBAs to ensure data governance and high-quality data pipelines, supporting production deployments and incident resolution.