Amazon System Analyst Interview Questions and Answers for Freshers

Q1. They will ask about your profile and past experience.
Add your answer

Q1. A peer level colleague will ask some basic knowledge check questions
Add your answer

This is literally a live coding test. For analytics expect SQL, python, R.

Q1. Interviewed by a manager of another team
Add your answer

Q1. Interviewed by dotted line reporting manager
Add your answer

Q1. Cross functional interview
Add your answer

Q1. Core Values Interview
Add your answer

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer

Q1. Questions mostly focused on window functions like row_number and aggregate functions like group by there was also a question based on self-join.
Add your answer

SQL and Python Questions

Q1. SQL and case study question
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

SQL and Excel questions

Q1. Finance and analysis related questions
Add your answer

Q1. How to sort ararat
Ans. 
Ararat can be sorted alphabetically or numerically.
• Sort alphabetically: Arrange in ascending order based on the letters in the word.

• Sort numerically: Arrange in ascending order based on the numerical value of each character.
Answered by AI
Add your answer