Job Description :
Scope of Work
The Contractor’s role shall be to develop ETL jobs that (a) move data from Oracle and SQL Server source system databases to an Operational Data Store (ODS), (b) implement change data tracking, and (c) transform, integrate and move data from the ODS to the Data Store.
The Contractor requirements for this position shall include but are not limited to the following:
Code ODS load jobs
Implement Change Data Capture jobs
Implement data integration jobs (ODS to Data Warehouse)
Perform QA testing of other developers’ ETL jobs
Document ETL job designs and configuration information
Design and perform system integration testing
Design and perform user acceptance testing
e. Deliverables
The Contractor shall be responsible for but not limited to the following deliverables:
High quality, performant ODS load jobs
High quality, DW integration jobs
Documentation for each ETL job
Recommendations for design improvements
Additional related work items may be assigned as determined by the Data Architect and/or
Project Manager.
f. Acceptance Criteria
All Work shall meet the design requirements and is performed within agreed upon timeframes
(which will differ depending on the particular job function All work shall meet quality and
performance criteria as set by Data Services architects (Bob Vogt or delegate These shall
include (but are not limited to):
ETL jobs are fully functional with error handling and logging
ETL jobs are fully tested
ETL jobs are performant
ETL jobs are maintainable
ETL job designs adhere to existing design patterns
All work shall be documented including ETL job design, sources and targets, transformations,
operations, etc.