Informatica
440 Case Studies
A Informatica Case Study
Sunrun, a leading residential solar company with about 285,000 customers and 4,400 employees, needed faster, more flexible analytics to support rapid growth. Its legacy on‑premises Oracle data warehouse and slow ETL processes meant new KPIs and dashboards often took six months or more to deliver, making weekly reporting stale and limiting self-service BI across the business.
Sunrun migrated to Google Cloud (Cloud Storage and BigQuery), used Informatica Intelligent Cloud Services to build hundreds of data pipelines from dozens of sources, and deployed Looker for self‑service visualization. Completed in about 18 months, the move produced 100% cloud hosting, hourly/near‑real‑time refreshes for marketing and frequent ERP updates, a 50% reduction in data‑warehouse design time, 75% faster infrastructure builds, analytics delivered roughly 3x faster, and a 7x expansion in analytics power users (from ~100 to 700).
Harish Ramachandraiah
Director, Engineering & Analytics