Amazon Interview Questions

Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer

Teja G. - "To design a scalable ticketing system for peak events like Black Friday, you must employ a microservices architecture, implement robust load balancing, leverage caching, and use a combination of NoSQL and relational databases for different data types. Key features also include real-time seat booking, secure payment integration, mobile compatibility with QR code validation, robust admin dashboards for analytics, and integrated marketing tools like promo codes. The system needs to prioritize avail"See full answer

Tesfaye M. - "This situation requires balancing business urgency with technical stability. Here's how I'd approach it: 1. Understand the Business Requirement Clarify why the new requirement is urgent. What’s the impact if it's delayed? Is it revenue-generating, compliance-related, or competitive? 2. Assess the Bugs Work with engineering to understand:Root cause: Are the bugs pointing to a deeper systemic issue? Severity and impact: Are they blocking users or just edge cases?"See full answer

Umang S. - "Context - I joined a large public-facing service as a PM midway through its development. Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics Concern - As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework This was evident in the show and tells as the"See full answer

Rajesh V. - "As a PM i received a feedback from my program manager on my style of verbal communication. It is about me speaking faster when i wanted to get away with a topic that i wasn't confident (may be not backed up with data, or still in process of getting detailed insight of a problem etc.). Whereas when I'm confident I tend to speak slowly or more assertively that made people to follow easily. I welcomed that feedback so from then on when I'm not confident in a topic I became more assertive to let pe"See full answer

Vihari K. - "At RTI while working on content-based recommender system on our ecommerce site, we received request from one of our distributor clients to make the system not only suggest products based on their purchasing history but also exclusively push higher priced items, regardless of their actual needs or demand patterns, it was challenging situation because it contradicted the primary purpose of our system, which was value based, patient centric product recommendations. To understand in this situation i"See full answer

Daniel P. - "Okay, so I understand the question: "how does Google Maps compute estimated time of arrival"... There are a couple scenarios when ETA is calculated: planning a future journey, planning current journey. Can we assume scope to the current journey? The learnings will likely be transferable. User inputs to ETA include origin, destination, and route chosen. Let's assume first that the user has chosen an origin, destination, and a route chosen. We can come back to these assumptions later. The way I'"See full answer

Hamzeh H. - "S – Situation: In a university project, my team was building a collaborative code editor. As part of the functionality, we needed a login system so users could securely access their sessions and collaborate in real time. T – Task: I was responsible for implementing the authentication system. Initially, I planned to build the entire login system from scratch, including user management, password storage, and session handling. But as the deadline approached, I realized that implementing thi"See full answer

Ashish G. - "Rate Limiter is to limit the number of request from a particular IP Address. Rate limiter will block the IP address to reduce the load on server. It should be highly available and handle concurrent requests. Blocked IP addresses should be kept in a pool which is present in shared cache. We need to keep threshold value after it reaches threshold value it should start blocking IP address. All these ip address to be kept in No SQL DB. Batch will run that will clear the cache and delete all the bloc"See full answer

Hans - "Described a scenario where I joined an established project as an EM Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off) The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities) We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"See full answer

Anonymous Goat - "Batch Packing Problem In Amazon’s massive warehouse inventory, there are different types of products. You are given an array products of size n, where products[i] represents the number of items of product type i. These products need to be packed into batches for shipping. The batch packing must adhere to the following conditions: No two items in the same batch can be of the same product type. The number of items packed in the current batch must be strictly greater than the number pack"See full answer

Ben G. - "Situation - A time I dealt with conflict while on a team was while I was working at Shopify on physical and digital gift card refund point of sale solutions. The situation was that we were dealing with complex technical constraints including not changing particular UI components behavior to act as they should be intended. On the refund screen, the existing design was using a toggle on the same screen to bring up a modal for gift card selection to either select digital or physical options. Thi"See full answer

Surbhi A. - "Authentication verifies "Who you are." Authorization determines "What you can do." Authentication establishes identity, while authorization specifies the actions or resources a user or entity is allowed to access or perform."See full answer

Kiley S. - "Great question. As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well. In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"See full answer

Umang S. - "Situation- I was leading a product through a complete overhaul to a new replacement product, and at the same time had to maintain the old product. Concern - In the old product, the team was usually stuck 40-50% of the time in bug fixing This could have hampered the velocity and GTM of the new product Action Localised the problem to one major component - Export and Import Function- had 90% contribution to the issues Worked with the engineering team to diagnose the issue, the issue was i"See full answer

Anonymous Tortoise - "Questions? -Geography - US/ International Model? SEXY? Model 3 Most used. Timeline - 3 Quarters? Increase engagement? - Existing people Tesla - Electric company that builds EV cars. Mission- To accelerate the world's transition to sustainable energy? Mission Why - To increase the engagement - active users Recent Trends - Apps are rising on Apple Watch Ease of Use? Portability? Customer Segments New people who bought Tesla Existing People Models - Model 3 Fleet Owners ["See full answer

Bk - "To bring any product to market here are the below steps that I would (did) take: 1.Understand the problem stmt / stakeholder need and asses depth of the problem (qualitatively and then gather metrics to quantify it) 2.Do market study on understanding relatable solutions if any 3.Carve out viable solution/ideation that aligns with overall Business Vision/Goal 4.Get stakeholders buy in on the idea 5.Guesstimate and prioritize high level features, Cost and ROI. 6.Build Business case for Project Le"See full answer

Scott S. - "Great question! Last year, we were working on a critical project to develop a real-time risk analytics platform. This platform was designed to provide our traders with instantaneous risk metrics, allowing them to make informed decisions in a fast-paced trading environment. Midway through the project, we faced a significant issue: our chosen data processing framework was not performing as expected under the high data throughput required by our trading algorithms. This was causing unacceptable lat"See full answer

Jonathan S. - "To clarify the question, we need to know What portion of “food” are we discussing? All groceries, cold ready-to-heat meals, meal kits, hot meals, or something else? Finding “something else” presents the opportunity to invent a new sector of the business that leverages Amazon’s unique strengths. That’s more likely to be a winner idea, from Amazon’s perspective and the interviewer’s opinion of you, than copying some other company’s existing approach. But it’s also possible the interviewer has a"See full answer