Amazon Associate Data Scientist Interview Questions and Answers

• Q1. Describe your project
  View Answers (1)

• Q1. Coding and data structure
  Add Answer

• Q1. ML Breadth and depth
  Add Answer

• Q1. Explain past projects
  Add Answer

• Q1. Explain resume points
  View Answers (1)

SQL - shared question on the screen and asked to code in SQL

• Q1. Nth highes salary
  Add Answer

Live SQL Coding and Product sense questions. You can practice SQL using Stratascratch or Hackerrank. For product sense, refer to dataandmetrics.com or interviewquery.

Stats, ML and product questions.

• Q1. Past experience and product case.
  Add Answer

Generally 90 min coding test with 3 SQL questions

• Q1. Advanced SQL - basic stats
  Add Answer

• Q1. SQL + Statistics
  Add Answer

• Q1. Python + SQL + Stats
  Add Answer

• Q1. Advanced Statistics
  Add Answer

Round duration - 60 minutes
Round difficulty - Easy

Timing: 8:00-9:00 PM
There was 1 MCQ and 3 SQL queries. The platform was easy to use and navigate.

• Q1. SQL Question A table containing the details of all the drivers, and another table containing the details of trips is provided. Query the name of drivers that ha...read more
  View Answers (2)
• Q2. SQL Question A table containing the details of all the drivers, and another table containing the details of trips is provided. Query the name and number of trip...read more
  View Answers (1)
• Q3. SQL Question A table containing the details of Uber employees were provided. I had to query the maximum number of employees that worked in the company during ea...read more
  View Answers (1)

Round duration - 30 minutes
Round difficulty - Medium

Timing: 11 AM-11:30 AM
The interviewer was very kind and helpful. He helped me by giving hints whenever I was stuck.

• Q1. SQL Question User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city...read more
  View Answers (1)
• Q2. SQL Question User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city...read more
  View Answers (1)
• Q3. SQL Question User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city...read more
  View Answers (1)

Round duration - 30 minutes
Round difficulty - Medium

Timing: 12:15 PM to 12:45 PM.
The interviewer was very helpful and friendly. He was more interested in my approach rather than the final answer.

• Q1. Puzzle Question In a bank, suppose there are 5 counters. Which approach mentioned below is better? 1) The new customer goes to whichever counter has a smaller q...read more
  View Answers (1)
• Q2. Puzzle Question

  What new feature would you like to add in Uber?

  View Answers (1)

Round duration - 30 minutes
Round difficulty - Hard

Timing: 3:00PM to 3:30PM
This was Hiring Manager round. He asked me case study type of questions.

• Q1. Puzzle Question

  How would you predict which user is likely to churn in the next 1 month? What variables would you consider for this?

  View Answers (1)