I find ETL best practices with Airflow a good start. Even if you don't go the Airflow route, you can benefit from the example implementations of Kimball and Dat

I find ETL best practices with Airflow a good start. Even if you don't go the Airflow route, you can benefit from the example implementations of Kimball and Data Vault ETLs. https://gtoonstra.github.io/etl-with-airflow/index.html https://gtoonstra.github.io/etl-with-airflow/index.html https://github.com/gtoonstra/etl-with-airflow https://github.com/gtoonstra/etl-with-airflow