All posts / ETL

Build the Engine, Not the Pipeline: Lessons from a Configuration-Driven Data Platform

Lessons in ETL, data modeling and reusable platforms from building a configuration-driven data engine, and what AI agents would change.

SQL Stored Procedure Best Practices

A concise summary of best practices for SQL stored procedures—covering performance, maintainability, naming conventions, and security.

Building a Basic ETL Pipeline in Python with OOP

Learn how to build a clean and modular ETL pipeline in Python using object-oriented programming principles—great for beginners and side projects.