1st Round: 1st round was a pen-and-paper written test that included writing SQL queries and correcting the given SQL queries (if any) and a basic programming question for which you could only use Python or Java. This round also had a Google form with MCQs of computer fundamentals.
2nd Round: This was a face-to-face interview which was majorly based on my Resume. I was asked 1 DSA question (Given the value of a node in the linked list delete that node). Was asked about the working of Kafka and the spark architecture. Basic OOPs (4 pillars of OOP). Real-life applications of stacks and queues. Was also asked to design the backend of Zomato.
3rd Round: This round was more of a managerial round and we discussed my skills some basic managerial questions and how I would fit in the organization."