2 rounds in total, the techincal virtual on-site was broken into 2 days as I requested. I applied with a referral and heard back almost immediately. It was delayed a bit due to their winter break but once they returned to the office, the process was really smooth.
Interview questions [1]
Question 1
Design a data schema for an online exercise app. Design the data system to support a daily data ingestion.
I applied through an employee referral. I interviewed at DoorDash (San Francisco, CA)
Interview
There was a phone call in the beginning. Then I had an assessment which had 4 SQL questions and 1 Python question. Then after that I had a technical interview which was simple with just some Python questions using basic libraries. Then I had 4 interviews. One for Product mindset, one was technical with SQL Hackerank questions, one for Case study, and one for executive review. Honestly, for someone with experience it would have been easy. But since I didnt, I couldn't do well.
Interview questions [1]
Question 1
In the interview, they gave me Python questions involving Groupby, value counts etc. SQL questions also involved group by, having, rank, cte, distinct, all the basics
