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.