Automate ETL flows using Prefect and AWS

For a two-month project at Coysu Consulting, I created prefect flows and tasks to automate scripts that were executed manually for ingestion of data from csv files located in S3 buckets to a MYSQL database. Moreover, I implemented integration tests to verify the flows were working correctly using sample data provided by the client, and build an initial local setup using Docker and a Kubernetes cluster simulated using kind to emulate a MinIO server, a MYSQL server and a Prefect server.

Technologies