Senior ETL Developer

Capgemini; Charlotte (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

Capgemini in Charlotte, NC is seeking a data engineer to design, develop, and maintain scalable ETL workflows for data ingestion, transformation, and integration. You will build custom data processing solutions using Python and related frameworks and libraries.

Responsibilities include developing and optimizing Oracle PL/SQL packages, procedures, functions, triggers, and queries; automating deployments and configuration management with Ansible; and supporting production deployments while

Responsibilities

• Design, develop, and maintain scalable ETL workflows for data ingestion, transformation, and integration
• Build custom data processing solutions using Python and related frameworks, libraries
• Develop and optimize Oracle PL/SQL packages, procedures, functions, triggers, and queries
• Automate application deployment, configuration management, and operational processes using Ansible
• Perform data modeling, data validation, and reconciliation activities
• Create and support batch processing frameworks and scheduling solutions
• Develop reusable Ansible playbooks, roles, and inventories for infrastructure and application automation
• Monitor ETL jobs and troubleshoot performance bottlenecks, failures, and data quality issues
• Collaborate with business analysts, architects, DBAs, and development teams to gather requirements and implement solutions
• Implement data governance, security, and compliance standards
• Participate in code reviews and establish best practices for ETL development and automation
• Support production deployments and provide incident resolution for critical data pipelines

Job description

• Design develop and maintain scalable ETL workflows for data ingestion transformation and integration
• Build custom data processing solutions using Python and related frameworks libraries
• Develop and optimize Oracle PLSQL packages procedures functions triggers and queries
• Automate application deployment configuration management and operational processes using Ansible
• Perform data modeling data validation and reconciliation activities
• Create and support batch processing frameworks and scheduling solutions
• Develop reusable Ansible playbooks roles and inventories for infrastructure and application automation
• Monitor ETL jobs and troubleshoot performance bottlenecks failures and data quality issues
• Collaborate with business analysts architects DBAs and development teams to gather requirements and implement solutions
• Implement data governance security and compliance standards
• Participate in code reviews and establish best practices for ETL development and automation
• Support production deployments and provide incident resolution for critical data pipelines