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 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 an 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:
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.
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
IBM DataStage V8.5 |
Required |
10 |
Years |
Datastage Parallel processing |
Required |
10 |
Years |
IBM Quality Stage |
Required |
5 |
Years |
Slowly Changing Dimensions |
Required |
10 |
Years |
Unix Shell Scripting |
Required |
10 |
Years |
Oracle SQL |
Required |
10 |
Years |
Change Data Capture |
Required |
10 |
Years |
Data Modeling |
Required |
10 |
Years |
Source to Target Mapping |
Required |
10 |
Years |
Writing and Executing Test Cases |
Required |
10 |
Years |