Cloud data warehouse (DW) adoption delivered increased agility and reduced operational costs

Hexaware performed due diligence of the data environment for one of the largest stock exchange companies in Europe and migrated their 12-year-old on-premise SQL data warehouse (DW) to a highly scalable Cloud DW and Analytics infrastructure. This was achieved by implementing a stack, based on EMR, Redshift, Talend and S3 of the AWS Cloud platform.

Key Benefits

• Reduced several hours of multi-part data ingestion to an automated single bulk load, saving 6 hours of data loading time
• The Cloud DW was extended to deliver information and analytical insights for external clients through a self-service model
• Migrating data onto the Cloud led to savings of over £800,000 on infrastructure and licensing costs annually