DeliverableOwnerStatusStart DateEnd DateCommentsComplete %
Schedule_jobs document FernandoIn Review25th May

16th June

Fernando and Matteo to discuss any further clarification needed

Joao mentioned to see a match between job names and domain


100%Matteo to review with other data engineers
SCD documentFernandoCompleted 1st May16th June

Fernando to share his document with Joao Madrinha and add to the wiki

Need to have a data modelling approach chapter and within this add the SCD details. The structure needs to be created so the document fits

100%
Security System documentFernandoIn Progress5th June16th June

Fernando to speak to Paulo from Tableau and agree on logic

It will be used via a service account but needs to ask if doing live/ via a cube

Mentioned this will be improved in future phases

95%Document to be validated
Data ingestion reference jobsMatteoIn Progress15th May16th June

Completed for Gsheets, Staging, ODS

3 jobs to still document and check with Joao. Also to write guideline for frequently asked questions

Sales Force jobs still to do

100%To be discussed with architects, then for Matteo to write up agreed logic
Jobs testing MatteoIn ProgressTBCTBCMatteo to test jobs and correction as we get more domains100% (test)/ % (adoption) 

All jobs in the framework are already tested by Matteo

Being used by Live projects and testing framework and jobs via loading on staging and ODS

Matteo to test any other datasets/ domains to ensure they work

Dependant on domains being added

Documentation of jobs for handling reference data - low priorityMatteoIn Review5th Jun16th June

Matteo building jobs and needs to document how to use it


95%
Build and test dataset tables on TerraFormMatteo and ToddIn Progress16th May9th JuneDocument how to create views and defining permissions90%

Need to test - Moving of columns

Matteo/ Todd to show and discuss how it works on TerraForm

How do data architect interact with the tool at data mart level


All completed documents to be added onto the wikiFernandoComplete31st May9th  June
  • Closed (exc Data quality KPI)
    • Data Architect - Data Quality KPI_V1.0.docx - to review with Joao  and replace with Data curation engine
    • Data Architect - Error Log System_V1.0.docx
    • Data Architect - Mandatory Fields_V1.0.docx
    • Data Architect - Data Hub_V1.0.docx
    • Data Architect - Naming Convention_V1.0.docx
100%Just need to change the name to STG from staging
All projects to be added on GCPToddIn progress5th June14th June

Only 1 project given by GCP 

  • prj-data-dm-common-{dev/test/preprod/prod}

All others to be added from 5th June



User groups to be defined and standardisedToddIn progress5th June14th June
  • User groups to be defined and standardised so they can be used for all the projects


Performance MatteoTBCTBCTBCOn Talend as data is being added what is the level of performance? 

Documents



To ensure all documentation has the same language and terminology - such as STG for staging
Align - Naming convention 








  • No labels