Upvote if it helps you :)
1. DSA round:
2. DB Round:
- Prepare everything related to databases sytem design.
- DB Schema in your past project and database infra at your previous organisation.
- How do you speed up performance of sql queries?
indexing - what kind of indexes to build, unique constraint, indexing internals
- How to increase read throughput of database? partitioning, sharding, how to determine number of shards
- How to ensure atomicity? transactions, isolation levels, how they solve dirty reads
- Single leader replication, handling replication lag, increase read throughput, handling leader failure
- Strong and weak consistency
Onsite
They called me to Mumbai for their onsite.
1. System Design:
- Design dream11's Team creation service -> user can create team with constrainsts, choose players from squads and create their team. Questions around CRUD operations in API, database schema, how to implement scalability, disaster recovery etc.
2. Hiring Manager round:
- Project deep dive.
- Questions around collaboration and work ethics.
- You see sudden latency spike in system, how would you debug it?
- Only 20k users can join in a contest. How would you implement this constraint, when millions of concurrent requests are there?
3. HR round