Amazon, Business Analyst Interview Experience
- Result
- Offer
- Posted
- 2 Feb 2022
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)
- 01
Count of Employees
Data Structures & Algorithms
Given the
employeetable, 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 | +-------------+---------+ - 02
Average Salary by Department
Data Structures & Algorithms
Given the
employeetable, 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 | +-------------+---------+ - 03
Buildings Without Employees
Data Structures & Algorithms
Given the
employeeandbuildingtables, 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.