Job ID :
5968
Company :
State of New Jersey
Location :
TRENTON, NJ
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
30 Oct 2014
Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

The Extract, Transform, and Load (ETL) Programmer has worked in areas of data mart/data warehouse design and has extensive knowledge of an Extraction, Transformation, and Loading toolset or toolsets.

 

Complete Description:

The Extract, Transform, and Load (ETL) Programmer has worked in areas of data mart/data warehouse design and has extensive knowledge of an Extraction, Transformation, and Loading toolset or toolsets.  The ETL Programmer has worked on some or all of the following steps: Cycle Initiation, Building of reference data, Extraction, Validation, Transformation, Staging, Auditing, Publishing to target tables, Archiving, and Cleaning.  Systems may involve parallel processing or traditional ETL.

 

Years of Relevant Experience:

5 plus years

Preferred Education:

4 year college degree

Role Description:

All roles specified in ETL2 plus the following:

Create data models, schemas, structure, and data definitions.

Extensive enterprise wide implementation of complex BI tools and ETL tools

Conduct ETL and data model testing.

Mentor and supervise ETL programmers.

May have worked on Parallel processing implementations.

 

Skills:

Skill

Required / Desired

Amount

of Experience

IBM DataStage V8.5

Required

10

Years

Datastage Parallel processing

Required

10

Years

IBM Quality Stage

Required

5

Years

Slowly Changing Dimensions

Required

10

Years

Unix Shell Scripting

Required

10

Years

Oracle SQL

Required

10

Years

Change Data Capture

Required

10

Years

Data Modeling

Required

10

Years

Source to Target Mapping

Required

10

Years

Writing and Executing Test Cases

Required

10

Years