zomato logo
Zomato· SDE-2

Zomato SDE -2 interview experience

Posted
12 Feb 2026
544 reads

Summary

I interviewed for an SDE-2 role at Zomato via referral and was rejected after several technical rounds covering system internals (Redis, Kafka), SQL, and Low-Level Design.

How it went

Zomato Interview Experience | November 2025 | SDE-2

Application Mode: Referral
(They only accept applications via employee referrals.)

Round 1

Redis

  • Why is Redis extremely fast?
  • How does Redis handle large scale despite being single-threaded?

Kafka

  • How can consumer throughput be increased?
  • What happens when consumption lags behind production?

SQL

Given: Order state transitions with timestamps
States: Created → Confirmed → Reached Merchant → Reached Customer → Delivered

Questions:

  • Write a query to fetch all order IDs with their latest state in the last 1 hour
  • Exclude orders that are already delivered
  • How would this query behave at scale?
  • What indexes would you add?

Low-Level Design - Snake and Food Game

  • Design snake movement logic
  • Ensure movement happens in O(1)
  • Handle food consumption and snake growth
  • Explain data structure choices & trade-offs
  • Write pseudocode

Result: Rejected

Questions asked (7)

  1. 01

    Redis Performance

    Other

    Why is Redis extremely fast?

  2. 02

    Redis Scalability (Single-Threaded)

    Other

    How does Redis handle large scale despite being single-threaded?

  3. 03

    Kafka Consumer Throughput Optimization

    Other

    How can consumer throughput be increased in Kafka?

  4. 04

    Kafka Consumer Lag Scenario

    Other

    What happens in Kafka when consumption lags behind production?

  5. 05

    SQL Query for Latest Order State

    Data Structures & Algorithms

    Given order state transitions with timestamps (States: Created → Confirmed → Reached Merchant → Reached Customer → Delivered), write a query to fetch all order IDs with their latest state in the last 1 hour, excluding orders that are already delivered.

  6. 06

    SQL Query Performance and Indexing at Scale

    System Design

    How would the SQL query to fetch order IDs with their latest state behave at scale? What indexes would you add?

  7. 07

    Low-Level Design: Snake and Food Game

    System Design · Medium

    Design the snake movement logic for a Snake and Food Game. Ensure movement happens in O(1). Handle food consumption and snake growth. Explain data structure choices & trade-offs. Write pseudocode.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Zomato recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!