So, At first it was HR interview, After that a technical interview (SQL and Python - 2 questions each) and a long code of SQL that needed to be explained. After that. I had an interview with Hiring Manager and a case study in the last round. It had 4 rounds in total.

The hiring manager started the first round interview with "I'm gonna get ahead of this but based on your experience I don't think it's a good fit." Huh?? Then why do the interview in the first place? this wasn't even a referral? They were dismissive the whole interview and I couldn't wait for it to end. Also mentioned the role wouldn't be technical which tells me the JD was misleading. Additionally, the pay is below average for the level of experience they were requiring. Overall, not worth it - especially if the interview would be indicative of management style.