Tech IndustryNov 10, 2018
AppleSteveJoobs

Google Product Analyst, Data Science on-site experience

When I was preparing for the interview I had very few resource for this position so I thought making a post about my experience would be helpful. I had 4 rounds of interview in the on-site. The team match was done before on-site for this position and had 3 people from the team interview while 1 was from another team. All of them were product analyst. Behavioral: Each round had a behavioral component going over my background and then asking a detail question about one of the projects I mentioned in my intro. Coding: Each round also had some sort of SQL data manipulation question. When asked if they had a language preference, almost all interviewers said SQL. I’ve always managed to write in whatever language I wanted but this was specific. Although the flavor of sql was up to me. Business acumen: Unlike FB interviews, stats is much lower on the things to be asked. Most questions were on forecast/extrapolation logic and market sizing questions. Defining KPIs were easy as compared to something like fb as questions weren’t very specific to google products but more general. Overall positive experience while interviewing. People seemed interested unlike fb where the interviewer was yawning while speaking to me. Had onsite Thursday, recruiter asked me for interview feedback and said that collecting feedback from interviewers will take sometime and should have updates next week. Hope this helps others better prepare for this kind of interviewing at google! Current TC : 195k YOE: 1.5

Add a comment
New
gtik58 Nov 10, 2018

Thanks for sharing. Although my experience was slightly different: 1. no behavioral questions 2. SQL coding only in the phone screen (it was scheduled in the on-site as well but it never happened) 3. All rounds were heavily focussed on product sense and business acumen - defining KPIs, analyzing trends, understanding user experience, etc 4. 1 probability question 5. 1 ML algorithm question How you structure your responses and your overall communication/personality seemed important. Hope this helps someone.

Seagate toti420 Apr 17, 2019

What was the probability question? If you can’t share, can you please a similar question? What about the ML part?

New
2b or !2b Apr 18, 2019

How random forest works. How to find a biased coin among x unbiased coins.

Amazon cmdgc Nov 10, 2018

Thanks for sharing. Any chance you could share the sql question?

Apple SteveJoobs OP Nov 10, 2018

Given 3 columns of a log like table do basic group by order by to get values like who used the app on a day and who didn’t. Can’t go too much into specifics

Google √-1 Nov 10, 2018

What's your role at apple? And what's the split on your TC ?

Apple SteveJoobs OP Nov 10, 2018

It’s a data analytics role. 130k bass 15 bonus rest is RSU

Uber Deer Nov 14, 2018

Thanks for insights. Interviewing for the same role and currently trying to find peoples experiences. I have read mixed things, this seems like its product/business oriented with coding questions in SQL, but I saw some older posts from August on here where someone was saying the interview was more hardcore DS, heavy stats, and coding questions Python in addition to SQL? Might just be a wide range of skill sets they hire for in this role.

New
TimeOut Nov 14, 2018

No DS or ML. Just do SQL and product/business questions. You should be good.

Google awhmang Feb 11, 2019

Did you get offer? I'm interested in transferring to the ladder so would love to get thoughts on interview

Chegg snt124 May 31, 2019

I’ve heard from people who have interviewed, and also from Glassdoor, that they ask quite a bit of ML/python/R..... seems like maybe people here have had different experiences...?