Job Details

Email to Friend Save Back

ETL Developer

OAKBROOK TER-60181, IL, US
12/11/2018

-

Required Skills

MySQL

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

ETL Developer

Basic Function:

As part of an exciting new warehouse project, the ETL Developer will be primarily responsible for implementing ETL processes that populate Kimball style star schemas using a variety of source data on multiple new SQL Server 2014 data warehouse implementations supporting products, services and marketing efforts.

They will also participate in the requirements gathering process and assist with designing the business process dimensional models.

The candidate will have a deep understanding of both OLTP and star schemas with OLAP being a huge plus.

Further, they will do deep analysis on source data to determine the feasibility of using this data to solve business needs.

The resulting ETL processes should be scalable, efficient, audited and as re-usable as possible.

Database experience working with: MS SQL Server, MySQL

Experience with Data Warehousing and Business Intelligence projects.

Experience working with ETL tool sets, such as SSIS or Informatica

Dimensional modeling experience

Experience with AWS services

Experience pulling data from a variety of data source types

Familiarity with dimensional modeling and star schemas

Strong experience interfacing with business users and understanding their requirements.

Experience with OLAP is strongly preferred.

R data slicing experience a plus

Team player – Diplomatically collaborate with departments to develop and support our internal data platform and to support ongoing analyses

Specific Responsibilities:

1. Develop, design, tune and maintain SSIS packages to perform the ETL process.

2. Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.

3. Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball style dimensional models.

4. Write scripts for automated testing of data in the target facts and dimensions.

5. Capture audit information during all phases of the ETL process.

6. Write and maintain documentation of the ETL processes via process flow diagrams.

7. Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.

8. Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.

9. Collaborate with business users, other data services team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.

10. Extract, validate, transform and summarize data generated from database and reporting tools to be used in acquisition and activation programs.

11. Performs other duties as assigned.