Description
Key objectives:
- Develop, monitor and maintain tactical SSIS sourcing from Oracle database to Teradata (TD) staging area
- Build and maintain ETL from TD staging area to TD SIM
- Design, implement and maintain IEDW Logical and Physical Data Models (LDM and PDM)
- Build and maintain ETL from TD SIM to TD IEDW
- Ensure IEDW is sourced from original true sources
- Design, implement and maintain Semantic Layer LDM and PDM for ProcessMng universe
- Build and maintain ETL from TD IEDW to TD Semantic Layer
- Review and improve Semantic layer to support changing reporting requirements
- Optimise all ETL SQL and PDMs to meet NFR
- Review and optimise report SQL to meet NFR
- Ensure Metadata load metrics are collected on all ETL processes.
Other objectives:
- Maintain BPM sourcing in cooperation with BPM team
- Assist BPM and Data foundation to establishing strategic data sourcing (MQ/Infomatica)
- Be the single point of contact for queries related to sourcing, data warehouse and data model
- Testing, bug and error fix within data model of data warehouse
- Set up source control
- Documentation
- Erwin model. Including business descriptions
- ETL Process and Transformations
- Document ETL code