Swiggy
Leading Indian food delivery aggregator with complex real-time logistics.
4 Rounds
~15 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 restaurants in each city based on the number of completed orders in the last 30 days.
#Window Functions
#Aggregations
#Date Functions
Data Scientist
•
Coding
•
hard
Write a SQL query to calculate the week-over-week retention rate of new users who joined in Q1.
#Cohort Analysis
#Self Joins
#Date Manipulation
Data Scientist
•
Coding
•
medium
Write a SQL query to find delivery executives who have a cancellation rate of more than 5% but have completed at least 100 orders.
#Filtering
#Aggregations
#Having Clause
Data Scientist
•
Coding
•
hard
Write a SQL query to calculate the median order value for each user segment (e.g., Swiggy One vs. Non-Swiggy One).
#Percentiles
#Window Functions
#Advanced SQL
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.