The interview process had total of 4 rounds, including test which had statistics and analytical questions to solve in a limited period of time, once the test was completed I heard from the HR almost after 2 months that I had cleared the test and my case study round was scheduled for next morning. The case study had a genuine business problem which I was required to solve using sql, I was given one hour to solve everything. After the case study round I had 1:1 to discuss the answers I provided in case study, we discussed my answers and why I used that approach. It went for an hour after which I received the call from HR for the final round which was fit round. Fit round had puzzles and tricky estimation questions tagged with general HR questions. I received the selection mail the next 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.