First round with HR (phone call), second round with team manager and one of the team member, in the second round one small project request and present to manager during the interview , final round with director, then Offer

Two in-person rounds. 24 hours before the interview , sent a case study to analyze data. Next day discussed the answers to the questions , sql test , aptitude test. Case was okay. Sql easy test. Second round behavioral questions .

Phone interview with HR(around 30 minutes), first interview with a case study presentation with the managers, then 2nd round interview with the director. The case study was sent to me two days before the interview, and I had to do a 15 minutes presentation. Final interview was pretty straight forward, it was a chance for the director to meet me and he gets to decide who to hire in the end. I believe the last round had me and other person at least.