Key Activities | Key Participating Groups | Deliverables/Outputs |
Ø Create/verify data element mappings Ø Run data extracts from current system(s) Ø Create tables, write scripts and schedule jobs to automate the extraction Ø Fix any remaining data clean-up related issues Ø Execution of application specific customizations Ø Execution of mock migrations Ø Using bulk loading functionality, load extracts using tools such as SQL loader Ø Business rules validation and referential integrity checks through data validation. Ø Exceptions reporting to client team Ø Perform data validation | Ø Data migration team Ø Client Support team Ø Data Administrators team | Ø Source system extraction Ø Modules, scripts and ETL jobs for data migration Ø Application populated with transformed data Ø Various controls points to handle errors, exceptions and alerts. |