I applied online. I interviewed at Amazon (Seattle, WA) in Feb 2017
Interview
Applied on AWS website, got a phone interview scheduled in a week, the interviewer called me on time. but I did not correctly follow because of his Chinese accent, it was a technical phone interview, where we share the screen to write sql scripts, he started the interview with some behavioral questions for about 15 min and then he jumped to screen share which is fine but on the screen he never wrote the question, he verbally spoke of what he wanted and asked me to write a query on the fly, they mentioned it is in depth technical interview but was mostly behavioral questions with couple of technical quesitons
Interview questions [1]
Question 1
DML / DDL definitons and examples,
why AWS?
Tell me a creative thing you have done in your current job.
SQL query - if there are store with store id and Total_sales and order date, he wanted to compare last weeks revenue to this week by store Id(which I assume because he never wrote the question properly and he just told on the fly, we have board where both of us can write but he have could written the question atleast , its hard to understand the question on the phone with his accent)
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Interview questions [1]
Question 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
The first interview is a technical phone interview that assesses your skills in SQL and Python, specifically data analysis with python. The interviewer pastes the description of an SQL problem on the code editor and asks you to write your answer while describing your thought process. They give you hints when you're stuck.
Interview questions [1]
Question 1
Could you tell me the steps involved in the data analysis process?