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 Business Analyst Intern Interview Questions and Answers

Updated 15 Jan 2025

Amazon Business Analyst Intern Interview Experiences

5 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Aug 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

It consisted of logical reasoning, SQL snippet questions Excel data modelling quant questions ,data warehouse and cloud computing questions

Round 3 - Technical 

(2 Questions)

  • Q1. It was a technical interview round
  • Q2. There were questions on my projects technical grinding related case study sort of questions ont he project
Round 4 - One-on-one 

(2 Questions)

  • Q1. It was an hr plus technical interview round consisting of puzzles questions on SQL based on a particular scenario and the generic hr round questions
  • Q2. SQL code , why I want to join amazon and such questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Online assessment 

(1 Question)

  • Q1. It was from ETL, Cloud computing, SQL, pseudo codes, cognitive ability, attention to detail.
Round 2 - Coding Test 

SQL Joins, Python functions

Round 3 - HR 

(1 Question)

  • Q1. Behavioural questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Take equal preparation for behavioural round too like how you do for technical. I missed the chance there.

Business Analyst Intern Interview Questions Asked at Other Companies

Q1. What are all the documents prepared by a BA? Brief them.
asked in BACentric
Q2. What is the role of business analyst?
asked in BACentric
Q3. What is business analysis ?
asked in IBM
Q4. Tell me about a time you had to do a data analysis
asked in BACentric
Q5. Who is the business analyst?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL and excel questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Leadership principles based questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Leadership principles based QA
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Excel case study (basic functions like sumifs , countifs) along with SQL questions level : Basic to intermediate
Round 2 - One-on-one 

(1 Question)

  • Q1. All leadership principle based questions , two rounds 30 min each

Interview Preparation Tips

Topics to prepare for Amazon Business Analyst Intern interview:
  • Excel
  • SQL
Interview preparation tips for other job seekers - Understand the leadership principles thoroughly

Amazon interview questions for designations

 Business Analyst

 (50)

 Data Analyst Intern

 (1)

 Senior Business Analyst

 (3)

 Business Intelligence Analyst

 (2)

 Business Operations Analyst

 (1)

 Business Support Analyst

 (1)

 Business Development Analyst

 (1)

 Business Research Analyst

 (1)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. How do you fit the role

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference Between Rank and Dense Rank
  • Ans. 

    Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.

    • Rank does not skip ranks when there are ties, while Dense Rank does

    • Rank will have gaps in ranks if there are ties, while Dense Rank will not

    • Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row

  • Answered by AI
  • Q2. Some Basic Joins
  • Q3. Socks Pair Puzzle Qustions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare BASIC SQL and some puzzles questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What you have technical improvement in codes?
  • Ans. 

    I have implemented various technical improvements in codes to enhance performance and functionality.

    • Implemented caching mechanisms to reduce load times

    • Optimized database queries for faster retrieval of data

    • Introduced error handling techniques to improve code reliability

    • Utilized design patterns to make the codebase more maintainable

    • Refactored legacy code to adhere to best practices

  • Answered by AI
  • Q2. What is your excitment about fresh job?

Interview Preparation Tips

Interview preparation tips for other job seekers - every time doing work well
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Oct 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Python, SQL, Quant, Statistics, Numpy

Round 3 - One-on-one 

(2 Questions)

  • Q1. SQL, Python, Puzzle total 9Q
  • Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Round 4 - One-on-one 

(1 Question)

  • Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Normal verification
Round 2 - Technical 

(2 Questions)

  • Q1. Questions related to sql
  • Q2. Windows function in sql
  • Ans. 

    The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.

    • The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

    • Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

    • Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Interview with stakeholders

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.

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 - HR 

(1 Question)

  • Q1. They will ask about your profile and past experience.
Round 3 - Technical 

(1 Question)

  • Q1. A peer level colleague will ask some basic knowledge check questions
Round 4 - Coding Test 

This is literally a live coding test. For analytics expect SQL, python, R.

Round 5 - One-on-one 

(1 Question)

  • Q1. Interviewed by a manager of another team
Round 6 - One-on-one 

(1 Question)

  • Q1. Interviewed by dotted line reporting manager
Round 7 - One-on-one 

(1 Question)

  • Q1. Cross functional interview
Round 8 - One-on-one 

(1 Question)

  • Q1. Core Values Interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the core values, remember them, understand them and embody them. And being good at your advertised skills also helps.

Amazon Interview FAQs

How many rounds are there in Amazon Business Analyst Intern interview?
Amazon interview process usually has 2-3 rounds. The most common rounds in the Amazon interview process are One-on-one Round, Technical and HR.
What are the top questions asked in Amazon Business Analyst Intern interview?

Some of the top questions asked at the Amazon Business Analyst Intern interview -

  1. SQL code , why I want to join amazon and such questi...read more
  2. Excel case study (basic functions like sumifs , countifs) along with SQL questi...read more
  3. There were questions on my projects technical grinding related case study sort ...read more

Tell us how to improve this page.

Amazon Business Analyst Intern Interview Process

based on 6 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
Flipkart Interview Questions
4.0
 • 1.4k Interviews
Paytm Interview Questions
3.3
 • 776 Interviews
Tata Group Interview Questions
4.2
 • 358 Interviews
BigBasket Interview Questions
3.9
 • 357 Interviews
Myntra Interview Questions
4.0
 • 216 Interviews
Blinkit Interview Questions
3.7
 • 183 Interviews
Uber Interview Questions
4.2
 • 168 Interviews
AmbitionBox Interview Questions
4.9
 • 153 Interviews
JioMart Interview Questions
3.9
 • 96 Interviews
View all
Amazon Business Analyst Intern Salary
based on 15 salaries
₹4 L/yr - ₹15 L/yr
84% more than the average Business Analyst Intern Salary in India
View more details

Amazon Business Analyst Intern Reviews and Ratings

based on 2 reviews

4.5/5

Rating in categories

4.5

Skill development

3.5

Work-life balance

4.5

Salary

3.5

Job security

5.0

Company culture

4.5

Promotions

4.5

Work satisfaction

Explore 2 Reviews and Ratings
Customer Service Associate
4.2k salaries
unlock blur

₹0.6 L/yr - ₹6.8 L/yr

Transaction Risk Investigator
3.1k salaries
unlock blur

₹2.3 L/yr - ₹6.5 L/yr

Associate
2.8k salaries
unlock blur

₹0.8 L/yr - ₹6.9 L/yr

Senior Associate
2.5k salaries
unlock blur

₹2 L/yr - ₹10.1 L/yr

Program Manager
2.3k salaries
unlock blur

₹9 L/yr - ₹36 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