Technical Round-1 (DSA + CS Fundamentals) : (1 hr)
The interviewer was a backend developer
We started with our introductions and then moved to the project discussion.
Project discussion (10 min):
- I explained to him about the previous project of my company for around 10 minutes.
- There were a few questions about the architecture.
CS Fundamentals:
- He asked if I was comfortable with the SQL. Then asked two queries- Find 2nd highest salary of the employee. Find the 5th highest salary.
- Some discussion over LIMIT and OFFSET. I was not very well prepared with them.
- Then he asked about a situation where a customer orders similar kinds of food every day from a food delivery app, and how can we decrease the query time from DB.
- I gave the solution of storing in a Cache, and Then we discussed about cache-implementing algorithms like LRU. He asked me to implement it.
Problem Solving- https://leetcode.com/problems/lru-cache/description/
I could implement it partially but I explained my approach completely and the interviewer seemed satisfied with it, then he asked me to dry run for the sample input. I did that and showed my output.
By then, we were done with the interview. He asked if I had any questions.
Overall my experience was positive and I was hoping to be called for the next round.
Feedback: HR became unresponsive over texts and calls. I tried reaching out multiple times but didn’t hear from her. So, I concluded that I might have been rejected.
Verdict: Rejected
ClickPost Interview Experience For Software Engineer (2023)
I Applied through Instahyre.