J'ai postulé en ligne. Le processus a pris plus d'une semaine. J'ai passé un entretien chez Amazon
Entretien
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
J'ai postulé via un recruteur. Le processus a pris 2 semaines. J'ai passé un entretien chez Amazon (Chicago, IL) en juin 2025
Entretien
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.
Questions d'entretien [1]
Question 1
You are given a list of dictionaries, where each dictionary represents a product with keys 'product_id', 'product_name', and 'price'.
J'ai postulé en ligne. Le processus a pris 4 semaines. J'ai passé un entretien chez Amazon en nov. 2024
Entretien
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.
Questions d'entretien [1]
Question 1
Just had the recruiter round, some questions on the backgrounds and experience.
J'ai postulé via la recommandation d'un employé. Le processus a pris 2 mois. J'ai passé un entretien chez Amazon (Seattle, WA) en mars 2024
Entretien
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.
Questions d'entretien [1]
Question 1
How would you handle a situation where a customer's expectations were not met by our product/service?
