Dream11 - interview guide

Dream11 interview questions - a complete guide

Huge numbers of users arrive on Dream11 at the same time during a match - so its interviews ask about scale, databases and real-time systems. Here is how to prepare for all of it.

Language:EnglishHinglish

About Dream11

Dream11 is Dream Sports' fantasy sports platform, where users build teams for sports like cricket. Traffic rises very fast around big matches, so scale and reliability matter most.

This guide covers 13 Dream11 interview questions with answers - what each question checks and how to answer it - plus the Dream11 interview process, round by round, a 7-day preparation plan for freshers, tips and the mistakes to avoid.

Dream11 hiring process

  1. DSA

    2 questions in about an hour.

  2. Machine coding / LLD and database

    Design, plus a deep conversation about the databases in your past projects (concurrency, replication).

  3. System design and HR

    Real-time systems - starting from requirements; then HR.

Dream11 does not publish its India fresher interview process in detail (as of our check). This is based on candidate reports - many of them for experienced roles, so the fresher process can differ. Confirm with the recruiter.

Sources (checked 16 October 2026): Dream Sports Careers. Hiring processes change - read the official notice before you apply.

Dream11 interview questions and answers

DSA

  1. 1.Fantasy team: pick players with maximum points within a budget.

    What they're checking
    Knapsack - tied to the domain.
    How to answer
    0/1 knapsack - budget as capacity, points as value; team rules (how many of each role) as extra conditions.

  2. 2.Top K players by score, while scores keep changing.

    What they're checking
    A heap/sorted structure.
    How to answer
    A min-heap of size K or a sorted set; on a score update remove the old entry and add the new one.

  3. 3.Find the majority element (more than n/2) in an array.

    What they're checking
    Boyer-Moore voting.
    How to answer
    A candidate and a count; +1 if it matches, -1 if not, a new candidate at 0.

Database and design

  1. 4.Design a real-time leaderboard (millions of users).

    What they're checking
    Dream11's core problem.
    How to answer
    Score updates from a stream; ranks in a sorted set (like Redis); cache the top N; the user's own rank as a separate query.

  2. 5.Traffic jumps 50 times before a match starts - how do you handle it?

    What they're checking
    Scale.
    How to answer
    Scale up in advance, caching, queue the writes, and prioritise essential features - load test beforehand.

  3. 6.What happens when two transactions update the same row in Postgres?

    What they're checking
    DB concurrency has been asked in reports.
    How to answer
    A row lock - the second one waits; behaviour depends on the isolation level; on a deadlock, one is rolled back.

  4. 7.What is database replication and why use it?

    What they're checking
    DB deep dive.
    How to answer
    Copies of the data on other servers - to share the read load and survive one server failing. Watch for replication lag.

  5. 8.How would you explain why you chose a database and a cache in your design?

    What they're checking
    Reports mention rejections over exactly this.
    How to answer
    Start from the requirement (read/write ratio, consistency), compare options, and state the trade-off clearly.

  6. 9.Design a monitoring system (high level).

    What they're checking
    A real-time monitoring design has been reported.
    How to answer
    Services send metrics, a time-series store, dashboards and alerts - ask about requirements first.

HR and culture

  1. 10.Why Dream11?

    What they're checking
    Motivation.
    How to answer
    Sports and large-scale systems - a genuine reason.

  2. 11.Tell me about a time a system went down in production - what did you learn?

    What they're checking
    Ownership.
    How to answer
    What happened, how you helped, and what changed afterwards.

  3. 12.What do you do if the interviewer keeps adding new requirements?

    What they're checking
    Reports mention requirements growing mid-design.
    How to answer
    Stay calm, adjust the design, and say which trade-off changed.

  4. 13.Explain the database choice in your project.

    What they're checking
    Resume and DB discussion.
    How to answer
    Why SQL/NoSQL, the schema, and what happens at scale.

7-day preparation plan for the Dream11 interview

  1. Day 1: DSA - heaps and knapsack.
  2. Day 2: Databases - transactions, locks, isolation.
  3. Day 3: Replication and caching.
  4. Day 4: Design - a leaderboard.
  5. Day 5: Design - a traffic spike and monitoring.
  6. Day 6: Your project's DB choices and HR stories.
  7. Day 7: A mock design round.

Preparation tips

  • Depth in databases - concurrency, replication, indexing.
  • State the reason and trade-off for every choice in design.
  • Understand real-time systems (leaderboards, streams).

Mistakes to avoid

  • Choosing a technology in design without a reason.
  • Starting a design without asking about requirements.
  • Not knowing the basics of DB concurrency.

Frequently asked questions

What does the Dream11 interview ask most?

DSA, LLD, a database deep dive and real-time system design - as commonly reported.

Is there system design for freshers at Dream11?

Most reports are for SDE-2; freshers may get more DSA and LLD - ask the recruiter.

Which company does Dream11 belong to?

Dream Sports.

How long is the Dream11 design round?

One report describes a design round of about 90 minutes.

Similar companies - Product and internet companies

More company guides

Read next

On a live call, Cuelyte AI hears questions like these and has an answer ready in about a second, built from your resume and notes. System design interviews: how Cuelyte AI helps

Ready for your Dream11 interview?

Practise these questions with Cuelyte AI: add your resume, type a question and get a clear answer in your own words - in English, Hindi or Hinglish. Free to start.

Start free - no card neededSee pricing