I applied online. The process took 4 weeks. I interviewed at Reddit
Interview
Very SQL-heavy. Process was: 1. Technical screen 2. Hiring manager screen 3. Panel of 4 interviews, two technical and two "soft" The process was great up until the end of the interviews, at which point the recruiter and hiring manager both ghosted me and stopped answering messages, without ever saying "no thanks." Ghosting after I've spent 5-6 hours interviewing is not appropriate, and no other company I've interviewed with has ever done this.
Interview questions [1]
Question 1
Medium-difficult SQL questions, requiring either nested subqueries or CTEs, window functions, etc.
Hiring manager first, with questions about experiment design and behavioral questions about the project.
Then, two interviews with product and engineering, all behavioral.
Then, an interview with HM about a case study. Here, knowing the metrics was key. Then a technical interview, discussing verbally what to do with some A/B test results. Finally, a talk with the skip manager, mostly about past work.
One recruiter call, then hiring manager call, technical round, then onsite with 4 rounds about technical, behavioral, case study and meeting with hiring manager and product partner. Technical round was asked SQL and simple python manipulation questions.
Interview questions [1]
Question 1
Tell me one of your past project regarding AB testing