The case for the ELT workflow

We had to draw a line in the sand, or we’d never make the switch. The time had come to move our data transformation pipeline to an ELT (extract -> load -> transform) workflow. Our old ETL (extract -> transform -> load) pipeline, a set of stored procedures running on a Postgres database (PL/pgSQL to […]

Read More

A love letter to ETL tools

I love anything that helps me get deep, anxiety-free, sleep. Dog-on-air-vent, cat-in-window kind of sleep. Back in September 2010, for my first job in analytics, I careened into the office at 6:30am every day, unsure of what issues might be awaiting me. My assignment was to sign off on risk analytics reporting for BlackRock’s banking […]

Read More