I applied through a recruiter. The process took 1 week. I interviewed at Amazon (Seattle, WA) in Oct 2016
Interview
A recruiter saw my resume on Linkedin and they contact me. They sent over SQL and Probability Assessment Test to complete . The recruiter told me they won't ask me questions on SQL and Probability if you complete the assessment Test. When the interview process started I told the interviewer that I completed the Assessment Test so am not expecting any questions from SQL and Probability. Unfortunately the interviewer did not listen and the entire interview questions was on SQL and Probability. No questions on Data Science which I prepared for. I was very disappointed in the process. After 48 hours the recruiter sent an email saying they even though I did well in the interview they decided to proceed with other candidates. I could have even spent all my time on SQL and Probability if I knew thats what they were going to do, I smell something bad with the interview process.
Interview questions [1]
Question 1
They asked probability question:
1) The probability that item an item at location A is 0.6 , and 0.8 at location B. What is the probability that item would be found on Amazon website.
2). I have table 1, with 1million records, with ID, AGE (column names) , Table 2 with 100 records with ID and Salary then the interviewer gave me the following SQL script
SELECT A.ID,A.AGE,B.SALARY
FROM TABLE 1 A
LEFT JOIN
TABLE 2 B
ON A.ID = B.ID
+
WHERE B.SALARY > 50000 ( HE ASKED TO MODIFY THIS LINE OF QUERY)
How many records would be returned?
3. Give a csv file with ID, and Quantity columns, 50million records and size of data is 2gig, write a program in any language of your choice to aggregate the QUANTITY column.
There are three rounds in total. The process begins with a coding round, followed by the main interview loop, where you will meet the team and discuss technical skills, experience, and fit.
First round is fun, second round, which is also the final round involved 5 sessions, with different focus. For some sessions, not be able to present my story completely, time was tight, and interviewers were rushing.
Thrilled to have accepted the offer — the process was tougher than I expected. The first round was primarily technical, where I tackled an A/B testing design question that required detailed metrics and sample size calculations. Later, I faced a SQL query challenge focused on tracking customer purchases over consecutive months. Funny enough, I had spent quite some time on PracHub digging into similar case studies, which really helped me approach these problems confidently. The final round included behavioral questions, and I felt well-prepared overall.
Top companies for "Compensation and Benefits" near you
