ETL Developer

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.
• 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 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

• Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or a related quantitative field.