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 Answer

• Q1. How well do you know excel?
  Add Answer

• Q1. Resume based questions
  Add Answer
• Q2. General discussion about work
  Add 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 Answer

• Q1. When I initially joined my job right after college there was a point where I was constantly
  Add 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...read more
  Add Answer
• Q3. Opportunity great time interest must
  Add 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 Answer