I applied online. I interviewed at Amazon (Seattle, WA)
Interview
It was of three rounds. Two Technical and one behavior. First round was SQL coding, second round was based on LP principles and third was SQL coding again. The first technical round there were 5 SQL questions , then questions related to Tableau.
Interview questions [1]
Question 1
Q. How would you determine the salary of an employee who have been 5 years and above
Q. What if you do a right join instead of left join on a table
I applied online. The process took 4 weeks. I interviewed at Amazon (Londres, Inglaterra)
Interview
It was good. Interview lasted almost 1 hour long in with interviewer asked questions about SQL and ask me to run some queries as well as python code to check my knowledge in both the domains.
The first round is the recruiter phone screen. Followed by an interview with the hiring manager. Next is the tech interview which covers SQL + query optimisation. The last stage is the interview loop (4-5 rounds).