## 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 Interview Questions

Company Name – Amazon
Location – Bangalore

Number of Rounds –  3
Round 1 – Telephonic Round on Technical Capabilities
Round 2 – SQL, Excel, and Statistics
Round 3 – Project discussion and HR

The Hiring Manager will ask about your technical proficiency in the different tools and technologies. Once you met the requirement of their team then you will be asked further questions.
My proficiency was in

SQL – 8/10
Tableau – 8/10
Python – 9/10
Statistics – 8/10

I was asked questions mainly on SQL, which included that of Joins, Group By, etc.
Following are the few questions:-

1. What is the difference between HAVING and WHERE condition?
2. How to calculate Mode, Median, and Mean from a given number?
3. What is the relation between Mean, mode, and median in a normal distribution?
4. What percentage of value lies between Mean and one Standard deviation(both positive and negative)
5. Give the relation of Mean, median, and mode in a positively skewed distribution

6. Negatively skewed distribution?
7. What is sum of squared deviation?
8. Why do we need to square the terms?
9. What is the order of execution of a SQL query?
10.How to find Third highest salary in Employee table using self-join?
11.Why data cleaning plays a vital role in analysis?
12. Classification vs regression?

13. What are the predictor and target variable?
14. How does knn works?

Other than these, there were simple questions on the use of Order by, Between, Like commands

Round 2 – SQL, Excel, and Statistics

1. What is the difference among COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel?
2. What is the order of sequence of operating mathematical operation in Excel?
3. What is the syntax of Vlookup? How does VLookup works?
4. What is the difference between heap table and temporary table?
5. What is the usage of regular expressions in MySQL?
6. What is the difference between primary key and candidate key?
7. What are the absolute measures of dispersion?

8. What are the measures of spread?
9. What is the use of Kurtosis?
10. What are Leptokurtic and Platykurtic?

You can find the SQL questions here

You can find Statistics Interview Questions here

Round 3 – Project Discussion and HR

The last round was a mixture of Project Discussion and HR

My project was on analyzing the performance of store and product for a leading Multinational Retailer. The performance of a few category of clothes were below par and some stores were not performing good with respect to revenue. We were analyzing the worst performing product and stores.

There were few products which were not performing well in some of the stores, whereas these were performing good in other stores.

Few questions asked in the interview were?
1. What is shelf-life?
2. What is supply chain analytics?
3. Project Description

4. What was the final recommendation?
5. Suppose you were the owner of the company, will you directly shut these stores and products? Is it fair?

6. What is footfall?
7. If you have to recommend a product to a customer who has already filled his cart, then what data will you look for? Basically, how will you recommend a product to an e-commerce customer?

This was it 🙂

Sapient Interview Questions

Full interview question of these round is present in our book What do they ask in Top Data Science Interview Part 2: Amazon, Accenture, Sapient, Deloitte, and BookMyShow

You can get your hand on our ebooks