Our client is a well-established American multinational retailer with a four-decade legacy of delivering exceptional customer experiences. The client had constructed their own data platform on Azure, utilizing Informatica for data ingestion and processing, Azure Data Lake for storage, Synapse for Data Warehouse, and Power BI for visualization. However, their current system was experiencing data duplication, performance issues, and failing to meet service level agreements (SLAs) for daily data updates. To address these challenges, the client engaged FPT Software to improve the system's performance, scalability, and data quality.