Date: Sept 2024
YOE: 3 years
There were 5 rounds:

1. DS/Algo: Two questions

LIS : Gave the n^2 solution
Number of ways to select buildings
Had 30 mins left after these, so the interviewer asked if I could optimise the LIS code. Made changes to make it nlogn.

Result: Strong hire

2. DB/Work Experience round:

A lot of questions on work experience. Make sure you know the tech mentioned in resume. I had some experience with elastic search so was grilled a bit on it.
Although I didn't really have experience with MySQL, I had put it under skills in the familiar section(I had worked just on the basics) so there were a couple of questions on how indexing happens: answered B+ trees and explained.
Then I was asked about composite indexes. Whether if we have a composite index on column a,b,c and we want to search on a,b, will it help? I didn't know the answer at that time.

Result: Weak hire

I was advanced to the next round as I had the highest score in DSA round the HR had seen(got lucky I guess).

The next three rounds were in Mumbai. Flight tickets and cab(from and to mumbai airport) were booked by them.

Round 3: System Design
Design Zerodha/Groww. Clarified requirements. Some of them were:

1. Wishlists
2. Able to search for stocks
3. Place orders(market orders only)
4. Orders can be sent to exchange and we don't need to worry about sequencing and execution
5. Can get stock price data from exchange

This should be scalable and all typical requirements from HLD.

Interviewer was pretty nice. Realised in person HLD rounds are much better than doing it over a zoom call. It was more of an interactive session than an interview.

Round 4: HM
Typical situational questions
Resume based
Project details etc

Round 5: HR
Typical HR questions
Would you be okay with Mumbai?
Salary expectations etc
A bit about dream11

HR was really nice and ethusiastic about sports so was I.

Got verbal confirmation the next day. Then they do reference check and roll out the offer.

Compensation details: https://leetcode.com/discuss/compensation/5807444/dream11-sde-2-offer-2024/2642514