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.
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
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.
DataQ could effortlessly handle all the requirements
and is selected for Data Migration Testing.
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.
Reduced time for data migration
HIPAA Compliant Data Warehouse
JASON PII Validation
Working days for
taken to test