Job ID :
3783
Company :
State of New Jersey
Location :
trenton, NJ
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com

Complete Description:

 

The consultant will perform the following functions:

•Create all Data Stage jobs required to load data to the existing TransINFO normalized Data Warehouse from the Staging Area.

•Create all Data Stage jobs required to load data to the existing TransINFO de-normalized (Star Schema) Data Marts from the Data Warehouse.

•Create Exception Log entries  in conformance with the TRansINFO project standard methodology.

•Create Data Stage ETL routines to handle Slowly Changing Dimension (Type 2) data in the Star Schema Data Marts.

•Create comprehensive Test Plan with Test Cases designed to test all Data Stage jobs.

•Document all Test Case runs with expected and actual results.

•Support user groups during User Acceptance Testing.

 

Mandatory Experience

•Six years experience in ETL development in an enterprise data warehouse environment

•Four years experience in using DataStage Server and Enterprise Edition in an Oracle-hosted Data Warehouse environment

•Experienced in using DataStage Basic (DSBASIC) Language

•Experienced in Source to Target mapping between legacy systems and target databases

•Excellent SQL skills.

•Excellent communication skills, both verbal and written

 

Skills:

Skill        Required / Desired          Amount               of Experience

Experience in ETL development in an enterprise data warehouse environment 

Required             6              Years

Experience in using DataStage Server and Enterprise Edition in an Oracle hosted data warehouse environment 

Required             4              Years

Experienced in using DataStage Basic (DSBASIC) Language           

Required                             

Experienced in Source to Target mapping between legacy systems and target databases              Required                             

Excellent SQL skills          

Required                             

Excellent communication skills, both verbal and written

Required                             

Experienced in using File Transfer Protocol (FTP)              

Desired                                

Experienced in using UNIX Shell Scripting             

Desired                                

Experienced in using Erwin CASE tool     

Desired