So there was a SQL and resume-based questions for the first round . i was asked questions based on my project and then there was SQL question like Q1) give me the list of employees whose salary is greater than manager salary Q2)nth highest salary without using the offset method and last there was a puzzle the 1 heaviest ball among 8 balls question (Classic interview question ) and a guestimation asking how many people use BMTC bus in a given day

Applied with 2 referrals. 30 min quick phone screening. Second round Python and SQL OA. Third round unstructured case study and SQL questions. Final round includes a 1 hour structured case study and 45 min behavioral. Case studies do not require much prep in my opinion and are very conceptual. However, your interviewer does matter. As a native English speaker, I had a very hard time understanding my final case study interviewer and believe my clarifying questions might've been the rejection.