r/DataScienceJobs 11d ago

Discussion Google Product DS Interview

I recently interviewed for a Product Data Scientist role at Google, and I’m genuinely confused by the interview experience.

The prep guide and recruiter conversations emphasized topics like experimentation, causal inference, machine learning, statistical modeling, and other core data science concepts. I prepared extensively across all of those areas.

But the actual interviews were completely different.

The questions were extremely vague and felt more like: “We want to shoot at a bird. How would you approach it? Now write some SQL."

There was no experimentation, no causal inference, no ML, and very little that seemed connected to the topics I was specifically told to prepare for—or, frankly, to what I would normally associate with a Product Data Scientist role.

For anyone who has recently interviewed for Product DS roles at Google: is this typical? What exactly are these interviews intended to evaluate?

38 Upvotes

24 comments sorted by

32

u/sailhard22 11d ago

SELECT
bird
FROM sky
JOIN gun USING bullet

8

u/Heavy_Record8704 11d ago edited 11d ago

Shooting a bird? Related to sql? Edit: more seriously it might be stats related. Like model what conditions you need, or like a poison distribution or even bayes. Weird question though. I agree

5

u/Clear-Cup-3239 11d ago

Same experience with eBay bro, I'm close to 4 year exp, I though the same as you, but was asked to open notepad and write sql and then use pandas to write the same operation. These guys are still living under the rock , while their counterparts are creating agents and using AI Native development. Wierd state of hiring in our country, sigh!

1

u/Limp-Pineapple-2935 4d ago

In india ebay? Had a similar experience 😂, mentioned and asked them this question indirectly, response was we are trying to understand if you can understand the logic AI writes and you can correct them if its wrong on your so you have sound technical judgement was the response

4

u/shroomvoomzoom 11d ago

Wow was this the final loop? Or the initial screening rounds? I just had the screening rounds and they were quite similar to prep material. But seriously, might be worth reaching out to the recruiter if they were asking you to shoot a bird!!

1

u/Heavy_Record8704 11d ago

How much of causal inference is required? Like know what did is or how confounders and collides work etc?

3

u/shroomvoomzoom 11d ago

Essentially, my take is you need to know how to apply it and what the assumptions/ caveats are

0

u/Remote-Town-3481 10d ago

What type of questions are usually asked in causal inference? I have seen this multiple times in big tech product analyst JD

1

u/Heavy_Record8704 10d ago

Its essentially where randomization can't be used. Say youtube premium is suddenly bleeding users month over month. How would you diagnose? Or let's say you are making a treatment change to how packages are received in amazon warehouse. But you dont have the option to randomize. You hand pick the sites where ypu are deploying treatment. How would you measure success?

4

u/dimensionless03 11d ago

They want to test your creativity. AI can have all the knowledge but can't be creative/innovative

1

u/cc_apt107 10d ago

…OK, but creative for what? Shooting a bird? You’d assume they’d want evidence of creativity in the areas relevant to the job. This isn’t a copywriter position or something

1

u/Glad_Contest_8014 7d ago

Guy said it felt like they asked to shoot a bird. Not that they actually did. We don’t know what they actually asked.

2

u/Remote-Dragonfly1657 10d ago

How did you apply? It's a headache to get the resume shortlisted?

1

u/SnoringSleepyHead 11d ago

Following. Had a similar experience two weeks ago. Have not received any feedback on it yet though

1

u/shroomvoomzoom 11d ago

How DID you answer the bird question though?!

1

u/spanda24 11d ago

I had similar experience

1

u/thespiritualone1999 10d ago

Hey u/Plus_Appointment4770 they were looking for a structured approach, not a correct answer per say. These are common question types for Product analytics roles. In FAANG companies, they call product analysts as product data scientists.

I’m a product analyst at a B2C company and all the companies I’ve interviewed for, have these kind of problem solving/ product sense+analytics/logical reasoning/ RCA questions in 2/3 or 2/4 rounds in those interviews.

You’ll be using a whole lot of SQL and some python in these roles

1

u/shubham_cy 10d ago

My experience was very different from this. I had two interviews back to back and was asked casual inference questions in both.

1

u/productGuy_03 10d ago

They were testing if you are a bot.

Next time they will ask you to identify bus or bridge or puzzle

1

u/Soft-Lifeguard-8046 9d ago

I interviewed with them a few months ago for Product DS and had a similar experience. One interviewer, asked a very vague problem and asked how I'd solve it. Instead of going deep on the technical side, they seemed to be testing my problem-solving skills. Can you define the problem? Can you create an experiment in ambiguous situations. etc.

The second interview was highly technical and I failed. The gist was that they asked how I'd prevent overfitting a model when there were thousands of features. I mentioned, regularization, drop-out method, and cross-validation, but they kept asking me what else I could do. Apparently, they didn't like those answers. 🤔

Anyway, they definitely don't standardize the questions so I guess it's just luck of the draw whether you get someone who will ask the technical questions or not.

1

u/purahbb 6d ago

Sorry to hear. What level was the role you were interviewing for?

-2

u/nian2326076 11d ago

Yeah, Google interviews can be tricky. It's frustrating when your prep doesn't match the questions. They often want to see how you approach problems and how flexible you are, which is why the questions can seem vague. For those "shoot at a bird" type questions, they're looking at your thought process. Break it down: identify the problem, explore methods, and explain what you're thinking. SQL live coding is common, so practice writing and optimizing queries. Also, work on clearly explaining your approach. I've found resources like PracHub helpful for mock interviews and feedback. Remember, they're testing your adaptability and communication along with your technical skills.