Cold-emailed HR in August, got a call in October: 2 tech rounds (DSA+LLD+HLD+SQL+Resume) + 1 HR

Application

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