Senior ETL Developer

Capgemini•New York, NY

1d•$105,000 - $115,000•Onsite

About The Position

We are looking for a skilled ETL Developer to design, develop, and maintain scalable data pipelines within the I&D (Insights & Data) ecosystem. The role involves transforming raw data into meaningful insights by building robust ETL workflows, ensuring data quality, and supporting analytics, BI, and reporting needs.

Requirements

Skilled ETL Developer to design, develop, and maintain scalable data pipelines
Transforming raw data into meaningful insights by building robust ETL workflows
Ensuring data quality
Supporting analytics, BI, and reporting needs
Experience with tools like Informatica, Talend, SSIS, DataStage, or similar
Experience extracting data from various sources (databases, APIs, flat files, cloud storage)
Experience transforming data according to business rules and loading into data warehouses/data lakes
Experience developing reusable and scalable data workflows
Experience ensuring data accuracy, consistency, and integrity
Experience implementing data validation and cleansing logic
Experience handling large datasets and optimizing performance for batch and streaming processes
Experience with cloud platforms like Azure (ADF, Synapse), AWS (Glue, Redshift), GCP (Dataflow, BigQuery)
Experience building and maintaining data lake architectures
Experience with ELT using SQL-based transformations
Experience collaborating with Data Analysts, BI Developers, Data Scientists, and Business Teams
Experience understanding data requirements and translating them into technical solutions
Experience supporting reporting and dashboard needs
Experience troubleshooting ETL failures and data issues
Experience optimizing pipeline performance and scheduling
Experience automating workflows and monitoring processes.

Responsibilities

Design, build, and optimize ETL/ELT pipelines using tools like Informatica, Talend, SSIS, DataStage, or similar
Extract data from various sources (databases, APIs, flat files, cloud storage)
Transform data according to business rules and load into data warehouses/data lakes
Develop reusable and scalable data workflows
Ensure data accuracy, consistency, and integrity
Implement data validation and cleansing logic
Handle large datasets and optimize performance for batch and streaming processes
Work with cloud platforms like Azure (ADF, Synapse), AWS (Glue, Redshift), GCP (Dataflow, BigQuery)
Build and maintain data lake architectures
Work on ELT using SQL-based transformations
Collaborate with Data Analysts, BI Developers, Data Scientists, and Business Teams
Understand data requirements and translate them into technical solutions
Support reporting and dashboard needs
Troubleshoot ETL failures and data issues
Optimize pipeline performance and scheduling
Automate workflows and monitoring processes.

Benefits

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume