Google data scientist technical screen

just wanted to share a recent google interview experience for a product data scientist role, specifically its technical screens.

for this role, it has 2 technical screens, which are the same format as the 2 technical rounds for the on-site. it’s not like other big tech companies where the screen acts as the filter, and the on-site rounds are usually more of a technical deep-dive.

first technical round is sql + a/b testing, second technical round is ML.

1. a/b testing sample question: test metric moved, figure out if it’s a real effect
2. sql: window functions, multi-table joins, aggregations
3. ML : no implementation, about model evaluation, closer to product sense

there was also an HR round, which shouldn’t be underestimated because it has questions like how you’d communicate insights to non-technical stakeholders. so you’d have to answer using plain language, no terms or jargon like p-value or lift.

another tip is to ask your recruiter what the team is working on so you can closely align your stories/experiences with what they’re solving.

more details from the full experience, including sample questions, follow-ups, and prep notes are in the link i shared above.