Technical Interview Questions

Google

What steps do you take to train and implement a machine learning model for detecting license plates related to customer pick-up orders in a retail environment? What is the process for deploying the model? How did you choose between on-premise and cloud solutions?

Develop a function that takes structured data, including column names, as input and produces the data in a format suitable for creating a pivot table.

Google

What steps would you take to learn a new technology when beginning with a new program?

Yelp

Two questions about SQL and one question about Python.

Google

What are the key elements that enhance response time and latency for a website?

Capital One

Discuss the time and space complexities associated with sorting algorithms.

Google

What approach would you take to create a system for conducting experiments (such as A/B tests) on an application or website?

Google

How would you create a product akin to Google Docs specifically for collaborative photo editing?

Instacart

[Considering a dataset that contains information about a food delivery service] Construct a SQL query to calculate the total number of rides and deliveries completed for each zip code.

Meta (Facebook)

What would be your approach to introducing reactions on Facebook?