Job Title: ETL Developer Location: Rosemont, IL Duration: 6 Months Experience: 6-8 Years Job ID: 10466036
Role Summary We are seeking an experienced ETL Developer with strong expertise in SQL Server SSIS and Data Warehousing solutions. The ideal candidate will be responsible for designing, developing, and optimizing end-to-end data pipelines to support reporting and analytical platforms.
Key Responsibilities • Design, develop, and maintain batch ETL/ELT processes using SQL Server and SSIS. • Build and manage complete data pipelines for ODS staging, data warehouse, and data marts. • Write, optimize, and maintain complex SQL queries, stored procedures, and T-SQL scripts. • Implement and support data warehouse solutions using Star Schema and Snowflake Schema. • Perform large-scale data processing and apply query optimization techniques for high performance. • Implement audit balance and control mechanisms to ensure data accuracy and integrity.
Collaboration and Support Collaborate with business and technical teams to support data analysis and reporting needs. Ensure ETL processes follow best practices for scalability, performance, and reliability.
Required Skills & Experience
• 6-8 years of overall IT experience with a strong focus on ETL and Data Warehousing. • 3 years of hands-on experience with SQL Server and SSIS. • 3 years of experience writing and optimizing SQL queries and stored procedures. • 3 years of experience designing and building end-to-end ETL pipelines. • 3 years of experience implementing Data Warehouse solutions for analytics and reporting. • 3 years of experience with T-SQL and query optimization techniques. • 2 years of experience implementing data audit reconciliation and control mechanisms. • Strong understanding of Data Warehousing concepts, including 3NF and dimensional modeling. • Solid knowledge of data modeling techniques in DW environments.
Education Bachelors or Masters degree in Computer Science, Engineering, Mathematics, or a related quantitative field.