Razorpay round 1 interview experience
Summary
I had my first round interview at Razorpay for a Senior Software Engineer role, where I was tasked with designing an in-memory SQL-like database. Unfortunately, I was rejected after this round.
Full Experience
Recruter reached out via naukri Exp: 4 years Role: SSE
Round 1:
Design a in memory SQL like databases
- You should be able to store rows
- Column could be of int, string or boolean datatype
- We should be able to set a primary key or set of primary keys
- Create index on the primary key
- Should not break on concurrent operations
- Should be able to create tables, rows and columns
You can find more details about this quesiton on other interview experience on leetcode
Suggestions:
- Don't just directly jump into the problem understand the problem you should know how will you store the data and index the columns that is the important part.
- Keep input sanitization in mind for eg if you give a empty column name or things like that
Verdict: Rejected
Interview Questions (1)
Design In-Memory SQL-like Database
Design an in-memory SQL-like database with the following features:
- You should be able to store rows.
- Column could be of int, string or boolean datatype.
- We should be able to set a primary key or set of primary keys.
- Create index on the primary key.
- Should not break on concurrent operations.
- Should be able to create tables, rows and columns.