There were two technical rounds followed by one HR discussion round. Round 1 - The interview began with a basic introduction and the work that I had done in my previous organisation. The interviewer asked a couple of questions from previous experience. Then he moved to database related questions revolving around transactions and ACID properties followed by a couple of SQL query questions. At last there was a easy-medium DSA problem involving binary search on an unsorted array. I was asked to write the working code which was evaluated for multiple test cases. Round2 - This round started with discussion around previous work. Then the interviewer moved to in-depth questions around database query optimisations. Asked to choose between a SQL database or NoSQL database along with justfying every decision I was taking. There were a couple of questions around distributed systems and CAP theorem. At last there was project discussion from the resume.

I had a total of three interview rounds and overall, it was a great experience. The HR team and interview panel were very supportive and approachable throughout the process. Round 1: Focused on Data Structures and Algorithms (DSA), along with a bit of Low-Level Design (LLD) if time permitted. Round 2: A detailed discussion based on my resume and previous work — covering project overviews, design approaches, and potential improvements. This round also included an LLD-based question where I was expected to design the complete class structure, relationships, and database schema. Round 3: HR discussions.