Amazon, Business Analyst Interview Experience
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.
Full Experience
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.
Interview Questions (3)
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 |
+-------------+---------+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 |
+-------------+---------+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 | +--------------+---------+
Preparation Tips
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.