Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Amazon (Seattle, WA) nel mese di ott 2021
Colloquio
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.
Domande di colloquio [1]
Domanda 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
Ho sostenuto un colloquio presso Amazon (Seattle, WA)
Colloquio
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
Domande di colloquio [1]
Domanda 1
Asked me to differentiate between all 3 types of joins
Ho presentato la mia candidatura tramite un selezionatore. Ho sostenuto un colloquio presso Amazon (Tel Aviv)
Colloquio
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.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Amazon
Colloquio
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.
