Envié una solicitud electrónica. El proceso duró más de 1 semana. Acudí a una entrevista en Amazon
Entrevista
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
Solicité el puesto a través de un captador. El proceso duró 2 semanas. Acudí a una entrevista en Amazon (Chicago, IL) en jun 2025
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
You are given a list of dictionaries, where each dictionary represents a product with keys 'product_id', 'product_name', and 'price'.
Envié una solicitud electrónica. El proceso duró 4 semanas. Acudí a una entrevista en Amazon en nov 2024
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
Just had the recruiter round, some questions on the backgrounds and experience.
Solicité el puesto a través de la recomendación de un empleado. El proceso duró 2 meses. Acudí a una entrevista en Amazon (Seattle, WA) en mar 2024
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
How would you handle a situation where a customer's expectations were not met by our product/service?
