Google Business Analyst | April 2020
Position: Business Analyst
Location: San Francisco Bay Area, CA
Outcome: Techncal Screen Rejected
How was the interview process? What was it like?
- For roles like BIE, Google uses a google doc for coding so get used to writing code in a google doc. It would definitely help.
- I definitely feel I could have done better.
- Out of 45 mins, 20 mins were spent in talking about the role which left less than 7mins for the Python problem. If we had solved the tech questions first and then had the conversation, it would have been better.
What technical questions were asked?
SQL / Pandas, Python Scripting
What was one of your solutions?
I don't remember the database schema I wrote and the SQL query is based on that. I do remember I had a left join and a group by and order by.
For the Python problem, I couldn't solve it in the given time.