I applied online. I interviewed at Amazon (Medford, MA) in Oct 2021
Interview
I am still in the interview process but I liked so far that recruiters are very nice and resourceful. First, it started with a phone call and technical assessment in SQL and Python. Second round with the hiring manager. And I had final on site interview in which they ask tons of scenarios. Over all, it was a great experience.
Interview questions [1]
Question 1
Tell me about a time when you were not able to deliver your work on deadline.
The Interview process was 50-50 technical and behavioral.
I managed to answer the sql parts but failed to get the right scenarios while answering the behavioral types. It needed practice .
Interview questions [1]
Question 1
Behavioural--
what was the new BI feature that you built that was greatly appreciated and none of them have tried so far
What KPI did you create recent and please tell the business flow.
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