Data Extractions and Migration

Data migration is a key process in any system implementation, upgrade, or consolidation. A well-defined and process-oriented data migration strategy is vitally important to the timeliness and ultimate success of the venture. These projects yield high business benefits (such as cost savings, increased productivity and improved data manageability) but at the same time they tend to involve a high level of risk due to the volume and criticality/complexity of the data.

One of the major problems with many data migration process is that legacy system support team is not aware of the new system and its data structure and the new incoming system vendors are not aware of the data structure of legacy system. This gap become severe if the legacy system quite old and support is very minimal. We are Sirma strive to bridge this gap. We work with the legacy system team from the inception, and we learn the legacy system to the extent that of automating process rather than human resources that can be a risk for error and are more cost-effectively deployed elsewhere.

The migration is done by creating a design that maps the data from the old system to the new system in a way that relates the old data formats to the new formats and requirements. Depending on the complexity of the project, few or many phases can be involved, but at a minimum includes

  1. Data extraction: The data is read from the old system
  2. Data transformation: Legacy data is transformed into a format that is compatible with the new system
  3. Data loading: Data is written into the new system.

or as we call it IMPACTO – ETL (Extract, Transform, Load)

Our Data validation techniques include

Data Validations:

  • Load Balancing Validations
  • Business/Scenarios based Validations
  • Data plus List Reconciliations
  • Data Reports

Functional Testing:

  • UI Smoke Testing.
  • End to End Business Process Testing.
  • Life Cycle Testing