Amazon Business Intelligence Engineer Questions | Day 4
Amazon Business Intelligence Engineer Questions
Company Name – Amazon
Designation – Business Intelligence Engineer
Salary – 15 to 30 LPA (Depending upon stock options and current CTC)
Number of rounds – 7 (It also depends on the team for which you are getting interviewed)
Level of the interview – Moderate
Amazon Business Intelligence Engineer Questions
In general, the interview process at Amazon is quite different for different teams. We know candidates that have faced 4 technical interviews, a few had 7 rounds of technical interviews and some have 2 technical and 5 rounds around Amazon’s Leadership principles. So, the interview process will depend on the team for which you are getting interviewed.
We have interviewed many candidates that have converted Amazon at BIE I and BIE II positions and below are the top 5 SQL questions that are asked in Amazon as well as in other product-based companies:
In order to check your level of preparation, do try to solve the below 5 questions by yourself and comment your score below
Following is the point charter:-
5 correct – SQL God, You are going to nail 9/10 SQL interviews
4 correct – Really Good, clearing the SQL rounds should not be a problem
3 correct – Ummm..Dicey, you should be able to crack a few rounds
2 correct – You need at least 2-3 weeks before you start applying
1 correct – Padh lo Beta, sochna bhi nai apply krne ka abhi π
0 correct – Try an MBA/MS in Analytics or SBI PO π
Q1. Suppose there is a Movie Theatre with 26 rows(A,B,C..Z) and in each row you have 6 seats. The structure of the table is given below
Date | Row_No | Seat_No | Occupied | Name |
04-Apr-20 | A | A1 | Yes | Kuchi Bhi |
04-Apr-20 | A | A2 | Yes | Kuchi Bhi |
04-Apr-20 | A | A3 | No | |
04-Apr-20 | A | A4 | No | |
04-Apr-20 | A | A5 | No | |
04-Apr-20 | A | A6 | No | |
04-Apr-20 | B | B1 | Yes | Kuchi Bhi |
04-Apr-20 | B | B2 | No | |
04-Apr-20 | B | B3 | No | |
04-Apr-20 | B | B4 | Yes | Kuch Bhi |
04-Apr-20 | B | B5 | No | |
04-Apr-20 | B | B6 | Yes | Kuchi Bhi |
First, let me know all the starting seats where the number of consecutive vacant seats is 2 (B2 here)
Secondly, write a generalized approach to solve for any number of vacant seats. Basically, you need to create a table with two columns,
1. Seat_No
2. Number of consecutive vacant seats
Q2. There are multiple ways to get the 3rd highest salary, write down at least three. This question is important because the moment you tell the interviewer the first way, he/she will ask to solve the same in any other way
Hint –
1. Naive Approach
2. Inner Query
3. Ranking
Q3. I don’t remember any interview which doesn’t have this question
Table A | Table B | |
1 | 1 | |
1 | 1 | |
1 | 1 | |
1 | ||
1 |
There are two tables, the column name in Table A is X and in Table B is Y
How many rows will the resultant have, if you do:-
a. inner join
b. left join
c. right join
d. outer join
e. cross join
Justify your answer
Q4. I own 5 restaurants in Bangalore, following is the table of business, get me the date on which each of these restaurants crossed a total revenue of Rs.10,000
Restaurant | Date | Revenue |
Bangalore Mandrian | 01/04/20 | 5000 |
Bangalore Mandrian | 02/04/20 | 4000 |
Bangalore Mandrian | 03/04/20 | 3000 |
Bangalore Mandrian | 04/04/20 | 6000 |
Boondock Bistro | 01/04/20 | 7000 |
Boondock Bistro | 02/04/20 | 3000 |
Boondock Bistro | 03/04/20 | 5000 |
Oliver’s | 02/04/20 | 11000 |
Oliver’s | 03/04/20 | 8000 |
Oliver’s | 04/04/20 | 9000 |
Whitefield Social | 02/04/20 | 10000 |
Punjabi By Nature | 03/04/20 | 8000 |
Q5. There is a table with employee and manager information, the schema is given below. Write a query to get the EmployeeName and ManagerName.
Id | Employee Name | Manager Id |
1 | Sachin | 3 |
2 | Sehwag | 3 |
3 | Dhoni | |
4 | Kohli | 1 |
5 | Sharma | 1 |
Hint – Consider the edge cases, i.e. your query should cater to the Manager Name of the CEO as well. In the above example, Dhoni is the CEO, so he has no manager id associated with him.
The Data Monk Interview Books β Donβt Miss
Now we are also available on our website where you can directly download the PDF of the topic you are interested in. On Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.
10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning Algorithms β Ideal for 0-3 years experienced candidates
23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case Studies β Complete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)
12 E-books for 12 Machine Learning algorithms with 1000+ interview questions β For those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package
Individual 50+ e-books on separate topics
Important Resources to crack interviews (Mostly Free)
There are a few things that might be very useful for your preparation
The Data Monk Youtube channel β Here you will get only those videos that are asked in interviews with Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics managers, etc.
Go through the watchlist which makes you uncomfortable:-
All the list of 200 videos
Complete Python Playlist for Data Science
Company-wise Data Science Interview Questions β Must Watch
All important Machine Learning Algorithm with code in Python
Complete Python Numpy Playlist
Complete Python Pandas Playlist
SQL Complete Playlist
Case Study and Guesstimates Complete Playlist
Complete Playlist of Statistics
Keep Learning !!
Thanks,