Amazon Senior Data Analyst Interview Questions and Answers

SQL test on hackerrank

The first round was a 45 min long aptitude and case study round which involved basic aptitude questions along with certain cases like "There has been a drop off in customers booking a hotel though the the total number of visits to the site has not dropped. How would you you design a system to analyze the problem and what kind of data will you collect." It was followed by a couple of HR questions

A mock data set of hotel bookings in different countries for last two years were given a week prior to the interview. We were to clean, prepare, derive insights and recommend actions. All of this needed to be documented as 15 page presentation. This presentation then needed to be presented in a 45 min meet.

SQL - shared question on the screen and asked to code in SQL

Q1. Nth highes salary
Add your answer

Q1. How well do you know excel?
Add your answer

Q1. Resume based questions
Add your answer
Q2. General discussion about work
Add your answer

Q1. All about the past projects. Few basic data visualization concepts like what charts to use, what will be the best fit for a particular scenerio
Add your answer

Q1. When I initially joined my job right after college there was a point where I was constantly
Add your answer
Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
Add your answer
Q3. Opportunity great time interest must
Add your answer

Group discussion can also provide feedback to instructors on participant comprehension.

SQL and Math are judged in this round

Analytical and Presentation skills are judged in this round

Q1. Stakeholder management, situational questions, STAR methodology
Add your answer