1. SQL - 4 questions, Easy - Medium. Window functions and aggregations 2. Case Study question - open ended conversation, interviewer guides you along well. looking for structure and thought process here

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.

I applied online and after about a week, I received an email from the recruiter with a 15-question questionnaire. The next day, they scheduled a 1-hour interview consisting of a 30-minute case study and 30-minute SQL round. I spent significant time preparing and felt the interview went well. However, I received a rejection within 15 minutes after the interview ended. Honestly, the process felt discouraging. It almost seemed like the interview was conducted more for internal interviewer training than genuine hiring consideration. If you're interviewing there, I’d suggest treating it mainly as practice and interview experience rather than getting overly invested in the outcome.