I applied through an employee referral. The process took 4 weeks. I interviewed at Amazon (Austin, TX) in Nov 2023
Interview
1st round - Online Assessment containing behavioral and situation based questions.
2nd round - Technical Interview with Senior Business Analyst
Interview Loop - 5 rounds of interview
1 - Detailed Technical interview with Senior Manager
2- Leadership Principles with Senior Manager
3- Leadership Principles with VP
4- Detailed Technical interview with Hiring Manager
5- Leadership Principles with Head
Interview questions [1]
Question 1
SQL basic concepts - Primary/ Foreign Key, Joins, Union/Union All,
SQL queries- JOIN 2-3 tables, Aggregation, Sub queries, Window functions, CTEs (Leetcode- Easy and Medium)
Statistical concepts, Business metrics used in the previous projects, KPIs build in analyzing overall data, strategies and tools used to compare products, Situation based questions to improve efficiency and reduce query run time.
Leadership questions - Customer obsession and Dive deep
Invent and Simplify, Ownership
Learn and Be Curious, Highest standards
I applied through an employee referral. I interviewed at Amazon (Austin, TX)
Interview
The process consisted of a technical and behavioral round. Although the recruiter stated it would cover SQL and behavioral topics, the interview focused entirely on scenario-based and behavioral questions without a live SQL technical assessment. Communication after the interview was poor; the recruiter did not respond to follow-up emails, and an automated rejection notice was sent two days later.
Interview questions [1]
Question 1
They asked me to describe a mistake I made in a past project, how I handled it and what I learned from the experience.
I applied online. I interviewed at Amazon (Hyderābād)
Interview
Easy.
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc. They also ask about projects you have worked on.
Interview questions [1]
Question 1
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc.
The interview process includes a SQL test, an initial recruiter call, and a final five-round loop featuring technical questions and discussions focused on Amazon leadership principles with different team members.
Interview questions [1]
Question 1
They asked a key question focused on both technical depth and culture fit: how you apply your skills to solve real problems, along with examples demonstrating alignment with Amazon’s leadership principles.