Zomato Online Assessment

Overview

Zomato online assessment (OA) is the first round of Zomato’s placement process. This guide covers the Zomato online assessment format for both SDE and Product Analyst roles, question types, preparation strategy, and tips to clear the OA.

Role-Specific OA

Zomato online assessment format varies by role. SDE roles focus on DSA and coding, while Product Analyst roles include SQL and data analysis questions. Prepare accordingly based on your target role.

Zomato Online Assessment format

SDE role OA structure

Component	Details	Time Allocation
Platform	HackerRank or similar	-
Duration	90-120 minutes	Total time
DSA Problems	2-3 coding problems	60-80 minutes
Debugging	1-2 debugging questions	20-30 minutes
Languages	Java, C++, Python, Go	-
Evaluation	All test cases must pass	-

Product analyst role OA structure

Component	Details	Time Allocation
Platform	HackerRank or similar	-
Duration	90-120 minutes	Total time
SQL Queries	2-3 SQL problems	30-40 minutes
Data Analysis	Case study questions	30-40 minutes
Coding	Basic Python/SQL	20-30 minutes
Evaluation	Correctness and logic	-

Zomato Online Assessment question types

For SDE roles

1. DSA problems

Zomato online assessment questions for SDE focus on:

• Arrays & Strings: Manipulation, searching, pattern matching
• Trees & Graphs: Traversals, algorithms, shortest paths
• Dynamic Programming: Optimization problems
• System Design Concepts: Order matching, delivery optimization

2. Debugging questions

• Identify and fix bugs in code
• Improve code efficiency
• Correct logical errors

For product analyst roles

1. SQL queries

Zomato product analyst online assessment questions include:

• Joins: Inner, left, right, full outer joins
• Aggregations: GROUP BY, HAVING, aggregate functions
• Window Functions: ROW_NUMBER, RANK, DENSE_RANK
• Subqueries: Correlated and non-correlated subqueries
• Data Manipulation: INSERT, UPDATE, DELETE operations

2. Data analysis problems

• Interpreting data and finding insights
• Product metrics calculation
• A/B testing analysis
• Business logic questions

3. Case study questions

• Food delivery domain problems
• Order matching optimization
• Delivery time analysis
• Customer behavior analysis

Sample Zomato Online Assessment questions

SDE role questions

Question 1: array problem

Q: Given an array of delivery times, find the minimum time to deliver all orders (similar to meeting rooms problem).

Problem: Given delivery times for orders, find the minimum time to complete all deliveries with limited delivery agents.

Solution:

public int minDeliveryTime(int[] deliveryTimes, int agents) {
    Arrays.sort(deliveryTimes);
    int[] agentSchedule = new int[agents];

    for (int time : deliveryTimes) {
        int minAgent = 0;
        for (int i = 1; i < agents; i++) {
            if (agentSchedule[i] < agentSchedule[minAgent]) {
                minAgent = i;
            }
        }
        agentSchedule[minAgent] += time;
    }

    int maxTime = 0;
    for (int time : agentSchedule) {
        maxTime = Math.max(maxTime, time);
    }

    return maxTime;
}

Time Complexity: O(n log n + n*k) where k is number of agents

Question 2: graph problem

Q: Find the shortest path for delivery (Dijkstra’s algorithm variant).

Solution:

public int shortestDeliveryPath(int[][] graph, int start, int end) {
    int n = graph.length;
    int[] dist = new int[n];
    Arrays.fill(dist, Integer.MAX_VALUE);
    dist[start] = 0;

    PriorityQueue<int[]> pq = new PriorityQueue<>((a, b) -> a[1] - b[1]);
    pq.offer(new int[]{start, 0});

    while (!pq.isEmpty()) {
        int[] curr = pq.poll();
        int node = curr[0], distance = curr[1];

        if (node == end) return distance;
        if (distance > dist[node]) continue;

        for (int i = 0; i < n; i++) {
            if (graph[node][i] > 0) {
                int newDist = distance + graph[node][i];
                if (newDist < dist[i]) {
                    dist[i] = newDist;
                    pq.offer(new int[]{i, newDist});
                }
            }
        }
    }

    return -1; // No path found
}

Product analyst role questions

Question 1: SQL query

Q: Find the top 5 restaurants by order count in the last 30 days.

Solution:

SELECT
    r.restaurant_id,
    r.restaurant_name,
    COUNT(o.order_id) AS order_count
FROM restaurants r
JOIN orders o ON r.restaurant_id = o.restaurant_id
WHERE o.order_date >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)
GROUP BY r.restaurant_id, r.restaurant_name
ORDER BY order_count DESC
LIMIT 5;

Question 2: data analysis

Q: Analyze delivery time trends and identify factors affecting delivery time.

Analysis Approach:

1. Calculate average delivery time by time of day
2. Analyze delivery time by restaurant location
3. Identify peak hours with longer delivery times
4. Correlate delivery time with order value
5. Find restaurants with consistently long delivery times

Key Metrics:

• Average delivery time
• Delivery time by hour
• Delivery time by location
• On-time delivery percentage

Zomato product analyst OA - deep dive

The Zomato Product Analyst OA (from student reports) is less “LeetCode hard” and more SQL + metrics + product sense. Expect a timed online set that mixes query writing, interpreting tables/charts, and short case prompts about food-delivery funnels.

