Amazon Analytics Specialist Interview Questions and Answers

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 test on hackerrank

Q1. What do you know about Uber?
Add your answer
Q2. Went over my current role
Add your answer

Q1. Explain past projects
Add your answer

Q1. Explain resume points
Ans. 
Resume points are concise descriptions of your work experience, skills, and achievements listed on your resume.
• Resume points should be clear, specific, and quantifiable.

• Use action verbs to start each point, such as 'developed', 'implemented', 'analyzed'.

• Include relevant metrics or results to demonstrate impact, such as 'increased sales by 20%' or 'reduced processing time by 30%'.
Answered by AI
Add your answer

Aptitude Test had questions on sql, analytic ques, case study ques on uber

Q1. What are Sql joins, window functions
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
• SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).

• Window functions are used to perform calculations on a set of rows related...read more
Answered by AI
Add your answer
Q2. Write sql queries
Ans. 
Answering SQL queries in an interview for Data Analyst Intern position
• Understand the database schema and tables involved

• Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses

• Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
Answered by AI
Add your answer
Q3. Given 5L and 3L jar. How will you make it 4L (Logical thinking)
Add your answer
Q4. Questions on resume projects
Add your answer
Q5. Questions on excel functions
Add your answer

Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.

Q1. Coding and data structure
Add your answer

Q1. ML Breadth and depth
Add your answer