G-P
Practice questions for the skills this job lists, plus common questions for any interview. These are for practice: we don’t know the employer’s actual questions.
What is the difference between a list and a tuple, and when would you use each?
Python
How do generators work, and why would you use one over a list?
Python
Write a query for the second-highest salary in each department.
SQL
Explain the difference between INNER, LEFT and FULL joins with an example.
SQL
Design a simple, highly available web app on AWS. Which services and why?
AWS
What's the difference between an IAM role and an IAM user?
AWS
How would you deploy and scale a web API on Azure?
Azure
Compare Cloud Run, GKE and App Engine for a new service.
Google Cloud
A key metric dropped 20% yesterday. How do you investigate?
Data analysis
How would you design an A/B test for a new feature, and how long would you run it?
Data analysis
Tell me about a dataset you cleaned. What problems did you find?
This kind of role
How would you explain a model's result to a non-technical manager?
This kind of role
What do you know about G-P's products and customers?
G-P
Tell me about yourself in two minutes, focused on this role.
About you
Why this company, and why this role?
About you
Tell me about a time you disagreed with a teammate. What happened?
About you
Describe a time you failed or missed a deadline, and what you changed afterwards.
About you