Context / Business Need
Context Cloud transformation of enterprise analytics platform, transitioning from on-premises architecture (Exasol DWH, Tableau Server clusters, Pentaho Kettle ETL) to a scalable cloud-native SaaS ecosystem based on Snowflake and Tableau Cloud.
Scope and Method of Service Provision
Scope of Work
End-to-end migration of data, ETL processes, and Tableau platform:
- Migration of approximately 25 billion rows from Exasol to Snowflake
- Conversion of ELT pipelines from Pentaho Kettle to Apache Hop
- Orchestration via Apache Airflow
- Migration of Tableau Server environments to Tableau Cloud including users, groups, data sources, and thousands of workbooks
- Remapping of connections from Exasol to Snowflake
- Performance optimization and cost optimization
Services Provided
- Data lake migration (Exasol → Snowflake)
- ETL re-engineering (Kettle → Hop + Airflow)
- SQL/Python transformation adaptation
- Tableau Server to Tableau Cloud migration
- User/group and permission migration
- Dashboard and data source remapping and validation
- Performance tuning (Tableau + Snowflake)
- Troubleshooting and hypercare support
Tools & Technologies
Tableau Cloud, Snowflake, Exasol, Apache Airflow, Apache Hop, Python, SQL
Team
- 1 Project Manager
- 4 Data Engineers
- 4 Tableau Developers
Key Deliverables
- Migrated cloud-based data platform
- Fully operational tableau cloud environment
- Re-engineered ETL pipelines
- Optimized dashboards and data sources
- Monitoring and performance optimization reports
Outcomes & Impact
- Successful large-scale cloud migration with minimal disruption to business users
- Improved scalability and performance of analytics platform
- Optimized consumption cost management on snowflake
- Enhanced governance and maintainability
- Enablement of advanced analytics and ai capabilities
Enterprise-level Relevance
- Demonstrates capability in large-scale platform transformation
- Migration to cloud analytics ecosystems
- Management of thousands of tableau assets and users, and integration between data platforms and bi tools in complex, multi-entity environments