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

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.