phone screen and Zoom meeting with the hiring manager for 30 minutes. After that, I did a take-home assignment and submitted it in 72 hours, but i did not pass this one

Quick HR screening where they talk about the role, salary, benefits and how the entire hiring process works. Then there is the technical screening. Round 1 is a SQL round (hackerrank medium-level) with questions that are resemble the actual work that they do there. There are 4 questions, but there's barely any time for the last question and I was told it's not actually expected that you solve it all. Round 2 is a case study, just an open-ended business problem and you have to walk them through how you would deal with it. Virtual onsite is 4 rounds - 1 round with a cross-functional partner (behavioral) and 3 case studies just like the technical screening, they're just checking for consistency here, there's nothing new to expect.

1. First round of interview was 30 min SQL (very easy) + a case study 2. Second round had 3 case studies and one cross functional interview Interviewers were kind. 2 of the case studies were straight forward, one was very ambiguous.