ADA helped a leading online pharmacy optimize data storage costs and performance by migrating from AWS Redshift to Apache Hive​

‍

Results

{{stats-component}}

‍

Execution

The customer is the region’s top online pharmacy and medical care platforms with doorstep delivery service available in 1000+ cities and towns across 22000+ pin codes. They provide a wide range of over-the-counter products and medical equipment across a broad budget spectrum.​

The customer was facing growing storage costs and scalability bottlenecks on their existing AWS Redshift data warehouse as their volume of streaming and transactional data was increasing. They needed a more cost-effective data and customizable data warehouse for their data growth.​

ADA helped to evaluate different technologies and developed a phase-by-phase plan to migrate the existing data to a Hadoop based Apache Hive data warehouse. We ensured that existing data reporting operations remain unaffected during the migration process. ​

ADA established best practices, performed necessary data validation, and deployed optimized codes that would power multiple business-wide dashboards and reports.