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.

Interview was 1 sql round and 1 case interview. SQL had group by, cte, lag, etc. case interview mentions a case then walking through defining success metrics, design experiment and diagnostic