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.

Good thing they don't have recruiter screening. The first step is SQL (30 mins) followed by case study (30 mins). Looks like they just interview for the sake of training their employees. Literally waste of time preparing for Doordash. I reading all the reviews about toxic work culture. I should have taken it easy. The recruiters just give 1 min intro. I have completed all the SQL questions and even explained them to the recruiter. Case study also went well but I have received rejection within 3 hrs. Its disspointing that I spent whole week preparing for it even after reading the reviews.