ETL Developer

Robotics Technologies LLC

Rosemont, IL, United States

about 2 months ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Third Normal Form Data Analysis Big Data Extract Transform Load (ETL) Data Mart Data Transformation Data Systems Data Warehousing Microsoft SQL Server Query Optimization SQL Stored Procedures SQL Server Integration Services

+5 more

Transact-SQL Data Processing Information Technology Star Schema Data Pipelines

Requirements

Do you have experience in T-SQL?, 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 Employer