2 rounds each 45 min. Each round was a combination of behavioral and tech questions. They have live code page for you to solve some sql and python coding probs.
Phone call from HR, second call from HR after 3 months then technical round. Techinal questions about cloud scala tableau python sql etl data warehouse tableau server agile methodology tfs scrum process
I applied online. I interviewed at Amazon (Seattle, WA) in Feb 2021
Interview
they have sent a link for the first round , after 2 days scheduled a call with a team member, it was mostly technical and some behavioral ,then next round was with manager mostly behavioral questions.
Interview questions [1]
Question 1
first round - written: 3 sql and one about what will you do to improve the fastness of an insert on a huge table
second round -
get the players with highest streak
get the employee details who has maximum members in a team.
python-return the numbers which have maximum count in a list
round 3: behavioral questions and 1 question on python lists. from the 2 lists get the numbers that are common , and return the numbers in the following way.
[1,2,3,3,1,1,1],[1,1,2,2,3] - return [1,1,2,3]