Job ID :
3280
Company :
State of Iowa
Location :
des moines, IA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

 

This position will be a member of a team but will need to work independently.  They will report to a Senior Architect/DBA but will require self-direction.  Job responsibilities will span ETL development, data transformation and modeling.

 

Complete Description:

 

This position will be a member of a team but will need to work independently.  They will report to a Senior Architect/DBA but will require self-direction.  Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend.  Advanced skills in writing complex Structured Query Language (SQL) queries are required.  

 

Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results.

 

ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.  

•          Proficient in development of SQL Server Integration Services (SSIS) packages.

•          Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL.

•          Experience extracting data from a large variety of sources, tranforming and loading to a SQL data warehouse

•          Evaluate and address data quality issues

•          Developing error checking and resolution routines

•          Experience in interacting with customers regarding application requirements.

•          Strong business writing and interpersonal skills necessary for customer contact..

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

Develop, modify and optimize SSIS packages

Required

5

Years

SQL 2005

Required

5

Years

SQL 2008

Required

3

Years

Experience building SSIS packages using built-in SSIS components

Required

5

Years

Experience writing complex T-SQL

Required

5

Years

Experience analyzing, profiling, manipulating data from a large variety of sources

Required

5

Years

Experience loading data into a SQL Data Warehouse

Required

5

Years

Troubleshoot abstract data, profile, analyze and optimize data

Required

5

Years

Develop error checking and resolution routines

Required

5

Years

Data modeling experience

Required

5

Years

Analyze and optimize table design

Required

5

Years