Data Migration & ETL Testing

Despite the cost and efforts required to build a Data Warehouse, your business will get massive benefits from it. In the past, ETL projects that have failed to obtain the expected benefit is due to lack of quality assurance. Data migration and ETL must be vigorously tested to ensure that data / information is intact during migration from heterogenous sources to data warehouse. Additionally, the tests should also ensure that transfer rules are properly followed and in accordance to validity checks.