Amazon – Business Analyst Interview Experience

Position/Role:

• Experience: Business Analyst

Where Applied:

• Company: Amazon
• Application Method: Referral

Total Rounds:

1. Scenario-based Questions
2. Technical Interview
3. Leadership and Situational Questions
4. HR Interview

Every Round Experience:

1. Scenario-based Questions:

• Format: Problem-Solving Interview
• Questions:
  • Scenario: Analyze sales data to calculate the total sales value difference month-on-month.
  • Graphs for Marketing Strategies: Compare and analyze email marketing strategies, focusing on performance metrics like click-through rates among different buyer segments.

2. Technical Interview:

• Format: Technical Skills Assessment
• Questions:
  • SQL:
    • Write queries to find the highest-priced product in each country and calculate the total transaction amount for each customer for the current year.
  • Python:
    • Perform basic pandas operations like groupby, loc/iloc, and merging datasets.

3. Leadership and Situational Questions:

• Format: Leadership Principles Assessment
• Questions:
  • Describe a situation where you supported a decision you disagreed with.
  • Share an instance where you rebuilt trust with a colleague or client.
  • Provide an example of finding an innovative solution to a complex problem.
• Excel:
  • Questions on formulas, pivot tables, conditional formatting, data validation, and charts.

4. HR Interview:

• Format: HR Interview
• Questions:
  • Why Amazon?
  • Discussion on Leadership Principles
  • Salary Negotiation
  • Discussion on Projects

Final Verdict:

• Result: Selected