The Interview process had 6 rounds - 1. The 1st is an HR call [10 min] 2. The assessment on Sql and python code-very simple 3. A technical call with 3 panelist -mostly a manager, consultant 4. A case study round 30 min - a case study will be given and you have to work on it .Pretty simple , can do on excel but they are interested in though process. 5. HR round with behavioral questions-30 min 6. A round with Principal -10 min.Simple conversation

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.