Job Title: ETL SSIS Developer
Location: ChicagoIL (Onsite)
Job Type: Contract (Long term)
Job Description:
Primary Skills: Data warehousing ETL SSIS Data model MSBI and Python.
Responsibilities:
- Bachelors with 7 or Masters with 5 experience in Computer Science Engineering Math or other quantitative field.
- 7 Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets bestinclass standards offering high performance.
- 7 experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
- 7 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.
- 7 years experience Implementing Data Warehouse solutions (Star Schema Snowflake schema) for reporting and analytical applications using SQL Server and SSIS or other related technologies.
- 5 years Experience with largescale data processing and query optimization techniques using TSQL.
- 5 years Experience with implementing audit balance and control mechanism in data solutions
- 3 year experience with any source control repos like GIT TFVC or Azure DevOps including branching and merging and implement CICD pipelines for database and ETL workloads.
- 2 experience working with Python Pandas libraries to process semi structured data sets and load them to SQL Server DB.
- Strong understanding of DW concepts including 3NF and Dimensional data models.
- 5 years experience with Data Modeling techniques in Data Warehousing projects using any tool like Erwin Visio ER studio.
- Has indepth knowledge of ETL Design Patterns Optimal Data Flow mechanisms and SQL development best practices.
- Perform peer reviews and take ownership of the data processes to ensure quality of data in data warehouse downstream data marts.
- Experience working on Banking and Financial domain is preferred.
- Experience with mentoring team members guide them to follow best practices.
- Must be selfdirected and have excellent initiative and organization skills.