ETL Developer

MACHINE LEARNING TECHNOLOGIES LLC; Rosemont (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC is seeking an ETL Developer in Rosemont, IL for a 15-month engagement with potential extension. You will develop and optimize batch ETL/ELT processes, build complete data pipelines, and implement data warehouse solutions using SQL Server, SSIS, and related technologies.

Strong data modeling and DW concepts are required. Ideal candidates have 8+ years of experience in data engineering, performant SQL, and experience with Star/Snowflake schemas, audits, and data

Qualifications

• Bachelor’s or master's with 3+ experience in Computer Science, Engineering, Math or another quantitative field.
• 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance.
• 3+ 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' 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' Experience with large-scale data processing and query optimization techniques using TSQL.
• 2+ years' Experience with implementing audit, balance, and control mechanism in data solutions.
• Strong understanding of DW concepts including 3NF and Dimensional data models.
• Good understanding of Data Modeling techniques in Data Warehousing projects.

Skills

ETL

Data warehouse

SQL Server

SSIS

T-SQL

Data modeling

DW concepts

Star/Snowflake schemas

Data pipelines

Data quality controls

Education

Bachelor’s or Master’s in CS/Engineering/Math

Tools

SQL Server

SSIS

Job description

Job Description

• Job ID: J52869
• Job Title: ETL Developer
• Location: Rosemont, IL
• Duration: 15 Months + Extension
• Domain Exposure: Retail
• Work Authorization: US Citizen,Green Card,OPT-EAD,CPT,H-1B,H4-EAD,L2-EAD,GC-EAD
• Client: To Be Discussed Later
• Employment Type: W-2, 1099, C2C
• Total Exp: 8+ Years
• Skills: ETL, Data Warehouse solutions

• Bachelor’s or master's with 3+ experience in Computer Science, Engineering, Math or another quantitative field.
• 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance.
• 3+ 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' 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' Experience with large-scale data processing and query optimization techniques using TSQL.
• 2+ years' Experience with implementing audit, balance, and control mechanism in data solutions.
• Strong understanding of DW concepts including 3NF and Dimensional data models.
• Good understanding of Data Modeling techniques in Data Warehousing projects.

Equal Opportunity EmployerWe are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.