How a Sports Tech Brand used AWS for Faster Execution of Complex Queries on Big Data

One of India’s Biggest Sports Gaming platform with 4 crores + users playing Fantasy Cricket, Football, Kabaddi and NBA wished to leverage AWS to solve complex queries.

Challenges

The current platform faced:

  • Lack of scalability to sustain high traffic expected ahead of the IPL/World Cup Season
  • Absence of dashboards for internal monitoring to ingest with real-time data
Solution
  • Deployed a detailed data dictionary and a target data model
  • Provided a PostgreSQL RDS instance with Multi Az for Airflow backend
  • Deployed a Apache Airflow to communicate with S3 and Lambda
Business Impact
  • Faster execution of complex queries on big data
  • Parallel procession on massive data
  • Nimble filtering out large set of data blocks