I applied through a recruiter. The process took 6 weeks. I interviewed at Amazon (Bengaluru) in May 2017
Interview
I faced 7 rounds of interviews .
1) SQL and Hadoop basics screening - Telephonic - Advance SQL questions
2) Hive and Spark optimizations - Telephonic
after this I was called for onsite interviews to Bangalore .
3) Data modeling and case study . in person round
4) hive and spark advance fundamentals - in person round
5) Hiring manager round - Customer obsession and Ambiguity handling . Eg: explain a situation where you applied above characteristics.
6) Bar Raiser - advance RDMS , SQL , ETL , DWH concepts, data modeling case study .
after this I was back , they confirmed that all rounds where positive and now they will schedule a round with the director
7) Round with Director - Around amazon leadership principles .
Interview questions [1]
Question 1
how would you design a Real time analytics solution to track sales and revenue ?
I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Chicago, IL) in June 2025
Interview
Amazon interviews consist of two types of questions:
1) Behavioral Questions based on the Amazon Leadership Principles (LPs)
2) Technical and Functional Questions based on the qualifications of the job.
Interview questions [1]
Question 1
You are given a list of dictionaries, where each dictionary represents a product with keys 'product_id', 'product_name', and 'price'.
I applied online. The process took 4 weeks. I interviewed at Amazon in Nov 2024
Interview
The recruiter set up the first round phone screening, and it took us three weeks to finally find a time. Though the interviewer didn't show up during the scheduled time, and the recruiter kept ghosting me without any updates. It looks like the position has been filled, but they gave no respect on the candidates who are still in the interview process. It's the worst interview experience I've ever had.
Interview questions [1]
Question 1
Just had the recruiter round, some questions on the backgrounds and experience.
I applied through an employee referral. The process took 2 months. I interviewed at Amazon (Seattle, WA) in Mar 2024
Interview
1 hour * 1 round of technical screening, behaviour questions & SQL questions asked
1 hour * 5 rounds loop interviews, a lot of behavior questions each round, 1 round of pandas coding, and 1 round of SQL coding included.
Interview questions [1]
Question 1
How would you handle a situation where a customer's expectations were not met by our product/service?