Me postulé en línea. Acudí a una entrevista en Amazon (Seattle, WA) en oct 2021
Entrevista
Two rounds back to back 45 mins each. After I applied I got an email from the recruiter to schedule an interview, I had a 7-day buffer to schedule it. They were very kind. Amazon has a policy of giving out the results within 5 business days of the interview and I received it on the 5th day accordingly.
Preguntas de entrevista [1]
Pregunta 1
1) Data warehousing basics
2) Python coding - intermediate level
3) 2 SQL questions - group by, RANK() types
4) Resume drill down
5) Tell me about a time you helped a teammate?
6) Hardest data pipeline you have worked on?
7) Difference between STAR, SNOWFLAKE and GALAXY schema
8) SCD and types
9) A recent ETL process you have worked on and challenges you faced in it
First round was OA with SQL questions, mcqs and 1 DSA then 2 Technical interviews SQL questions like joins, group by, NULL values, SQL theory, easy to medium leetcode, questions on resume
Preguntas de entrevista [1]
Pregunta 1
Asked me to differentiate between all 3 types of joins
Me postulé a través de un reclutador. Acudí a una entrevista en Amazon (Tel Aviv)
Entrevista
After submitting my resume, I received a home assignment with one week to complete it. Later, I attended two interviews that included personal and professional questions about my experience, previous projects, problem-solving skills, and relevant technical knowledge.
Me postulé en línea. Acudí a una entrevista en Amazon
Entrevista
The process started with an online assessment (OA) that included SQL and data-related questions. The technical interview focused on core data engineering concepts such as normalization, joins, and a self-join problem, along with some discussion on data modeling and query optimization.
