Job Details

Email to Friend Save Back

Senior ETL Developer

CHICAGO-60607, IL, US
11/30/2018

-

Required Skills

XML

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

Senior ETL Developer

This position will serve as the lead developer & designer of the Enterprise Data Warehouse (EDW).

The role is responsible for architecture and development of Azure SQL Data Warehouse and working with business analysts and report developers to achieve the reporting and business intelligence goals of the business.

This person will be involved in designing and implementing data processing pipelines, data cleansing, standardization, data profiling, and enrichment process with the goal of populating a company-wide data warehouse.

Ideally, this candidate should have previous experience with Microsoft data warehousing practices.

Including SSAS and SSIS and have a firm understanding of data warehousing layout. (metrics, dimensions, fact tables, etc. ).

Responsibilities:

Plan, coordinate, develop and support EDW development including architecting table structure, building ETL process, documentation, and long-term preparedness

To analyze, design, develop, implement and maintain technical solutions in Azure using data warehouse technologies, SQL Server 2016 with sharding, distributed cache solution, SSIS, and ETL solutions.

Develop cross validation rules to ensure data accuracy

Define Technical Approach documents (define calculated logic, process flow, etc.)

Meet business requirements of the projects as new data sources are added

Provide production support of existing ETL processes

Document steps needed to migrate database objects between various environments including
Development, UAT, Staging, and Production

Provide regular project updates to Information Analysts and management as needed

Communicate issues, risks, and concerns proactively to management

Document ETL process thoroughly to allow peers to assist with support as needed

Requirements:

Data Warehouse development & modeling

Technologies required: SSIS, MS SQL Server 2008 R2

8+ years of advanced SSIS experience including ETL

Strong in SQL programming

Self-sufficient and strong communication skills (must be able to work with external
groups/departments as well as work independently)

Knowledge, Skills, and Abilities:

Bachelor's degree in computer science required and five plus years experience in information technology required. College-level coursework and eight to ten years relevant
analysis and programming experience may substitute for the degree.

Knowledge of best practices in enterprise wide database implementation, availability and security configuration.

Experience with various database administration tools (SQL 2005/2008, ORACLE), SQL clusters MSCS, reporting tools (SSRS, report writer) and ETL tools (DTS/SSIS).

Knowledge of T-SQL, PL/SQL, No SQL, relational database technologies and related information technology.

Experience in the Kimball method of database design & OLAP technology.

Good understanding of SSIS Packages and third party components (Fuzzy lookup, Slow
Changing Dimensions, XML, CSV files, FTP, etc.)

Comfortable reading and interpreting XML

Experience in relational and multi-dimensional databases as well as 2-tier and 3-tier architecture. Versed in designing and overall strategy with business intelligence systems.

Knowledge of all Company business functions and how they are implemented within the current production system.

Excellent analytical and program debugging skills.

Ability to function under close deadlines with minimal supervision and under potentially stressful situations.

Superior oral and written communication skills.

Nights, weekends, and non-regular hours may be required.