amazon logo
Amazon· Business Analyst

Amazon, Business Analyst Interview Experience

Result
Offer
Posted
2 Feb 2022
271 reads

Summary

I successfully interviewed for a Business Analyst role at Amazon and received an offer. The technical assessments, particularly the SQL live coding, were manageable, and I found specific prep guides very helpful.

How it went

My interview process consisted of two phone interviews followed by a final round. The first phone interview was a 60-minute session, structured as: 10 minutes for an introduction, 15 minutes on Amazon's Leadership Principles, 25 minutes for a live SQL coding exercise, and 10 minutes for my questions. The interviewer also inquired if I'd like to attempt Python questions. The second phone interview was entirely focused on Amazon's Leadership Principles. The final round involved four interviewers, including two Senior Business Analysts, one Data Scientist, and one hiring manager. This round primarily focused on Leadership Principles and behavioral questions.

Questions asked (3)

  1. 01

    Count of Employees

    Data Structures & Algorithms

    Given the employee table, provide a query to count the total number of distinct employees.

    Table: employee
    +-------------+---------+
    | Column Name | Type    |
    +-------------+---------+
    | employee_id | int     |
    | first_name  | var     |
    | last_name   | var     |
    | manager_id  | int     |
    | salary      | int     |
    | department  | var     |
    | start_date  | date    |
    | building_id | int     |
    +-------------+---------+
  2. 02

    Average Salary by Department

    Data Structures & Algorithms

    Given the employee table, write a query to calculate the average salary for each department.

    Table: employee
    +-------------+---------+
    | Column Name | Type    |
    +-------------+---------+
    | employee_id | int     |
    | first_name  | var     |
    | last_name   | var     |
    | manager_id  | int     |
    | salary      | int     |
    | department  | var     |
    | start_date  | date    |
    | building_id | int     |
    +-------------+---------+
  3. 03

    Buildings Without Employees

    Data Structures & Algorithms

    Given the employee and building tables, find the names and IDs of buildings that currently have no employees assigned to them.

    Table: employee
    +-------------+---------+
    | Column Name | Type    |
    +-------------+---------+
    | employee_id | int     |
    | first_name  | var     |
    | last_name   | var     |
    | manager_id  | int     |
    | salary      | int     |
    | department  | var     |
    | start_date  | date    |
    | building_id | int     |
    +-------------+---------+
    

    Table: building +--------------+---------+ | Column Name | Type | +--------------+---------+ | building_id | int | | building_name| int | +--------------+---------+

How they prepared

To prepare, I utilized Amazon SQL questions found on LeetCode and also purchased a specific Amazon SQL prep guide from FAANGTutors.com, which proved extremely helpful for the technical assessments.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Amazon recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!