endorsedCompleted

Central Data Lake & Analytics Platform for Business Management Company

Services Covered:

AI and Machine Learning • Big Data Analytics and Business Intelligence • Managed IT Services

Industry

Business Consulting & Services

Duration

6 months

Budget

50K - 199K

Start Date

1 November 2024

Team Size

6-10 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

80/100

Strong

Project Capability Score (PCS) estimates how capable Indexnine Technologies is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Great Place To Work India

Mumbai, India

Project Summary

Indexnine Technologies built a central data lake and analytics platform for the client to unify data, enable advanced analytics, and power AI/ML insights including GenAI NLP/NLG capabilities. The team delivered a fully operational AWS and Snowflake infrastructure, migration and incremental ingestion approaches, and pilot reports. The engagement featured strong project management, timely delivery, and proactive communication.

Key Challenges

Unify all organizational data into a single repository
Enable advanced analytics and AI/ML insights across the organization
Provide GenAI capabilities with NLP/NLG for easy data access and improved decision-making
Migrate historical data from legacy systems and support incremental ingestion

Project Deliverables

Central data lake and unified repository for legacy and operational data
Solution architecture and architecture diagrams for data ingestion, migration, and incremental loads
Mapping documents, transformation rules, and target data model
ELT/ETL pipelines, incremental data-loading functionality, and migrated tables into Snowflake
Reports and dashboards pilot and data automation workflows

Project Solution

Indexnine designed and implemented a central data lake and supporting data platform, migrating historical data from legacy systems and establishing ELT/ETL pipelines and incremental ingestion into Snowflake on AWS. The engagement included solution architecture, mapping and transformation rules, target data model, data governance components, and GenAI features offering an NLP/NLG interface. The team coordinated migration to Emprising SaaS where applicable and delivered pilot reports and dashboards for validation.

Project Outcome

Mapping documents and transformation rules were produced
Target data model and solution architecture were delivered, including diagrams and ELT flow
Fully operational AWS and Snowflake infrastructure was implemented
Active/passive tables were migrated and incremental data-loading functionality was enabled
Report development and pilot publishing validated the architecture

Platforms

SaaS
Web

Tech Stack

Amazon Web Services (AWS)

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Indexnine Technologies developed a fully operational AWS and Snowflake infrastructure. The team demonstrated strong project management capabilities, delivering work on time and being responsive to the client's needs. Their communication and collaboration were also excellent.”
Balbir Singh
CEO
Date: 06/19/2025