Implementation Tasks

Alpha release of HR Datamart to TEST

1. Infrastructure Components

Staging DB schema promoted to TEST

Foundation DB schema changes sync'ed in TEST ( as of 20-Jan 2020 DEV , TEST and LIVE Foundation layers have already been sync'ed - now changes have to be deployed as Bamboo releases)

Run HR Datamart history jobs ( one-off data load) in TEST - long running process

1. Application Components

Deploy to Access layer TEST for HR

Deploy db links for BI Tools to enable connection to HR datamart TEST

- Qliksense

- Power BI

- Qlikview

1. Application Setup

tbc -  enable scheduled jobs in TEST

EDW Talend cloud jobs?

1. Integration Components

tbc - future connection to core systems People and Money API for HR deltas

1. Data Population

One-off data load from legacy Oracle HR - source data in HR TEST last updated 4-Nov 2019

- 

next scheduled refresh of HR data in source DEV and TEST envs is June 2020

1. Data Migration

n/a - no additional data migration beyond the initial run of the history jobs, and then update via Core systems API for deltas

1. Implementation Validation

Implementation should be validated by Project team and IS Production , before the TEST system is handed to business testers for UAT