The first interview was structured well. The interviewer asked some typical behavioural questions as well as asked to elaborate on my previous work experience. They also asked two SQL-related questions.
Interview questions [1]
Question 1
How did my analytical process look like at my previous job?
Case interview style after a few rounds of initial get to know you interviews. Very friendly people across the board. No qualms with the process. Took a decent amount of prep time outside the interview to prepare the case.