ETL Data Pipeline Development using Streamlit on GCP

Client Overview

The client is an African retail supply chain transformation company enabling small shops and retailers to adopt digital economy through
mobile ordering & distribution systems, and enterprise services.

Business Challenges

  1. Build and manage the entire ETL (Extraction, Transformation & Loading) data pipeline and ETL integration with their existing ERP system, FMCG process and Loan application process.
  2. Develop Reports and Analytics to monitor Delivery agent’s performance, Vehicle Utilization, Credit services and Sales activities.
  3. Conversion of existing environment (Java & Postgres) to Big data platform for better efficiencies.