Amazon.com Business Analyst Intern Interview Questions

Updated May 29, 2014
Updated May 29, 2014
1 Interview Review

Interview Experience

Interview Experience

0%
100%
0%

Getting an Interview

Getting an Interview

100%

Interview Difficulty

3.0
Average

Interview Difficulty

Hard

Average

Easy

1 Candidate Interview Review Back to all interviews

Sort: Popular Date Difficulty

5 people found this helpful  

Business Analyst Intern Interview

Anonymous Interview Candidate  in  Seattle, WA
Anonymous Interview Candidate in Seattle, WA
Application Details

I applied online. The process took 2 weeks - interviewed at Amazon.com in May 2014.

Interview Details

Applied on Amazon.com/careers, recieved an invitation for a 45 minute phone interview 5 days later.

First Interview: Interviewed with an Amazon employee, walked through the resume and asked 1-2 behavioral question, 3-4 SQL questions then drilled into business case questions. The interview lasted ~25 minutes.

Final round interview consists of 2 back-back 45 minutes phone interviews and a writing exercise.

Interview Questions
  • 1. If your results came out to be 100% contradictory to your hypothesis what would you do?
    2. Do you think amazon should place a cap on the number of products a seller can sell? Why or why not?
    3. If you have to think of a product that would be profitable to amazon, what would it be and how would you data mine the result?
    4. If amazon places a cap on the sellers and sellers can only sell 100 products instead of 150, if you were the seller, how would you determine which products to keep? And how would you data mine it?
    5. How good are you at Excel and SQL from a scale of 1 to 5, with 1 being the best?
    6. What is your biggest accomplishment and how did you measure your success?

    SQL questions:
    1. What is the difference between HAVING and WHERE?
    2. What are the SQL clauses, in the right order?
    3. Questions about different types of JOIN
      Answer Question
No Offer
Neutral Experience
Average Interview

Worked for Amazon.com? Contribute to the Community!

The difficulty rating is the average interview difficulty rating across all interview candidates.

The interview experience is the percentage of all interview candidates that said their interview experience was positive, neutral, or negative.

Your response will be removed from the review – this cannot be undone.