I applied through a recruiter. The process took 3 weeks. I interviewed at Amazon (Seattle, WA) in Jun 2019
Interview
Very dissapointed on the process. I would stay away. Recruiter contacted me, asked about experince, set up interview half technical half behavioral. Was suppoed to be witb manage for Finance team. someone else called on his behalf, very abrupt w questions, all over place with SQL, but more database foundational questions, than ETL technologies very interested in SSIS, weird. Did not have the decency to go over full length of interview. Big discrepancy between recruiter ans interviewer.
Interview questions [1]
Question 1
Diff between OLTP and OLAP.
Different schemas for dbs, like star schema
Normalization for tables
Surogate keys
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Interview questions [1]
Question 1
What is the difference between inner and left join?
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
Top companies for "Compensation and Benefits" near you
