logo
REQUEST DEMO

Please fill in the details






AMALGAM RX SAVED 20 WORKING DAYS
FOR DATA MIGRATION VALIDATION BY
SWITCHING TO DATAQ

Amalgam Rx is the leading digital platform for SaaS-driven solutions that connect healthcare
providers, life science companies, and payers. Amalgam Rx helps its clients accomplish unique digital
objectives like Point-of-care Solutions, EMR Interoperability, Combination Therapies, Patient Support
Programs (PSP), Digital Therapeutics (DTx), and Real-world Evidence.

DOWNLOAD OUR CASE STUDY

The Challenge

The Challenge

As part of data stack modernization, the transactional database,
Postgres, is migrated to the cloud data warehouse, Snowflake. The data
migration process has to sync data every hour/day between Postgres
and snowflake.

While data migration was critical, manual efforts to test data sync of
over 85 tables between Postgres and Snowflake for all the scenarios are
time-consuming. To put that in perspective, performing testing multiple
times manually along with identifying and fixing bugs would have taken
25 working days.

The testing solution should automate end-to-end testing of data migration. Should be able to handle structured/semi-structured (JSON) data and mask PII columns. Should be able to handle large volumes of data. Selection Criteriafor Testing Solution

DataQ could effortlessly handle all the requirements
and is selected for Data Migration Testing.

DataQ Advantage

Apart from identifying discrepancies, DataQ validated PII masking
algorithms. It also ensured that data in the data warehouse is HIPPA
compliant. Furthermore, the time taken to test data sync was reduced
to only five working days.

  • 100% confidence in the data migration process as tests cover all positive and negative scenarios.
  • Code enhancements and improvements are made without fear of breaking existing processes, as end-to-end testing is only a few clicks of effort.
  • Automated testing has decreased project delivery time by over 50%.

DataQ Advantage

DOWNLOAD OUR CASE STUDY

OUR SOLUTIONS

Reduced time for data migration
validation

HIPAA Compliant Data Warehouse

JASON PII Validation

Validators

Saved

20

Working days for
data migration
validation

Saved

5

Working days
taken to test
data sync

Saved

<2

Hours for end-to-end execution of test scripts

DOWNLOAD OUR CASE STUDY