Job ID :
1336
Company :
State of New Jersey
Location :
trenton, NJ
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:

 

The Extract, Transform, and Load (ETL) Programmer has worked in areas of data mart/data warehouse design and has extensive knowledge of Datastage 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 Datastage 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:

3 to 5 years

Preferred Education:

4 year college degree

Role Description:

All roles specified in ETL1 plus the following:

Analyze existing Datastage ETL jobs of moderate to high complexity, document processes and rules, and rewite etl jobs to increase maintainability and issue debugging. 

Work with DBA's and data architects to understand data structure of new ODS database.

Mentor and assist existing staff on the use of Data stage product to create ETL jobs.

Develop data warehouses, data marts, and/or operational data store applications, including large-scale data volumes, focusing on ETL development.

Analyze database design, including schemas, database structures, data definitions and data models.

Develop data models, entity-relationship diagrams, data dictionaries, referential integrity, and normalization evaluation in programs to maintain the database integrity, retrieve and manipulate data.

Develop enterprise-wide multi-dimensional data warehouses using relational databases.

 

Skills:

Datastage ETL programming

Required 3 Years

 

Oracle SQL and PL/SQL

Highly desired 2 Years

 

Communication

Required 2 Years

 

Documenting ETL workflows

Highly desired 2 Years

 

Unix / Linux

Desired 1 Years