They should really monitor the interview for Quality, Correctness and to see what the interviewer is doing.
I was interviewed for a Business Analyst position for which I was meeting all the checks described in that role, including some extras BUT I was solely judged on the deep programming and scripting questions that can be easily googled on stack overflow whenever needed.
As a business analyst, why am I supposed to know the 10 different ways of finding the Nth highest salary? Is it not enough if I know one using a function or whatever. Can I not google other ways when needed? For a BA what is more important -To understand why the Nth salary is required or the different ways of getting it ?
Did the interviewer forget that he is not interviewing a Data Engineer? I wasn't even asked if I am OK to write the complex codes. It was just thrown on my face after I was done introducing myself.
Was my analytical ability tested? - NO
Problem Solving? NO
Requirement Understanding capability? NO
Business Process Knowledge? NO
I am not sure if that interviewer had a fixed set of questions for every position that 'he' is interviewing or if he had no idea what a BA does.
Amazon - As an interviewee, It would really help if you assign the right interviewer who at least knows what to ask for that specific role! OR make sure you highlight all the relevant skills in the Job description to save applicant's time and efforts.
Interview questions [1]
Question 1
SQL Transpose queries
Python Scripting
Output of specific programs
I applied through an employee referral. I interviewed at Amazon (Austin, TX)
Interview
The process consisted of a technical and behavioral round. Although the recruiter stated it would cover SQL and behavioral topics, the interview focused entirely on scenario-based and behavioral questions without a live SQL technical assessment. Communication after the interview was poor; the recruiter did not respond to follow-up emails, and an automated rejection notice was sent two days later.
Interview questions [1]
Question 1
They asked me to describe a mistake I made in a past project, how I handled it and what I learned from the experience.
I applied online. I interviewed at Amazon (Hyderābād)
Interview
Easy.
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc. They also ask about projects you have worked on.
Interview questions [1]
Question 1
Questions were mostly from sql - Basic to medium level
Topics were Group By, joins, window functions etc.
Basic python knowledge with libraries like pandas, numpy etc.
The interview process includes a SQL test, an initial recruiter call, and a final five-round loop featuring technical questions and discussions focused on Amazon leadership principles with different team members.
Interview questions [1]
Question 1
They asked a key question focused on both technical depth and culture fit: how you apply your skills to solve real problems, along with examples demonstrating alignment with Amazon’s leadership principles.