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
Replacement of SSIS process with Python for Data Integration from MSSQL to Snowflake
- Data is transferred from the MSSQL Server to an Amazon S3 bucket in the form of CSV files.
- An ETL pipeline, utilizing a Python script, is to be established to replace the current SSIS process and move data from the MSSQL Server to the Amazon S3 bucket.
- The data from the S3 bucket needs to be loaded into Snowflake.