Amazon Associate Business Manager Interview Questions and Answers

Q1. What you have technical improvement in codes?
Ans. 
I have implemented various technical improvements in codes to enhance performance and functionality.
• Implemented caching mechanisms to reduce load times

• Optimized database queries for faster retrieval of data

• Introduced error handling techniques to improve code reliability

• Utilized design patterns to make the codebase more maintainable

• Refactored legacy code to adhere to best practices
Answered by AI
Add your answer
Q2. What is your excitment about fresh job?
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

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
• The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

• Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
Answered by AI
Add your answer

Q1. Interview with stakeholders
Add your answer

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. 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

The first round was with the consultancy manager and they screened my resume and felt it is good match for the role. The second round was taken by the Project Manager of LinkedIn and 3rd round from the assigned team's manager. Both the last two rounds included cases studies, Questions on the resume and previous experiences and the decision making on the situations.

There were few questions from my end to the interviewer on the 3rd round for which the interviewer(she) got irritated and asked me to check on the JD, the question was in relate to know the products of LinkedIn whereas the the details in related to the products of LinkedIn was not mentioned. Only the role and responsibilities were stated.

However she even escalated this to the consultancy. I felt the interviewer is so immature and impatient in handling situations and was skeptical of her handling the team and eventually it proved right.

She made me feel very degraded being a Contract role employee, even a small mistakes and even misunderstandings were notified to the consultancy and was been escalated. It clearly showed that there is lack of leadership qualities and taken for granted attitude. (The team is "Outsourcing and Strategy")

I wish no one should no face such situations and get departed for silly reasons, Everyone has their commitments, responsibilities and duties which will affected deeply in the midway.

Nonetheless every employee irrespective of Permanent or Contractual deserves respect, motivation and a good words from his/her hierarchy rather pointing out, escalations will take no where.

I was surprised that LinkedIn has such attitude issues with contract role employees (Some managers).

However, I wish whoever applying to any roles in LinkedIn do get a good manager at the first place and the rest all falls in its place eventually. All the best...!!!

Q1. Please refer the above
Add your answer

SQL and Python Questions

Q1. SQL and case study question
Add your answer