Reverse Engineering ETL Jobs for Fun and Profit

As data-loving businesses amass more and more bits and bytes, the credibility of derived results — as showcased in BI dashboards, KPIs, reports, and sundry other deliverables flowing downstream of the ETL spigot — trends further out into dangerous territory.

Nothing reminds the data analyst of this tenuous balance like the CFO asking him where he got his numbers. “These numbers look off,” the CFO barks, glaring up from the preliminary 10-Q. “Where the hell did they come from?” Because he knows “the data warehouse” is not an acceptable answer, the analyst understands that a painful reconstruction of all the relevant ETL jobs is in his future.

Author: Alex Woodie


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s