A leading global food service provider with multiple operating companies in retail operations. The client is one of the largest food provider worldwide.
The Client had a huge data warehousing system owing to the nature of its business functioning with a large supply chain network. Their challenges were spread across the following areas:
As part of the initial phase of the project, legacy data from Oracle EDW was migrated to Azure Data Lake Store (ADLS) with three data layers - RDS (Raw Data Store), SDM (Structured Data Mart), and CDM (Curated Data Mart)
RDS acted as the landing zone where data would be ingested using Azure Data Factory and moved to SDM. Data from SDM would then be moved to CDM which is the curated data layer in ADLS. The data lake was fully managed and supported by Microsoft, and backed by an enterprise-grade SLA and support.
The Mphasis solution provided the following benefits to the client
Significant cost savings through reduced infrastructure costs by 30%
Ability to store and analyze petabyte-size files and trillions of objects with ADLS
Increased security, auditing and support