ETL Developer

Date: May 13, 2013

Location: Trenton, NJ


Quantum Tech Staffing is seeking a ETL Developer for a contract position in Trenton, NJ.

The Extract, Transform, and Load (ETL) Developer has worked in areas of data mart/data warehouse design and has extensive knowledge of an ETL and Business Intelligence toolsets. Candidate will lead the upgrade to DS 8.5 and BOXi.

Candidate will have 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

Roles and Responsibilities:
o Create data models, schemas, structure, and data definitions.
o Extensive enterprise wide implementation of complex BI tools and ETL tools
o Conduct ETL and data model testing.
o Mentor and supervise ETL programmers.
o May have worked on Parallel processing implementations.
o May have worked on toolset upgrading implementations.

Required Skills:
o Enterprise Data Warehouse/Data Mart environment utilizing DataStage 7.x, 8.x and Business Object XI and 6.5 – 5 years
o Experience with ETL and Business Intelligence development in an Enterprise Data Warehouse environment, including identifying user requirements – 3 years
o Experience in using Ascential DataStage Server and Enterprise Edition in an Oracle hosted Data Warehouse – 5 years
o Experience in developing and maintaining of Dependent/Independent data marts – 5 years
o Experience in using DataStage Basic (DSBASIC) language and Extensible Markup Language (XML), use of TOAD, SQL and PL/SQL – 5 years
o Experienced in Sourced to Target mapping between Data Warehouse and target data mart universe databases – 5 years
o Experience using Business Objects Designer and WebIntelligence including universe and report design, construction and documentation – 5 years
o Completed at least one successful complex migration from DS6.5 to DS8.x – 1 year
o Completed at least one successful complex migration from Business Objects 6.5 to XI on Windows platforms – 1 year