Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Amazon Team. If you also belong to the team, you can get access from here

Amazon Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Amazon Analyst Interview Questions and Answers for Experienced

Updated 30 Sep 2024

Amazon Analyst Interview Experiences for Experienced

4 interviews found

Analyst Interview Questions & Answers

user image Devesh Tiwari

posted on 22 May 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

General assesment, grammar, vocabulary

Round 2 - Technical 

(2 Questions)

  • Q1. SQL and Python basic level
  • Q2. Sql problems regarding joins and window function
  • Ans. 

    Understanding SQL problems related to joins and window functions

    • Ensure you understand the different types of joins (inner, outer, left, right)

    • Know how to use window functions like ROW_NUMBER(), RANK(), and PARTITION BY

    • Practice writing queries that involve multiple tables and window functions

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Normal questions

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and expressive

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Anonymous

posted on 30 Jun 2023

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. What are shortterm liabilities.
  • Ans. 

    Short-term liabilities are debts or obligations that are due within one year.

    • Short-term loans

    • Accounts payable

    • Accrued expenses

    • Short-term portion of long-term debt

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Analyst Interview Questions Asked at Other Companies for undefined

asked in Capgemini
Q1. 1) What are the types of master data in SAP MM? 2) What is T-code ... read more
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
Q3. Digits Decoding Problem Ninja has a string of characters from 'A' ... read more
Q4. Subarray With Given Sum Problem Statement Given an array ARR of N ... read more
Q5. Group Anagrams Together Given an array/list of strings STR_LIST, ... read more

Analyst Interview Questions & Answers

user image Anonymous

posted on 5 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I was interviewed before Apr 2023.

Round 1 - Coding Test 

Coding round for analysing programming capabilities and skills.

Round 2 - Technical 

(1 Question)

  • Q1. Technical round comprise of SQL, Database and Analytics related scenario based questions.

Analyst Interview Questions & Answers

user image Anonymous

posted on 9 Jun 2021

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Pivot and excel questions
  • Q2. All about excel

Interview Preparation Tips

Interview preparation tips for other job seekers - It was very simple self intro and excel questions and basic macro

Amazon interview questions for designations

 Business Analyst

 (50)

 Quality Analyst

 (26)

 Data Analyst

 (23)

 Risk Analyst

 (8)

 Research Analyst

 (3)

 Senior Analyst

 (3)

 Production Analyst

 (2)

 Support Analyst

 (1)

Analyst Jobs at Amazon

View all

Interview questions from similar companies

I was interviewed before Apr 2021.

Round 1 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

In the interview I was asked few puzzles and few coding problems.
In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms.

  • Q1. 

    Count Set Bits Problem Statement

    Given a positive integer N, find the total number of '1's in the binary representation of all the numbers from 1 to N.

    You should return the result modulo 109+7 as the co...

  • Ans. 

    Count the total number of set bits in the binary representation of numbers from 1 to N, modulo 10^9+7.

    • Iterate through numbers from 1 to N and count the set bits in their binary representation

    • Use bitwise operations to count set bits efficiently

    • Return the total count modulo 10^9+7 as the result

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 45 minutes
Round difficulty - Easy

In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest. 
I was asked some puzzles as well.

  • Q1. 

    Merge Two Sorted Arrays Problem Statement

    Given two sorted integer arrays ARR1 and ARR2 of size M and N, respectively, merge them into ARR1 as one sorted array. Assume that ARR1 has a size of M + N to hol...

  • Ans. 

    Merge two sorted arrays into one sorted array in place.

    • Iterate from the end of both arrays and compare elements to merge in place

    • Use two pointers to keep track of the current position in both arrays

    • Handle cases where one array is fully merged before the other

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPASnapdeal interview preparation:Topics to prepare for the interview - SQL, Database, Aptitude, Data Structures, Algorithms, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewRejected

Skills evaluated in this interview

Interview Preparation Tips

Round: Resume Shortlist
Experience: I had a standard resume for this company as per our institute placement cell norms.

I prepared resume keeping in mind the areas of interest that would suit the company’s requirements. The companies that recruit students from all departments usually tend to recruit students seeking interests in subjects related to management. I knew about this and while applying to non-core companies I specified my areas of interest as these subjects.

Round: Test
Experience: The first round was the written test. The paper was composed of general aptitude and basic programming questions. For programming questions we were told that in case we did not know the desired syntaxes we could write the algorithm for the problems. Since I was not a proficient coder I preferred writing only the algorithm for the coding questions. There were also some logical reasoning questions (mainly puzzle types). For example in one of the questions we were given a multi coloured cube with each side having a different colour. Initially the cube was kept with the blue colour appearing on the top surface; then the cube was rotated along various axes, we had to specify which colour would appear on the top surface. I qualified the first round.

Round: HR Interview
Experience: The second round was an aptitude interview round. In this interview I was asked about the preference with respect to the profiles ordered (programming or analytics). I replied that I would like to join the company as an analyst, however if given an option I would be open to learning programming as well. The interviewers were delighted to know about my interests in learning newer things.

