The interviewee asked me about my projects,We had a 15 min discussion my role in my projects in my resume.After that I was asked about basic SQL questions and why I fit in perfectly in ZS Associates.

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.