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