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
I applied online. I interviewed at Amazon in Feb 2019
Interview
It is the first round with the team manager. All the questions are about simple tech concept or simple code, including R, Python, SQL, machine learning, stats, Excel, Tableau. No behavior question.
I applied through college or university. The process took 1 week. I interviewed at Amazon (Minneapolis, MN) in Mar 2019
Interview
Extremely impersonal, rushed and unfriendly. After submitting the original application through my school program we met for a technical interview. Although the questions were individual they had 40 of us in a proctored exam room for two hours to complete all of the questions.
Interview questions [1]
Question 1
Technical problems asking us to provide SQL scripts demonstrating the ability to join tables and perform basic arithmetic. Also requested data visualization code in either R or python for a given problem. Lastly wanted to know how I would set up an online A/B testing scenario and how I would determine whether or not to roll out a new program given the results of the experiment.