Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

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

Amazon Business Intelligence Engineer Questions
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

DateRow_NoSeat_NoOccupiedName
04-Apr-20AA1YesKuchi Bhi
04-Apr-20AA2YesKuchi Bhi
04-Apr-20AA3No
04-Apr-20AA4No
04-Apr-20AA5No
04-Apr-20AA6No
04-Apr-20BB1YesKuchi Bhi
04-Apr-20BB2No
04-Apr-20BB3No
04-Apr-20BB4YesKuch Bhi
04-Apr-20BB5No
04-Apr-20BB6YesKuchi Bhi
Table Name – PVR

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 ATable B
11
11
11
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

RestaurantDateRevenue
Bangalore Mandrian01/04/205000
Bangalore Mandrian02/04/204000
Bangalore Mandrian03/04/203000
Bangalore Mandrian04/04/206000
Boondock Bistro01/04/207000
Boondock Bistro02/04/203000
Boondock Bistro03/04/205000
Oliver’s02/04/2011000
Oliver’s03/04/208000
Oliver’s04/04/209000
Whitefield Social02/04/2010000
Punjabi By Nature03/04/208000

Q5. There is a table with employee and manager information, the schema is given below. Write a query to get the EmployeeName and ManagerName.

IdEmployee NameManager Id
1Sachin3
2Sehwag3
3Dhoni
4Kohli1
5Sharma1

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,

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me