Client Overview
The client is one of the giant retailers in the US that offers a variety of food supplies, and services. They have a strong reputation for providing high-quality products and outstanding customer service.
Client Requirement
- Develop a data pipeline to get the raw data from each platform into targeted tables in Snowflake.
- Fetch the data from targeted tables based on platform, fiscal week, and network and compare the results with the source/raw data.
- Create an excel file to compare the source data with the resulting data from the snowflake tables.
- Generate a report on a weekly basis to highlight which platform, network, and date range have inaccurate or missing data issues.