Software Testing Strategy For a Large-Scale Data Warehouse Integration

Centric Creates Enterprise-Level Software Testing Strategy That Mitigates Risk and Reduces Cost

The Business Need

Centric’s client, one of the largest insurance and financial services organizations in the U.S., embarked on a significant project to migrate all their investment application data into a single data warehouse. The integration included four major accounting systems, three vendor investment systems and more than a dozen custom internal applications.

The work required an enterprise-level software testing effort. However the company lacked the many of the specialized resources required to successfully complete the complex undertaking on their own.

Centric’s High Impact Approach

The client chose Centric to offer support in four specific areas:

  1. Create an integration strategy that reduced risk and contained costs
  2. Find technical resources skilled in testing data modeling, data migration, and reporting analytics to undertake the project
  3. Develop strategic testing plans to streamline processes and ensure comprehensive accuracy
  4. Manage all testing in five different environments, across three project work streams, including overseeing upstream dependencies and change requests

First and foremost, Centric knew that finding the right blend of talented and experienced resources was essential to project success. As a result, the team interviewed more than 100 applicants to find the 14 experts needed to be part of the testing team.

Centric partnered with the client to develop an innovative and strategic approach to project coordination. The testing team was organized for flexibility, allowing testing efforts on several concurrent program phases to take place at the same time. Benefits to this structure were realized almost immediately as the team identified data quality standards and fixed missing requirements related to data migration efforts.


In addition to the fine-tuning of data quality standards, other benefits were realized throughout the duration of the project. The team reduced the time any given deliverable was in the testing phase by two weeks (per cycle testing costs were reduced by over $250K)