Etl Project Plan

TASK # Task Description

Sub Task #

1

Buid Development Enviornment

1 2 3

2

Business Requirement Analysis

1 2 3 4 5

3

Design Logical Data Mapping

1 2 3 4

4

 Data Quality Strategy

1 2 3 4 5

5

Build Physical ETL Process

1 2 3 4 5 6 7

6

Test ETL Processes - Unit - Quality Assurance (QA) - User Acceptance (UAT)

1 2 3 4 5 6 7 8

7

ETL Deployment

1 2 3 4 5

8

Maintenance

1 2

Sub Task Description

Role

Set Up Hardware Infrastructure Install Software / Tool Sets Create Best Practices & Standards Document

DBA DBA / ETL Architect ETL Manager / ETL Architect

Review Exisisting Documents Define and Document ETL Business Rules  Analyze Source Systems Define Scope for Phase of Project Obtain User Sign Off

ETL Architect / Systems Analyst ETL Architect / Systems Analyst ETL Architect / Systems Analyst ETL Manager   ETL Manager  

Review Target Database Data Model Review Business Rules  Analyze Source Systems Create Lofgical Data Mapping Document

ETL Architect ETL Architect ETL Architect ETL Architect

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

Review Logical Data Mapping Create Simple Master Table load Processes Develop Complex SCD Processes(History) Develop Complex SCD Processes(Incremental) Develop Tranaction Table Load Process( History) Develop Tranaction Table Load Process( Incremental)  Automate Processes

ETL Developer   ETL Developer   ETL Developer   ETL Developer  ETL Developer  ETL Developer  ETL Developer 

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

ETL Architect ETL Architect DBA / ETL Architect ETL Architect ETL Architect

Develop Audit Reports for known Issues Review ETL Logs Regularly to ensure Consistent / Efficient Loading

ETL Architect ETL Architect