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