I applied online. The process took 5 weeks. I interviewed at Amazon (Edimburgo, Escocia) in May 2022
Interview
I was invited for a phone interview with technical and behavioural questions.
For behavioural questions, I was asked from Leadership Principles like "Tell me a time where you exceeded the expectations"
Interview questions [1]
Question 1
(ordr_date, cust_id, product_id, prc_per_unit, unit)
('2020-10-01', '1', 'AA', 10.5, 2),
('2020-11-01', '1', 'BB', 1.5, 3),
('2020-01-01', '1', 'CC', 3.5, 8),
('2020-01-01', '2', 'CC', 4.5, 3),
('2020-01-01', '2', 'BB', 1.5, 3);
1. List the top 20 customers who have the highest spending
2. Find the highest spent product for each customer
I applied through other source. The process took 2 days. I interviewed at Amazon in Apr 2022
Interview
3 interviewers. One tech question. 2 behavior questions. most behavior questions related to Amazon Principles. Tech questions related to SQL query, any past experiences work portfolio. Should be able to tell how and why the query was written in the way it is.
Interview questions [1]
Question 1
Tell me why you wrote the query in this format for the project you worked on.
I applied online. The process took 4 weeks. I interviewed at Amazon in Apr 2022
Interview
Applied online. Got an email about SQL coding round. Then second round was behavioral interview with hiring manager. I was not able to move forward after that. This was my second time second round of interview for the BIE position.
Interview questions [1]
Question 1
Easy SQL Leetcode questions
Questions based on past experience related to Amazon LP.