1. Introduction call with manager - More about my experience and role requirements
2. Take home data assessment - A business case was given along with the data sets. The ask was to find an issue, suggest the solution and write an email to explain the issue to tech team as well as the main client.
3. SQL + Python 1 hour technical interview - SQL join queries and basic python coding questions
4. SQL 1 hour technical interview - heavy on joins, windows functions, aggregations.
5. Business Case/ Behavioral Interview
6. Manager interview (cultural fit, expectations, etc.)
The process was quick but only thing I did not like about the interview was in my 4th interview (first interview on super day) my interviewers didn't seem to be involved that much while asking questions. I asked couple of clarifying questions and I was asking more as I was writing the query but if interviewers have been more interactive I think that could have helped!