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 Senior Business Analyst interview questions – Updated 2022

Amazon Senior Business Analyst interview questions

Amazon Senior Business Analyst interview questions

Amazon Senior Business Analyst interview questions

Name – Can’t disclose as the person is joining Amazon
Previous Company – Mu Sigma Inc.
Previous Company Designation – Decision Scientist
Work Experience – 3 years 6 months
Tools and Technologies used in Previous Company – SQL, Python, Tableau, AWS

Company Interviewing for – Amazon
Industry – E-commerce
Designation – Senior Business Analyst
Role/Level – Can’t disclose
Location – Bangalore
Interview Year – 2021
Any tips for the aspirants appearing for the company in near future – Work on your SQL skills and go through your resume again and again. Everything will be asked from that
Compensation – 5/5

In total there were 4 rounds:-
-Written SQL
-Technical (SQL and Project)
-Technical and Case Study (Python and Case Study)
– Hiring Manager

P.S. – We have started Mock interview with the candidate who have cleared these interviews. If you want to take a mock interview with Amazon candidate then Fill this form – Mock Interview with Amazon

Round 1 – Written

Topics covered – SQL
Mode of interview – There were 6 people on video call taking the round simultaneously
Duration – 45 mins
Level of Questions – 7/10


There were 4 table schema and 5 questions on SQL. It was mostly around joins, conditions on Date, self join.
There was no IDE to test whether your answer is correct or not.

The questions were not very complex, but you have to understand which all tables to join.

One sample question – Out of all the products if print the product names for which inventory is 2 times the order for March’21. There was inventory, product, order and sales tables given

Round 2 – Technical
Topics covered – SQL, Python and Predictive modeling
Mode of interview – Video Call
Duration – 1 hour
Level of Questions – Difficult (9/10)

In any recruitment process the first technical is the most challenging one as it sets your bar for the next round.
I started with my introduction. I had a couple of projects on Predictive modeling using Regression, ARIMA, LSTM, and ARIMAX.

SQL Questions:-
How do you get the fifth highest salary using self join?
How do you check if a table is in 2NF form or not?
How do you store complex data in a table, by complex he meant a large array?

Then there were some basic questions on group by and joins. Easy ones!!

Python Questions:-
What is the syntax of dictionary and list?
Can you create a large list with random numbers?
How can you sort a string ? I told him about sort function
What is the difference between sort and sorted?
What is the use of Hash Map ?

I did good in these questions so next was on my modeling experience

Explained the project, the questions were not on the technical part of the model but more around what variables were used in Regression and the meaning of these variables.

Be very very clear about your projects, it will occupy 60% of your time

Round 3 – Case Study and Personality Test
Topics covered – Business Case Study and Problem solving
Mode of interview – Video Call
Duration – 1 hour
Level of Questions – Intermediate
(8/10)

Case Study – What are the factors to consider if you work in the sales department of Samsung and you want to start a store in one of the most crowded malls of Bangalore?
There were various things discussed over here, make sure that you have a directional approach. You should not pitch ideas randomly. Structure your ideas.
Above question is attempted by Raahul and his approach is quite good. Show your approach in the answers

Personality Questions –
Tell me one time when you did something wrong in your last organization and how did you do the RCA?
How do you differentiate between whether to pick a project or not in the next project cycle?

Round 4 – Hiring Manager

Topics covered – About role in the previous organization, a brief about the current role
Mode of interview – Video Call
Duration – 30 mins
Level of Questions – NA


It was more about the culture fit. We discussed about one of the projects in my resume. Then there were questions on why I want to join Amazon, what is a normal day in my life looks like. It was a healthy discussion.

The whole process took 1 week, I was offered a position at par with my expected salary.

P.S. – As pointed out by a couple of users about the 12 principle interview being the only way to get into Amazon, it’s not actually true. There are different levels, teams and positions for which recruitment is being done. 12 principle questions are always a part of each round, but we can neither disclose the principles nor those questions.
We reconfirmed to find out that Chime was being used for Video call and SQL test, but the application used for taking the written test should not be a concern 😛
We will try to put generic names for mode of interview.

We have started Mock interview with the candidate who have cleared these interviews. If you want to take a mock interview with Amazon candidate then Fill this form – Mock Interview with Amazon

The Data Monk e-books

Tired of online courses costing 2 to 8 lakh and taking more than a year to complete?
Tired of going through 500+ hours of videos at a super slow pace?
We at The Data Monk believe that you have to start and complete things as quickly as possible. We believe in a target-based study where we break a topic into 100 questions and make sure that if you cover these questions you will surely be able to crack the interview questions. Rest all theory and practical can ONLY be learned while working in an organization.


Pick any of our books from our e-shop page and complete it in 6-8 hours, learn the 100 questions and write it in your resume. We guarantee you that you will nail 8 out of 10 interviews

We also have 3 bundles at a price that is affordable to everyone. We are a group of people placed in best of the product-based companies and we take 100+ interviews per week. Do we know what is being asked and what is not? So, just grab any of the following book bundles and give not more than 30 days to LEARN all the questions. We guarantee you that you will become a very strong candidate in any analytics interview

Set A – [3rd/4th year/ and 0 to 3 years of experience]

Crack any analytics or data science interview with our 1400+ interview questions which focus on multiple domains i.e. SQL, R, Python, Machine Learning, Statistics, and Visualization. – https://thedatamonk.com/product/books-to-crack-analytics-interview/

Set B – [0-5 Years of Experience]

1200+ Interview Questions on all the important Machine Learning algorithms (including complete Python code) Ada Boost, CNN, ANN, Forecasting (ARIMA, SARIMA, ARIMAX), Clustering, LSTM, SVM, Linear Regression, Logistic Regression, Sentiment Analysis, NLP, K-Mean – https://thedatamonk.com/product/machine-learning-interview-questions/

Set C – [0-7 Years of Experience]

2000+ interview questions that include 100 questions each on 12 most asked Machine Learning Algorithms, Python, Numpy and Pandas – 300 Interview Questions, Pandas,PCA,AWS,Data Preprocessing,Case Studies, and many more
https://thedatamonk.com/product/the-data-monk-e-book-bundle/

Note – Set C contains all the questions of Set B

Youtube Channel – The Data Monk

Unlike any other youtube channel, we do not teach basic stuff, we teach only topics that are asked in interviews. If the interviewer asks about p-value, we will have a video on that topic,
If the interviewer is interested in asking the sequence of execution of SQL commands then we will give you an overview of all the commands but stress so much on the question that can answer it comfortably in the interview. We definitely recommend you to follow our youtube channel for any topic that you are interested in or weak at
.

If you wish to get all the study material and topics to cover for an interview at one place, then you can subscribe to our channel. We have covered the complete syllabus of
Get all the youtube videos playlist on our youtube Channel – The Data Monk

Code in Python for Data Science – Understand one algorithm at a time in 30 minutes (theory and python code)
Company-wise Data Science Interview Questions – 15 videos on how to crack analytics interview
Complete Numpy Tutorial – 14 videos on all the functions and questions on Numpy
Complete Python Pandas Tutorial – 15 videos to completely cover Pandas
SQL Complete Playlist – 20 highly recommended videos to cover all the interview questions
Case Study and Guesstimates Complete Playlist –  Real-life interview case study asked in 2021
Statistics– 10 videos to completely cover Statistics for interviews


Lastly,
If you are in dire need of any help, be it book-wise or guidance-wise, then you can definitely connect with me on Linkedin. We will try to help as much as possible



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