The client is one of the world’s largest and oldest multi-channel bookmaking and gaming companies from the United Kingdom; operating in over 25 countries with annual revenue exceeding €3 billion as of 2020.
- Mergers and acquisitions are a regular news headline in the casino industry. There are two main data challenges that come with M&A-
- The need to shift from or to accommodate different data infrastructure tools and platforms
Consolidating all the data across various platforms and databases used by the firm to a single consolidated space like a data warehouse or data lake for a holistic view of the company’s functioning, performance, potential and untapped opportunities.
- The client had recently merged with another major online casino and wanted to build a single consolidated data-warehouse with unified data structures and processes across the organization. And as a part of its long-term strategic plan, the client wanted to move away from Oracle and few other sets of diverse data storage options to MS-SQL Server.
- The data migration process from Oracle to MS-SQL is a mammoth task and needed shell scripting in order to migrate the data from several flat files including csv and excel