Case Study: Informatica achieves 4–5 hours/day faster ETLs and 3‑month ROI with Fortra’s Skybot Scheduler

Improving Informatica ETL Processing

A biotechnology company running Cognos for BI and Informatica for ETL faced long nightly data loads and heavy administrative overhead: ETL windows were taking about 10.5 hours, staff stayed late to launch sequential jobs, and the team needed a way to centralize and automate schedules across a multi‑server environment that included ERP, finance, Active Directory and other systems.

They deployed HelpSystems’ Skybot Scheduler—installed in a day and fully running in three—to harvest and manage Informatica workflows and coordinate downstream processes (Cognos cube builds, ERP data pickups, FTP transfers and reconciliation alerts). The result: ETLs now finish on time, saving 4–5 hours per day, eliminating late‑night work, simplifying administration and delivering a positive ROI within three months.

Informatica