I had a product analyst , data science interview with Google. Several stats questions , sql questions and behavioral questions. I felt it went ok but recruiter just told me they are not recommending I move on to the hiring committee. Was it that bad if I do not make the hiring committee? Can I apply for this same position a year later? Work as a data scientist currently and just was slightly rusty on some sql questions.
It’s bad in the sense they don’t think you have a chance of getting hired based on the interview feedback. You can apply again
Dang makes sense tho. Recruiter was not allowed to share feedback . Pretty sure I messed up the sql interviews. Any way to get the recruiter to share more details for self improvement?
What were the SQL questions
SQL questions should not matter, bad. Not sure how those are related to product analysts pos
Clearly you don’t know what a product analyst at Google does
Any SQL question example
What kind of SQL questions?
Sql questions were mainly similar to what you see on the leetcode website. Probably about a leetcode medium. One question that tripped me up was how to calculate the median for a column of numbers and sql does not have a median function even though it has a mean function. Eventually got it but it wasn't pretty. Other questions tested complex joins, aggregations and filtering. Also know your wildcard operators as that tripped me up on some questions . Also will help to brush up on very simple regex if the interviewer is in a bad mood that day lol
What is the salary and comp offered for 3yrs of experience and L3
Tech Industry
5h
1741
Avoid teams with only Chinese or Indians especially with a Chinese/Indian manager
Tech Industry
4h
646
I wish I were East Asian instead of Vietnamese (Southeast Asian)
Tech Industry
Yesterday
3548
ByteDance is officially fucked
Software Engineering Career
Yesterday
881
Offer comparison: Apple ICT4 vs Meta E4
AMA
Yesterday
2231
I’m a professional coaster AMA
What stats questions did they ask??
Regression, hypothesis testing , maximum likelihood estimation, sampling and some conditional probability question using Bayes theorem