PA OA block	What shows up	Pass signal
SQL	Joins, GROUP BY, window functions, date filters	Correct logic + readable query
Metrics	AOV, retention, conversion, delivery SLA	Define metric before computing
Case / product	Promo impact, restaurant ranking, ETA	Structured recommendation
Light Python/Excel (some drives)	Aggregate / clean a small table	Clean steps > fancy code

Extra product analyst OA samples

Q3 (SQL): Repeat customers in last 90 days

Count users with ≥2 completed orders in the last 90 days.

SELECT COUNT(*) AS repeat_users
FROM (
SELECT user_id
FROM orders
WHERE status = 'completed'
AND order_date >= CURRENT_DATE - INTERVAL '90' DAY
GROUP BY user_id
HAVING COUNT(*) >= 2
) t;

Q4 (Metrics): Promo ROI sketch

A ₹50 coupon on first orders lifts new users by 20% week-over-week, but average order value falls 8%. How would you decide if the promo should continue?

Approach: Estimate incremental margin = (incremental orders × contribution per order) − coupon cost − ops cost; check retention of coupon users in week 2-4; call out selection bias. PA OA rewards a clear framework over a single “yes/no.”

Q5 (Case): Restaurant discovery

Organic search CTR for “biryani” dropped 15% in one city. List three hypotheses and one metric to validate each.

Sample hypotheses: ranking bug, competitor ads, supply gap in top restaurants. Metrics: impression share, add-to-cart rate, active restaurant count in that cuisine.

PA vs SDE OA

Applying for Product Analyst? Prioritize SQL + product metrics on this page. Applying for SDE? Use the DSA samples above and the Zomato coding questions set. Same company hub: Zomato placement papers on this site.

How to prepare for Zomato Online Assessment

For SDE roles

Master DSA

Practice arrays, trees, graphs, and DP problems. Solve 100+ problems on LeetCode/HackerRank focusing on medium and hard problems.

Food delivery domain

Study order matching algorithms, delivery optimization, and system design concepts relevant to food delivery platforms.

Practice OA questions

Solve Zomato OA previous year questions. Practice under time constraints and focus on optimal solutions.

For product analyst roles

Master SQL

Practice complex SQL queries including joins, aggregations, window functions, and subqueries. Solve 50+ SQL problems.

Data analysis

Practice interpreting data, calculating metrics, and analyzing trends. Study product metrics and A/B testing concepts.

Domain knowledge

Understand food delivery business model, order flow, delivery optimization, and customer behavior patterns.

Zomato Online Assessment tips

Role-Specific Preparation

Prepare based on your target role. SDE roles require strong DSA skills, while Product Analyst roles need SQL and analytical thinking. Understand the role requirements before preparing.

General tips

1. Understand Role Requirements: Prepare based on SDE vs Product Analyst role
2. Read Problems Carefully: Understand constraints and requirements
3. Plan Before Coding: Outline approach and algorithm
4. Handle Edge Cases: Consider empty data, null values, etc.
5. Test Your Code: Verify with sample inputs
6. Manage Time: Allocate time wisely across questions

SDE-Specific tips

1. Optimal Solutions: Focus on time/space complexity
2. All Test Cases: Ensure all test cases pass
3. Clean Code: Write readable, well-structured code
4. Domain Context: Consider food delivery use cases

Product analyst-specific tips

1. SQL Best Practices: Write efficient, readable queries
2. Data Interpretation: Clearly explain insights
3. Business Logic: Connect analysis to business impact
4. Metrics Calculation: Accurately calculate product metrics

External preparation resources for Online Assessment

Youtube tutorials & video guides

DSA & coding practice

Recommended Channels:

• Take U Forward - Complete DSA course, coding interview prep

• Striver’s SDE Sheet - 180+ coding problems with video solutions

• Aditya Verma - Dynamic programming masterclass

• CodeWithHarry - Programming fundamentals

  Search: “Zomato OA questions”, “online assessment preparation”, “coding interview practice”

Mock OA practice

YouTube Search:

• “Zomato online assessment experience”

• “Zomato OA questions 2025”

• “How to clear Zomato coding round”

• “Zomato HackerRank test”

  Learn from candidates who cleared Zomato OA

Online practice platforms

Prepinsta

PrepInsta Resources:

• Zomato OA mock tests

• Previous year OA questions

• Practice tests with solutions

• Time management tips

  Website: prepinsta.com/zomato

HackerRank

HackerRank Practice:

• Coding challenges similar to Zomato OA

• Practice problems by difficulty

• Mock assessments

• Time-bound practice

  Website: hackerrank.com

LeetCode

LeetCode Practice:

• 2000+ coding problems

• Company-tagged questions

• Mock interviews

• Weekly contests

  Focus: Medium to hard problems for Zomato OA

Geeksforgeeks

GeeksforGeeks Resources:

• Zomato OA experiences

• Practice problems with solutions

• Company-specific preparation

• Interview preparation articles

  Website: geeksforgeeks.org/zomato

Practice resources

Zomato Placement Papers→

Practice with Zomato placement papers containing OA questions from previous years.

Zomato preparation guide→

Complete preparation guide for Zomato placement including OA strategy.

Zomato coding questions→

Practice Zomato coding questions with detailed solutions covering DSA and system design.

Comments & Suggestions

Related resources

• Zomato Placement Papers Main Page - Complete guide with eligibility, process, and preparation
• Zomato Interview Experience - Real interview experiences and tips
• Zomato Coding Questions - Practice coding problems

Similar companies

Swiggy · Flipkart · Paytm · Phonepe · Meesho · Blinkit

WhatsAppFacebookTelegramEmail