I applied online. I interviewed at Amazon (Seattle, WA) in Dec 2020
Interview
Applied and got an email from HR with basic housekeeping like why amazon, require sponsorship, open to relocation, answered those, and a phone interview was set.
Applied and got an email from HR with basic housekeeping like why amazon, requires sponsorship, open to relocation, answered those, and a phone interview was set. No HR Call
Order Table
OrderID|Merch ID|MerchantID|Category|date|price|quantity|……
MerchantID|ID|Name|Status
1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null
I applied online. The process took 2 months. I interviewed at Amazon (San Francisco, CA) in Sep 2025
Interview
It started with an OA on SQL with MCQs and 2 SQL coding questions. Then, 75mins of Technical Phone Screening focusing completely on SQL coding, few basic questions on visualization and 1 behavioral question. Next was virtual onsite where 5 rounds were there. Themes of the rounds were clearly explained by recruiter and LPs were given for each round by recruiter. So don't miss the recruiter prep call and get as much as details you need from it. 5hours of intensive interview with Manager round, Analytical problem solving round, SQL coding round, 1 round with a PM and bar raiser round. Overall very good experience. If given a chance, choose 2 days as 1 day can be pretty exhaustive. I got 2 days schedule so was able to prep for behavioral questions with remaining on my list for the 2nd day.
Interview questions [1]
Question 1
Phone screen: SQL coding question on joins. level of difficulty increased with each question and edge cases were questioned chosen by me and interviewer gave good hints which i used well to correct my query.
Virtual onsite: do lot of mock up rounds based on the interview themes. that would help you a lot.
7 Interviews in total, 5 Interviews for the loop stage.
The loop interviews consisted of SQL, analytical problem solving, stakeholder management, metrics & reporting, and business acumen
with two questions on leadership principles for each interview.
Interview questions [1]
Question 1
Tell me about a time when you took on something significant outside your area of responsibility. Why was it important? What was the outcome?
I applied online. I interviewed at Amazon (New York, NY) in Nov 2024
Interview
first round was a 2 questions around business and solving a data problem and some basic questions on their lp. next round was 2 hour with the panel on the same question asked earlier diving deep
