Amazon (Business Analyst) interview questions

Phone call round SQL test Loop interview : Only on experiences I have 5 interviews on loop. But no proper response from the HR and recruiter. We cant call them too, as they call from an another country number.

The process was structured and aligned heavily with Amazon’s Leadership Principles. It consisted of four rounds over about 2–3 weeks: Phone Screen (Recruiter): The recruiter gave a solid overview of the role, team, and what to expect. No technical questions, but they asked about my experience with SQL, Excel, and business analytics tools. Technical Screen: This was a 45-minute session with a Business Analyst. It focused on SQL queries and interpreting data from tables. I was asked to write queries to join datasets and calculate key metrics like revenue and conversion rates. Some Excel questions were also asked (VLOOKUP, pivot tables, etc.). Case Study Round: I was presented with a real-world business problem involving customer behavior and was asked to propose a data-driven approach. I walked through how I’d gather data, structure analysis, and measure success. No coding—just logic and storytelling. Final Loop (3 interviews): One behavioral interview focused on Amazon’s Leadership Principles (e.g., "Tell me about a time you disagreed with a team decision..."). One technical/analytical deep dive. One interview with a hiring manager discussing stakeholder communication and prioritization.