I applied through an employee referral. The process took 1 week. I interviewed at Amazon (Seattle, WA) in Apr 2025
Interview
I recently interviewed for the BIE-II position at Amazon. The process was straightforward and focused primarily on practical skills.
Interview Format:
2 SQL questions: One focused on basic joins and filtering; the other involved aggregation and window functions. Both were solvable but required accuracy and speed.
1 Leadership Principle (LP) question: Behavioral-based, focused on ownership and problem-solving in ambiguous situations.
Feedback:
The difficulty level was moderate, but time management is crucial. Make sure to practice SQL under timed conditions and prepare structured STAR-format responses for LPs. I wasn’t selected, but it was a fair and professionally conducted process.
Tips:
Practice SQL queries with real datasets (like LeetCode or StrataScratch).
Prepare LP stories in advance and align them with Amazon’s core principles.
Be concise and manage your time well during the interview.
Good learning experience overall.
Interview questions [1]
Question 1
For all titles, show:
Total sales amount for 2011 and 2010
Total quantity sold for 2011 and 2010
Flag titles with no sales in 2011 (for deprecation)
2.
Given a transactions table with dates and statuses (COMPLETE, REFUNDED, CANCELLED, etc.), write a query to return the trailing revenue for each date.
I applied online. The process took 1 week. I interviewed at Amazon (Seattle, WA) in July 2025
Interview
Had with an hiring manager for about an Hour.The followup questions are toughHad with an hiring manager for about an Hour.The followup questions are tough. He asked me very deep info
Interview questions [1]
Question 1
Questions related to my project.But they observe very deep detail
This was the recruiter video call. They will ask to share a bit about your background. Then ask you questions to get a sense of your knowledge in SQL and some of the projects you've worked on.
Interview questions [1]
Question 1
Tell me about the data analytic projects that you work on currently. Also whether you have any programming skills such as PYthon.
Se basaba en lo siguiente la entrevista
Pregunta de leaderhsip de Amazon
Una pregunta de SQL y otra de Python
Se hace como en un notepad y no se compila