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
Thanks for sharing. Any chance you could share the sql question?
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
What's your role at apple? And what's the split on your TC ?
It’s a data analytics role. 130k bass 15 bonus rest is RSU
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.
No DS or ML. Just do SQL and product/business questions. You should be good.
Did you get offer? I'm interested in transferring to the ladder so would love to get thoughts on interview
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...?
India
13h
636
Average user at r/india (future Blind)
2024 Presidential Election
Yesterday
2435
Biden ruined America and tech! Tax plans are insane
Layoffs
2d
42172
Google CFO confirms 'large-scale' layoffs (Apr 17)
Tech Industry
2d
54377
Goog Employees Arrested
Tech Industry
Yesterday
2010
So hard being a women in tech industry
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.
What was the probability question? If you can’t share, can you please a similar question? What about the ML part?
How random forest works. How to find a biased coin among x unbiased coins.