Define Data Quality rules Document Data Defects Determine data defect Responsibility Obtain Sign off for the ETL Correction Logic Integrate Rules with the ETL Logical Data Mapping
ETL Manager / Data Quality Specialist ETL Manager / Data Quality Specialist ETL Manager / Data Quality Specialist ETL Manager / Data Quality Specialist ETL Manager / Data Quality Specialist
Create Test Enviornment Create Test Plan and Scripts Load Test Data(History & Increment) Execute Unit Test Scripts Validate Data Quality Controls Validate Loaded Data Validate Business Rule Obtain Sign-Off
DBA / ETL Architect System Analyst ETL Developer System Analyst System Analyst System Analyst System Analyst ETL Manager
Create Production Support Documents Create Failure Recover Procedures Document Create Production Enviornment Load Historic Data Initiate ETL Schedule For Incremental Process