I applied online. The process took 1+ week. I interviewed at Amazon
Interview
I applied online through amazon website. Recruiter contacted me through email and scheduled the first phone interview. The interviewer asked me about my experience. Then he started asking questions on dimensional modeling and data warehousing concepts
a) why do we use a dimensional model?
b) What are the advantages of surrogate keys? Why can't we use natural keys?
c) Smart key
d) Data vault
e) Mini dimension
f) Kimbal vs Inmon concept? What will you use for a project?
Then he started with SQL qns. Had to tell him sql queries for a few scenarios. Most of the using window/analytical functions..
Asked me whether I have any experience in BI tools
A second phone interview was scheduled after 2 to 3 days. The interviewer started asking me about performance tuning in Oracle.. He asked me in detail about. Btree indexes - how do they work? Bit map indexes- What are the disadvantages ? how do we tune a query? partitioning... different types of join -- merge, hash , nested loop? When will index be not useful?The more I answered, he started asking in detail.
Then he started with SQL -- ROLLUP and CUBE functions... Analytical functions.. Connect by etc,,,
Then some basic questions.. Normalization, Data warehousing definition., Asked me how do you start designing a dimensional model.. etc
I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Chicago, IL) in Jun 2025
Interview
Amazon interviews consist of two types of questions:
1) Behavioral Questions based on the Amazon Leadership Principles (LPs)
2) Technical and Functional Questions based on the qualifications of the job.
Interview questions [1]
Question 1
You are given a list of dictionaries, where each dictionary represents a product with keys 'product_id', 'product_name', and 'price'.
I applied online. The process took 4 weeks. I interviewed at Amazon in Nov 2024
Interview
The recruiter set up the first round phone screening, and it took us three weeks to finally find a time. Though the interviewer didn't show up during the scheduled time, and the recruiter kept ghosting me without any updates. It looks like the position has been filled, but they gave no respect on the candidates who are still in the interview process. It's the worst interview experience I've ever had.
Interview questions [1]
Question 1
Just had the recruiter round, some questions on the backgrounds and experience.
I applied through an employee referral. The process took 2 months. I interviewed at Amazon (Seattle, WA) in Mar 2024
Interview
1 hour * 1 round of technical screening, behaviour questions & SQL questions asked
1 hour * 5 rounds loop interviews, a lot of behavior questions each round, 1 round of pandas coding, and 1 round of SQL coding included.
Interview questions [1]
Question 1
How would you handle a situation where a customer's expectations were not met by our product/service?
