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.
I applied online. The process took 2 weeks. I interviewed at Amazon (Londres, Inglaterra) in Mar 2022
Interview
I applied through the carrier website. I scheduled the interview after 2 weeks.
First-round was a 60-min technical round where the first 30 minutes were focused on basic data warehouse questions and detailed project discussion. Overall good experience
Interview questions [1]
Question 1
1. Tell me about yourself
2. difference between transactional databased and OLAP
3. pick a field you are strong in and then follow up questions were asked
SQL:
given a table consisting of routes including source and destination find the sources which are never a destination. (something like that, don't remember exactly)