J'ai postulé en ligne. Le processus a pris 1 semaine. J'ai passé un entretien chez Amazon (Clarksville, TN) en nov. 2021
Entretien
Before my interview, I came to glassdoor to learn from other peoples experiences. To be honest, All the questions I was asked had already been talked about on glassdoor. I had two sections, 45mins each. Each section was a technical and behavioral.
Questions d'entretien [1]
Question 1
Difference between Star schema and snowflake.
Query Tuning.
SQL coding.
Behavioral questions(LP).
What is the most complex data pipeline you have built.
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
Questions d'entretien [1]
Question 1
Asked me to differentiate between all 3 types of joins
J'ai postulé via un recruteur. J'ai passé un entretien chez Amazon (Tel Aviv)
Entretien
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.
J'ai postulé en ligne. J'ai passé un entretien chez Amazon
Entretien
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.