I applied online. I interviewed at Amazon (Reston, VA)
Interview
Applied Online. The recruiter called first. This was then followed by a technical phone Interview (Most of the questions were related to SQL basics and data modeling). This was then followed by an On-Site Interview (5 Interviews).
I applied through other source. I interviewed at Amazon (Seattle, WA) in May 2017
Interview
First, the hiring manager contacted me on LinkedIn. After which I was asked for my resume and then HR setup the technical phone screening. Interviewer showed up about 10 mins late and took about 1 hour for the entire process.
Interview questions [1]
Question 1
Usual stuff - tell me about your work experience, current project etc.
Then proceeded to their online SQL coding site. Given sample tables and asked various questions involving Outer Joins & Cross Joins, Sub Queries, Query to fill missing data etc
I applied through college or university. The process took 1 day. I interviewed at Amazon (Hyderabad) in May 2017
Interview
First round is about testing problem-solving skills i.e, coding round and the next round is on writing complex queries as the role itself is related to the handling of huge data.
Shortlisted people from above rounds are gone through Technical interviews both coding and sql interviews.
Interviewers were very supportive and giving hints.
In coding interview i was asked on arrays and binary trees.
In sql interview , asked to write few queries and few questions about how i managed my databases, tables in my projects and explain briefly.
Final shortlists were gone through HR round where we are asked mostly about our projects
Interview questions [5]
Question 1
write a code for finding the sum of any two numbers in the given array could be equal to x
Marks of a subject of many students are arranged as a Binary Search Tree.Found that even ranked students cheated in exam so deduct 10 marks from each even ranked student without changing the structure of the tree