TRENTON, NJ, USA
1 day ago
ETL Programmer
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 ETL and Business Intellegence toolsets. The ETL Programmer will lead the upgrade to DS 8.5 and BOXi. The initiative

 

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 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.

May have worked on toolset upgrading implementations.

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

Enterprise Data Warehouse/Data Mart enviroment utilizing DataStage 7.x, 8.x and Business Object XI and 6.5

Required

5

Years

Experience with ETL and Business Intellegence development in and Enterprise Data Warehouse environment, including identirying user requirements

Required

3

Years

Experienced in using Ascential DataStage Server and Enterprise Edition in and Oracle hosted Data Warehouse

Required

5

Years

Experience in developing and maintaining of Dependent/Indepedent data marts

Required

5

Years

Experience in using DataStage Basic (DSBASIC) language and Extensible Markup Language (XML), use of TOAD, SQL and PL/SQL

Required

5

Years

Experienced in Sourced to Target mapping between Data Warehouse and target data mart universe databases

Required

5

Years

Experience using Businss Objects Designer and WebIntelligence inclucing universe and report design, construction and documentation

Required

5

Years

Completed at least one successful complex migration from DS6.5 to DS8.x

Required

1

Years

Completed at least one successful complex migration from Business Objects 6.5 to XI on Windows platforms

Required

1

Years

 

Confirm your E-mail: Send Email