There were 2 rounds – one technical and one HR (though the HR also included a few technical questions). In the first round, the interviewer asked for an introduction, questions from my resume, and details about my projects. I was also asked two DSA questions – one on checking for an anagram and another on rotating an array. I explained my approach before sharing my preferred languages (SQL and C++). Later, I was asked database theory questions and to write an SQL query using the RANK window function. In the second round, I faced behavioral questions such as strengths, weaknesses, what I like/dislike about the company, and where I see myself in 10 years. There were also some SQL queries, one of which I couldn’t fully solve, and a guesstimate question on finding the volume of a table. After both rounds, 17 candidates were selected out of 80 shortlisted.

OA -> Technical coding rounds -> Tech interview -> HR Round -> selected. The Tech Round was on medium level SQL and project related. It went pretty smoothly, I was asked some guessimates and puzzles in the HR round.