Job ID :
3784
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 or Call: (202) 719-0200 Ext: 127

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  and Business Intelligence 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 plus the following:

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

Extensive enterprisewide implementation of complex ETL tools and BI tools

Conduct ETL and data model testing.

Mentor and supervise ETL programmers.

May have worked on Parallel processing implementations.

May have worked on toolset upgrading implementations.

 

Skills:

Skill        Required / Desired          Amount               of Experience

Enterprise Data Warehouse/Data Mart environment utilizing DataStage 7.x, 8.s and Business Objects XI.

Required             5              Years

Experience with ETL and Business Intelligence development in an Enterprise Data Warehouse environment, including identifying user requirements. 

Required             5              Years

Experience in using Ascential Data Stage Server and Enterprise Edition in an Oracle hosted Data Warehouse.      

Required             5              Years

Experience in developing and maintaing of dependent and independent data marts.     

Required             5              Years

Experience in using Data Stage Basic (DSBASIC) language and Extensible Markup Language (XML), use of

Required             5              Years

Experienced in sourced to target mapping between Data Warehouse and target data mart univers databases.  

Required             5              Years

Experienced using Business Objects Designer and WebIntelligence including univers and report design, construction and documentation.              

Required             5              Years