ETL Developer

TCS • Chicago, IL

1d

About The Position

This role requires a skilled ETL Developer with a Bachelor's or Master's degree in Computer Science, Engineering, Math, or another quantitative field, and over 3 years of experience. The primary focus will be on developing high-performance Batch ETL/ELT processes using SQL Server and SSIS, ensuring data pipelines meet best-in-class standards. The developer will be responsible for writing and optimizing SQL queries and stored procedures for data processing and analysis, designing and building complete data pipelines for ODS, Staging, Data Warehousing, and Data Marts, and implementing Data Warehouse solutions using SQL Server and SSIS. Experience with large-scale data processing, query optimization using TSQL, and implementing audit, balance, and control mechanisms is essential. A strong understanding of Data Warehousing concepts, including 3NF and Dimensional data models, as well as Data Modeling techniques, is also required.

Requirements

• Bachelor’s or master's degree in Computer Science, Engineering, Math or another quantitative field.
• 3+ years of experience in developing Batch ETL/ELT processes using SQL Server and SSIS.
• 3+ years of experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
• 3+ years of experience in designing and building complete data pipelines, moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using SQL Server Integration Services (ETL) or other related technologies.
• 3+ years of experience implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS, or other related technologies.
• 3+ years of experience with large-scale data processing and query optimization techniques using TSQL.
• 2+ years of experience implementing audit, balance, and control mechanisms in data solutions.
• Strong understanding of DW concepts including 3NF and Dimensional data models.
• Good understanding of Data Modeling techniques in Data Warehousing projects.

Responsibilities

• Developing Batch ETL/ELT processes using SQL Server and SSIS.
• Ensuring all related data pipelines meet best-in-class standards offering high performance.
• Writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
• Designing and building complete data pipelines, moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using SQL Server Integration Services (ETL) or other related technologies.
• Implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS, or other related technologies.
• Implementing audit, balance, and control mechanisms in data solutions.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level