I applied online. The process took 1 week. I interviewed at Amazon in Apr 2021
Interview
HR interview revolved around STAR method (behavioral questions), past experience and how to tackle the problems. You also need to elaborate the challenge, the solution and the measurement or the evaluation.
Interview questions [1]
Question 1
Tell me about the most complex problem/project you’ve ever worked on
What is the biggest challenge you have overcome?
"Tell me about a time when you disagreed with a manager/peer. How did you handle the situation? What was the result?
Tell me about a time when you (or your boss) made an unpopular decision that had to be executed by your team
Describe a time when you sacrificed short term goals for long term success
Talk me through situation when you had to persuade someone
Gave the online assessment followed by a technical phone screen.
The technical phone screen was focused around SQL questions and along with some behavioral questions and a business case to solve.
Interview questions [1]
Question 1
General questions about SQL, Windows function and solving few questions on white board.
It was a on-campus job , so we had 2 Technical rounds.
Everything in the technical interviews was related to data visualization tools, python and SQL.
SQL is the most important skill they look for in a BI engineer when you join them as a fresher.
Interview questions [1]
Question 1
About internship that I did , the database used in that project and tables and their relationships in that database and some tables and queries were given and should write sql queries for those questions.