I applied through cold emailing HR in August and received a call in October.

There were a total of 3 rounds:

• DSA
• LLD
• HLD
• SQL
• Resume

These included 2 technical rounds and 1 HR round.

If you have your basics clear, you can easily crack this interview.

I just had my first-round interview, and they asked SQL questions.

Restaurant Data:

• Restaurant ID: 2821321783, 5829921772
• City ID: 1, 2
• Name: Big Chill, Pizza Hut
• Owner ID: 198213982189, 748257842755
• Brand ID: 288, 199

Billing Data:

• Booking ID: 10C05BF9-8922-492C-ABDC-150C8D578B86, F8FDCC8C-0B84-4A4F-B820-E9A711D4D295
• Restaurant ID: 2821321783, 5829921772
• Order ID: C8389307-2984-47BC-B4CA-CC3A53FF4EA6, CC4D9212-FAD4-423C-A469-FDF238E5F558
• Order Value (INR): 200.5, 976.4
• Year: 2023, 2024

They asked me to:

• Insert new billing data.
• Calculate YoY Gross Revenue on a city level.
• Calculate YoY Average Order Value on a city level.

They also inquired about my previous company and projects (resume grilling).

Additionally, there was one design question: Design a distributed cache.