Job ID :
1917
Company :
State of Iowa
Location :
des moines, IA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
6 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 and database modeling/development.  Advanced skills

 

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 and database modeling/development.  Advanced skills in writing complex Structured Query Language (SQL) queries are required. 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. 

 

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

•             Experience in interacting with customers regarding application requirements.

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

•             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 working on a large scale data warehouse implementation.

•             Experience in completing unit and system testing.

•             Addressing data quality issues;

•             Developing error checking and resolution routines;

 

Skills:

ETL processes – internal/external sources

Required 3 Years

 

Strong experience with data transformation

Required 3 Years

 

Convert other Databases to SQL

Desired

 

Load data to OLAP databases

Desired

 

Query performance tuning

Desired

 

Experience in interacting with customers regarding application requirements

Required 3 Years

 

SQL Server Integration Services (SSIS) packages

Required 3 Years

 

Developing error checking and resolution routines; Unit and system testing;

Required 1 Years

 

SQL Server 2005

Required 3 Years

 

Data Modeling Experience

Required 3 Years

 

Familiarity with eScholar CDW

Highly desired

 

Knowledge of and experience working with education data

Desired