Case Study: a leading US solar services provider achieves scalable, high-performance analytics with NeenOpal

Leading US Solar Services Provider - Customer Case Study

The client, a leading US solar services provider, faced challenges in migrating its complex data environment from Snowflake to Google BigQuery. Their hurdles included centralizing diverse datasets, handling large tables, and overcoming tooling limitations in Informatica IICS. They engaged NeenOpal to manage this large-scale transition of over 2000 tables and 100+ procedures.

NeenOpal implemented a solution using custom ETL workflows and Informatica CDI jobs to optimize the migration. They refined data pipelines, implemented efficient partitioning for large datasets, and established a new naming convention. This resulted in a successful on-time migration within six months, providing the client with a unified data ecosystem, significantly improved query performance, and greater scalability for advanced analytics on BigQuery.