Amazon Vendor Consultant Interview Questions and Answers

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. About yourself?
Add your answer
Q2. What's about your experience?
Ans. 
I have over 8 years of experience in financial analysis, project management, and team leadership.
• Managed a team of analysts to successfully implement cost-saving initiatives

• Led cross-functional projects resulting in increased efficiency and profitability

• Performed in-depth financial analysis to support strategic decision-making

• Collaborated with senior management to develop and execute business plans
Answered by AI
Add your answer

Q1. How was your product handling?
Ans. 
My product handling experience has been excellent, with a focus on efficiency and accuracy.
• Implemented efficient product handling processes to streamline operations

• Ensured accurate inventory management and tracking

• Trained team members on proper product handling techniques

• Utilized technology to improve product handling efficiency, such as barcode scanning systems
Answered by AI
Add your answer
Q2. What was the customer experience given as feedback your work?
Ans. 
The customer feedback on my work was overwhelmingly positive, highlighting my attention to detail and excellent communication skills.
• Received positive feedback on attention to detail

• Received positive feedback on communication skills

• Customers expressed satisfaction with the overall experience
Answered by AI
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

SQL and Python Questions

Q1. SQL and case study question
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