Interview Experiences

Real candidates, real loops: every round, what was asked, and how it ended.

Share yours, earn XP

4433 stories

Likes earn the author +10 XP for the first 3 likes each day

GoogleData Scientist
Oct 2025

A Brutal CRR SQL Question with LAG and 4-5 CTEs

This isn't a super fresh write-up, but while I was prepping I noticed there weren't many Data Scientist interview experience posts here, so I'm sharing mine. First was the HR phone screen — we talked a bit about projects I'd worked on before and they asked about my SQL and Python experience. I passed and got scheduled for the first round. The first round had two sessions: they said it would be on…

RejectedTechnical Screen0
Capital OneData Scientist
Oct 2025

OA, Data Challenge, and a Four-Round Power Day

At the end of July, a friend referred me for a Capital One SDA position. Then nothing for about a month. 9/5: The recruiter emailed with the OA, valid for one week. The OA wasn't hard but the time was tight — 70 minutes for 15 questions, 14 multiple choice and 1 SQL. The first seven questions used one CSV, the eighth was the SQL question, and the last seven used four more CSVs where you had to me…

OfferOnsite0
DropboxData Scientist
Oct 2025

Two OAs, Then Six Interview Sessions Across Three Rounds

Locked — open it to unlock the full story with XP.

OnsiteXP0
Capital OneData Scientist
Oct 2025

Role Play, Hiring Manager, and End-to-End Model Rounds

Locked — open it to unlock the full story with XP.

OnsiteXP0
UberData Scientist
Oct 2025

Four Onsite Rounds, Rejected on Analytics and Bar Raiser

Locked — open it to unlock the full story with XP.

RejectedOnsiteXP0
MetaData Scientist
Oct 2025

Offer on Christmas Eve After a Screen and a VO

Got the offer on Christmas Eve — sharing it back with the forum. Timeline: Oct 29 — a university recruiter reached out Nov 19 — screening interview with the interviewer Dec 19 — VO (virtual onsite) with the interviewer Dec 24 — offer I was genuinely swamped at the end of the year, and on top of that I knew nothing about product case questions or SQL, so I ended up dragging this whole process out.…

OfferOnsite0
Capital OneData ScientistIntern
Oct 2025

Bombed the Coding Round, Still Got the Offer

Locked — open it to unlock the full story with XP.

OfferOnsiteXP0
DoorDashData Scientist
Oct 2025

Four Onsite Rounds, No Self-Intros, and a Prickly HM

Locked — open it to unlock the full story with XP.

OnsiteXP0
CVS HealthData Scientist
Oct 2025

Case Questions on Campaign Design and MMX Models

Today I made it through the second round (not counting HR), talking with a senior data science manager. They mainly asked a few case-style questions: If you were sending an email campaign to get people to go get a flu shot, how would you design the campaign? Mainly wanted me to share my thinking and the factors I'd consider. If you wanted to launch a TV channel campaign, how would you design it?…

In progressTechnical Screen0
InstacartData ScientistSenior+
Oct 2025

Three-Part Onsite: Take-home Review, Stats, and a Supply-Demand Product Case

Locked — open it to unlock the full story with XP.

OnsiteXP0
AmazonData ScientistNew Grad
Oct 2025

Five Rounds Split Across Two Days

Amazon DS new grad interview experience. Five rounds total — the first round was a screening, and the other four were split across two days, two rounds each day. Of the five rounds, one was pure behavioral (BQ). The interviewer's title was Spec. Principal Sales Rep, and they asked "tell me about a time when you..." style questions the whole way through. Since the interviewer was a non-tech audien…

Onsite0
Capital OneData Scientist
Oct 2025

the Ride-Share Profitability Mini Case

I just finished my mini case this morning, sharing it while I still remember everything. I've gotten a lot of help here, so I wanted to give back too. Hope everyone's interviews go well. Today's interview was the exact question someone here had already shared — the original Google Doc question — and of course that was the one question I hadn't gotten around to preparing. Felt like I'd practiced p…

Technical Screen0
MetaData Scientist
Oct 2025

A Notification Launch Case Built From Adversarial Follow-ups

Locked — open it to unlock the full story with XP.

Technical ScreenXP0
GoogleData Scientist
Oct 2025

Five Rounds Covering Stats, Modeling, R, and a Battery-Life Case Study

Locked — open it to unlock the full story with XP.

OnsiteXP0
ShopifyData Scientist
Oct 2025

OA Then a One-Hour Life Story Call, Rejected

Locked — open it to unlock the full story with XP.

RejectedHR ScreenXP0
MetaData Scientist
Oct 2025

Two SQL Questions on Post Success Rate

Locked — open it to unlock the full story with XP.

Technical ScreenXP0
MetaData Scientist
Oct 2025

AR, AE, SQL, and BQ Onsite Rounds, No Offer

Honestly, way too many people have been copying interview notes over to Xiaohongshu lately, so I've set some limits on mine — I don't want to be scrolling xhs and suddenly run into my own interview notes, lol. AR: Felt like a new question — hadn't seen it in recent interview notes. The question was: suppose you're on the ads team and you built a new ad recommendation model, how would you go about…

RejectedOnsite0
StripeData Scientist
Oct 2025

Manager Screen, a Week-Long Take-Home Project, Then an Onsite Presentation

Locked — open it to unlock the full story with XP.

In progressTechnical ScreenXP0
Flatiron HealthData Analyst
Oct 2025

Passed Coding, Cut on the Final Case Round

Let me share a DA interview. I signed an NDA so I won't go into detail. From what I've seen on the forum, it feels like nobody has ever gotten an offer from this one... so I didn't have very high hopes going in, and sure enough, that's how it went. First was the Karat screen: they tested SQL, R, and some statistics knowledge. A week later I got the invite for the first round. Round 1: they asked…

RejectedOnsite0
ChimeData Scientist
Oct 2025

SQL and a Business Case in One Technical Screen

This round is split into two parts: one hour of SQL and one hour of a case study. SQL: They give you a transaction table and a user table. If you're fast you'll probably get through 5-6 questions. The time field is a timestamp, so you need to use date_trunc to handle it. The first few questions are pretty basic and you can knock them out with a few CTEs. It involves several window functions like…

Technical Screen0

What are interview experiences?

An interview experience is a candidate's own account of a hiring loop — not a question bank entry. It tells you the shape of the process: how many rounds there were, what each round actually tested, how long the gaps between them ran, and what the recruiter said at the end. That context is the part a question list cannot give you.

How to read them

Weight recent write-ups more heavily — interview loops change, often within a year. Read several for the same company and role rather than one: a single account tells you what one interviewer asked, while five tell you what the bar is. Note the outcome badge too, since a rejection write-up usually explains the gap far more precisely than an offer one.

Share your own

Every published experience earns 50 XP, and each of the first 3 likes it receives in a day earns you 10 XP more. Likes must come from established accounts; like-for-like swaps and likes from your own second account are not paid. Write it while the details are fresh — the round order, the exact prompts, and how much time you were given are what the next reader needs.

Share your experience to earn XP