I applied online. The process took 4 weeks. I interviewed at Amazon (Seattle, WA) in Sep 2019
Interview
I got the email from the recruiter for setting telephonic interview. Once they said i will have 1 telephonic but then it was 2 rounds. First was with manager and second was with team member. All Q was easy but look like they have already selected one candidate because after saying all Qs and SQL correctly I got a email with no offer.
Interview questions [1]
Question 1
How to do analysis of the website when some product is not showing good sales.
I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Seattle, WA) in Sep 2019
Interview
Very quick and efficient. Recruiter reached out. Set up a telephonic interview after a quick call and approval from hiring manager. Was initially considered for a data engineer position then considered for a business intelligence after the call
Interview questions [3]
Question 1
If there is a project on which you have never worked before, how will you tell that the data you are using for this project is correct and will help you get the correct results?
SQL question - Table1
year| month| order_id| seller_id| book| quantity| prices
2008|June| 1|888|HP| 2| 2000
2008|June| 1|888|LoTR| 1| 1000
2009|July| 2|999|HP| 1| 1000
Q1. find avg quantity of books solder for every order_id every year?
Q2. find max units of books sold for every order_id
I applied through an employee referral. I interviewed at Amazon
Interview
Email questions for basic information, salary expectation, relocation, work authorizations and etc, recruiter call, two phone screens, and then full-day onsite with 5 to 6 people with lunch break, got decision from recruiter just one day after that