The interview further asked me puzzle based logical reasoning questions like ‘How to find the odd coin out of 8 coins of which 7 are similar in all senses in two weighing steps by use of a balance?’ He asked me few more of these types; I successfully managed to answer all these questions.

Round: HR Interview
Experience: The final round was again a personal interview. This was actually supposed to be a profile specific interview; however since I had earlier said that I was open to getting recruited in both the profiles they asked me questions from programming as well as analytical questions. I informed them again that I was interested in learning programming but did not have much clue about it at that time. They did not pay any heed whatsoever to my plea and kept asking me questions related to programming. They asked me some questions and told me to suggest some algorithm for those questions since I did not know coding. I framed some algorithms but they did not seem very convinced with my answers. Eventually I was not recruited.
Tips: As per my experience I would say that knowledge about C++ is necessary to get into the software section of Snapdeal. They want people who are well versed with puzzle solving questions and who can solve analytical questions easily.

College Name: IIT ROORKEE
Motivation: I got to know about the company and the profile through the pre-placement talk by the company. The company is one of the leading e-commerce website today and is quite famous among the youth. Hence I had knowledge about its existence and field of work beforehand.

Interview Questionnaire 

5 Questions

  • Q1. Why Snapdeal. Why reject Flipkart PPO
  • Ans. 

    I chose Snapdeal over Flipkart because of its unique business model and growth potential.

    • Snapdeal offers a unique marketplace model that allows sellers to directly connect with customers, giving them more control over their business.

    • Snapdeal has shown consistent growth and has a strong presence in tier 2 and tier 3 cities, which presents a huge untapped market.

    • Snapdeal's focus on customer satisfaction and providing a p...

  • Answered by AI
  • Q2. Short term & Long term aims in Life
  • Ans. 

    Short term aim is to excel in my role as a business analyst and contribute to the success of the company. Long term aim is to become a senior business analyst and eventually a business consultant.

    • Short term aim: Excel in my role as a business analyst

    • Short term aim: Contribute to the success of the company

    • Long term aim: Become a senior business analyst

    • Long term aim: Transition into a business consultant role

  • Answered by AI
  • Q3. What are you seeking from this Job
  • Q4. Number of sparrows in IIT KGP
  • Ans. 

    The number of sparrows in IIT KGP is unknown.

    • The exact number of sparrows in IIT KGP is not available.

    • There is no specific data on the population of sparrows in IIT KGP.

    • The number of sparrows in IIT KGP is not documented.

    • No information is available regarding the count of sparrows in IIT KGP.

  • Answered by AI
  • Q5. Road length of Ahmedabad
  • Ans. 

    The road length of Ahmedabad is approximately 2,500 kilometers.

    • Ahmedabad has a well-developed road network.

    • The road length includes both national highways and city roads.

    • The road length is constantly expanding due to urban development and infrastructure projects.

    • Major roads in Ahmedabad include the SG Highway, Ashram Road, and C.G. Road.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Simple questions. Accuracy and speed were determining factors.
Tips: Practice Quant/Give online Quant & LR tests.
Duration: 12 minutes
Total Questions: 50

Round: Resume Shortlist
Experience: CV Should carry proper format, action verbs . Impacts created (preferably numerical ) should be exclusively mentioned for each project under internships.
Tips: An E-Commerce internship background are an add-on. SQL , Google analytics , R Software knowledge are an advantage.

Round: Group Activity
Experience: Topic for GD : Impact of Coal-Gate scam on Indian economy.
Tips: Be updated about current affairs. Subscribe economic times or business standard. Don't create a fish market in the GD. put your points clearly and conclude what the entire group has agreed with

Round: Guesstimate Interview
Experience: Was able to do them. Prior consulting internships helped.
Tips: Practice Case in point. Have a well structured and calculative approach.

Round: HR Interview
Experience: Normal HR type questions. They see your attitude towards life and your work style.
Tips: Prepare well for them. These questions are not new or different for any interview,

College Name: IIT KHARAGPUR

Interview Questionnaire 

2 Questions

  • Q1. What are tree traversals?
  • Ans. 

    Tree traversals are methods of visiting all nodes in a tree data structure.

    • There are three types of tree traversals: in-order, pre-order, and post-order.

    • In-order traversal visits the left subtree, then the root, then the right subtree.

    • Pre-order traversal visits the root, then the left subtree, then the right subtree.

    • Post-order traversal visits the left subtree, then the right subtree, then the root.

    • Tree traversals are ...

  • Answered by AI
  • Q2. What is pre-order and post-order?
  • Ans. 

    Pre-order and post-order are traversal methods used in binary trees.

    • Pre-order: visit root, left subtree, right subtree

    • Post-order: visit left subtree, right subtree, root

    • Used to traverse binary trees and perform operations on nodes

    • Example: Pre-order traversal of binary tree: A, B, D, E, C, F, G

    • Example: Post-order traversal of binary tree: D, E, B, F, G, C, A

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: I consulted my seniors for preparation of my resume. I believe that seniors provide the best provide you with the best possible insights in this regards.

