I'm an independent DW/BI consultant specialising in the SQL Server stack. Long experience of inheriting ETL developments in a variety of conditions has given me a strong interest in building fault-tolerant, diagnostic-rich systems. I'm particularly interested in using metadata to inform process control, drive code generation, automate documentation and to reduce human error.


In this session we'll look at ETL metadata, use it to drive process execution, and see benefits quickly emerge. I'll show how a metadata-first approach reduces complexity, enhances resilience and allows ETL processing to become self-organising.