After many years of working with SQL Server silos spread across its organisation and locations, a telecommunications giant in South America decided to put together a Data Strategy and chose Snowflake (on Azure) and Informatica as the main technologies for it.
They needed a centralised Enterprise Data Platform which integrated data from siloed data warehouses and transactional data, which could provide a single source of truth for the entire organisation.
Our team of experts brought together more than 20 siloed Data Warehouses in multiple technologies (including AX and Netcracker) into a centralised data platform in Snowflake, with common guidelines and a single point of truth for the organisation.
Informatica Cloud is used for ingestion – especially its Mass Ingestion capabilities for real time replication into the Staging Layer.
Tableau dashboards are pointed to the final tables to provide modern reporting capabilities to all the client’s business areas.
We ensured a smooth migration to Snowflake on Azure from the client’s existing SQL Server siloes and improved their data models and performance, through our functional knowledge of AX and Netcracker transactional systems.
Our team also optimised the performance of Mass Ingestion by deploying best practices in Informatica Cloud, and deployed Snowflake best practices to convert a shared repository of ingested sources into a proper 3-layer Enterprise Data Platform.
The resulting unified corporate data platform provides common guidelines and enables our client’s organisation to operate with efficiency and clarity
