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