Round: Test
Experience: The first round was the written test. There were 8 theoretical questions asked in the paper. The questions were either in the form of puzzles or probability based questions. The first three questions in the paper were compulsory questions and needed to be answered correctly for the rest of your paper to be evaluated; if a particular candidate answered any one of these questions incorrectly then he was rejected then and there. Apart from these 3 questions solving 2 more questions would have assured a candidate’s chance of getting selected for the next round. The duration of the test was of around 40 minutes.
For the written test nearly 300 people appeared out of which 30-40 were shortlisted for the interviews.

Round: Puzzle Interview
Experience: In the interview I was asked few puzzles and few coding problems.

Some puzzles asked were:

1) There are 3 couples (each couple consists of a man and a woman: husband and wife pair) who want to cross a particular river with only one boat available for the voyage. At a time the boat can carry a maximum of 2 people and a woman cannot stay in presence of other male in absence of her husband. All three couples want to cross the river, what are the ways in which this could be done?
2) There are 2 ropes which burn in 60 minutes. How to measure 45 minutes without cutting any of the ropes?

In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms. In one of the questions they gave me a binary number and asked me to write down the algorithm to calculate the number of one’s in the binary number.

Round: Technical Interview
Experience: In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest. Some of the questions asked were:
If you have an array of ‘n+m’ elements and have these ‘n’ elements separately and you have to transfer these n elements in the n+m element slot which already contains the m elements. The transfer has to be done in such a way that all the m+n elements are sorted.
I was asked some puzzles as well. For instance in one of the puzzles, I was given a square consisting of 9 dots on its periphery. I was asked to join those 9 dots using 4 lines without lifting the pencil.

College Name: IIT ROORKEE

Skills evaluated in this interview

Business Analyst Interview Questions & Answers

Paytm user image Rockey Maheshwari

posted on 8 Sep 2015

Interview Preparation Tips

Round: Test
Experience: It was a test of moderate level.

20 ques in 20 min.

Basic focus was speed and accuracy.

Tested calculation speed.
Tips: Try to decide which ques to answer and which ones to leave.

Its very important not to get stuck in any 1 ques and waste time. MOVE ON!
Duration: 20 minutes
Total Questions: 20

Round: Technical Interview
Experience: Hi ! i dont remember the question but I do remember that they were easy.

The interviewers are there to test you not to embarrass you. or humiliate you.
They dont expect you to answer every ques so no need to get frustrated if you get a couple of them wrong.
Tips: Go easy...
If you dont know answer to a ques , dont panic,. They are willing to qive you points for your approach.

General Tips: Relax at all times
Skill Tips: Just practice. Whenever you are on facebook solve a couple of brain teasers.


Skills: Aptitude
College Name: DTU
Motivation: Good Future prospects!

I applied via Referral and was interviewed before May 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. It is relevant to area where you are expertises and for position you applied for
  • Q2. Relevant to position

Interview Preparation Tips

Interview preparation tips for other job seekers - Really good company and can enjoy myntra benefits a lot .

Amazon Interview FAQs

How many rounds are there in Amazon Analyst interview for experienced candidates?
Amazon interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the Amazon interview process for experienced candidates are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Amazon Analyst interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Amazon. The most common topics and skills that interviewers at Amazon expect are SQL, Accounts Receivable, Analytical Chemistry, Business Analysis and Cash Applications.
What are the top questions asked in Amazon Analyst interview for experienced candidates?

Some of the top questions asked at the Amazon Analyst interview for experienced candidates -

  1. sql problems regarding joins and window funct...read more
  2. What are shortterm liabiliti...read more
  3. tell me the difference between having and group by ...read more

Tell us how to improve this page.

Amazon Analyst Interview Process for Experienced

based on 3 interviews

Interview experience

3
  
Average
View more

Analyst Interview Questions from Similar Companies

Myntra Analyst Interview Questions
4.0
 • 2 Interviews
Uber Analyst Interview Questions
4.2
 • 1 Interview
View all
Amazon Analyst Salary
based on 339 salaries
₹1.6 L/yr - ₹9.9 L/yr
26% less than the average Analyst Salary in India
View more details

Amazon Analyst Reviews and Ratings

based on 41 reviews

3.8/5

Rating in categories

3.6

Skill development

3.8

Work-life balance

3.6

Salary

3.8

Job security

3.7

Company culture

3.8

Promotions

3.6

Work satisfaction

Explore 41 Reviews and Ratings
ROC Central Strategy, WFM Real-time Analyst

Hyderabad / Secunderabad

2-5 Yrs

₹ 2.3-9.54 LPA

Analyst, AWS Monetization, Customer Success

Hyderabad / Secunderabad

2-6 Yrs

₹ 2.3-10 LPA

Risk Mining Analyst, Buyer Abuse Prevention Machine Learning

Bangalore / Bengaluru

3-7 Yrs

Not Disclosed

Explore more jobs
Customer Service Associate
4.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Transaction Risk Investigator
3.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
2.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
2.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Program Manager
2.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Amazon with

Flipkart

4.0
Compare

TCS

3.7
Compare

Google

4.4
Compare

Netflix

4.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview