The interview process was virtual. There were a total of 3 rounds total. I was not shortlisted for the 2nd round. There were questions on the concepts of computer science engineering and problem solving.
Interview questions [3]
Question 1
Questions about my work experience and past projects from my resume.
I applied online. The process took 1 week. I interviewed at Zomato (Gurgaon, Haryana) in Oct 2024
Interview
I have applied through cold emailing HR in August and got a call in October. There were total 3 Rounds(DSA+LLD+HLD+SQL+Resume)
2 Tech and 1 HR round. If you have your basics clear you can easily crack this Interview.
Interview questions [1]
Question 1
I just gave first round and they asked SQL question
Restaurant
Restaurant ID
City ID
Name
Owner ID
Brand ID
2821321783
1
Big Chill
198213982189
288
5829921772
2
Pizza Hut
748257842755
199
Billing
Booking ID
Restaurant ID
Order ID
Order Value (INR)
Year
10C05BF9-8922-492C-ABDC-150C8D578B86
2821321783
C8389307-2984-47BC-B4CA-CC3A53FF4EA6
200.5
2023
F8FDCC8C-0B84-4A4F-B820-E9A711D4D295
5829921772
CC4D9212-FAD4-423C-A469-FDF238E5F558
976.4
2024
Insert new billing data
YoY Gross revenue on city level
YoY Avg order value on city level
And asked about my previous company and projects(Resume grilling)
1 Design Question - Design a distributed Cache