ETL Developer

Technology @Dream11Our Tech Team is the core of Dream11’s mobile-first cross-platform (Android & iOS, Mobile + Desktop PWA) product, serving more than 10 Crore users with over 70 million rpm (requests per minute) at peak with user concurrency of 5.5 million. Our tech stack is hosted on AWS and comprises multiple distributed systems like Cassandra, Aerospike, Akka, Voltdb, Ignite etc.
We have around 100+ micro-services primarily written in Java backed by vert.x framework. They serve isolated product features with discrete architectures to serve the respective use-cases. We have a completely in-house data infrastructure built on top of Kafka, Redshift, Spark, Druid etc. which powers our Machine Learning and Predictive Analytics use-cases. We ingress Terabytes of Data every day, which flows all over our Data pipelines to power a plethora of use-cases. 

Your Role:

• Build Dimensional models for optimizing analysis and insights generation
• Consulting with data platform teams to get a big-picture idea of the company’s data storage needs
• End to End ETL development, aggregation and testing of data models on Data Warehouse
• Troubleshooting any issues that may arise
• Optimizing legacy systems for cost and speed
• Providing maintenance support

Must Have:

• Experience in Dimensional Data Modelling with MPP based (Redshift or Snowflake) Warehouse
• Expert in writing optimized SQL queries on Redshift, Hive and Presto
• Well versed with Data Lake and Data Warehouse architectural patterns for data storage and retrieval
• Prior experience in writing ETLs and automations using scripting languages

Good to Have:

• Prior experience in AWS Cloud
• Analytical mindset and problem solving
• Good data visualisation skills using Looker or any equivalent analytics tool

Dream Sports is a sports technology company with brands such as Dream11, FanCode, DreamX, DreamSetGo and DreamPay in its portfolio. Dream Sports is executing its vision of ‘Make Sports Better’ by providing multiple avenues for fans to deeply engage with the sports they love through fantasy sports, content, commerce, experiences and events, among others.
Founded in 2008 by Harsh Jain and Bhavit Sheth, the company has been ranked #7 among India’s Great Mid-Size Workplaces in 2020 and was recognised as one of the top 10 innovative companies in India by Fast Company in 2019. Kalaari Capital, Think Investments, Multiples Equity, Tencent and Steadview Capital are the marquee investors in Dream Sports.