Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Amazon (Seattle, WA) nel mese di feb 2025
Colloquio
Overall a lengthy and difficult process. Lots of Leadership Principles involved, so practice them very very well. Leetcode Hard SQLs will do the job. The recruiters prepare as best as they can, but Data Engineering interviews are till not explicitly out there in terms of prep materials. Most of my interviews went absolutely technical in-depth with my experience and projects.
Got a phone call from the recruiter and was excited. Only to know that they were not moving on. The role was for L5
Domande di colloquio [3]
Domanda 1
Phone Screen:
Given orders and Catalog tables,
Q:1.Get the top 10 best selling items for each product group in the US in 2020
Q2 : How much did each item contribute to the total sales of the product group?
On Site:
Round1: Detailed discussion on Indexes and how will I use on a given question. (Note study multiple indexes, partial indexes and order)
Round 2: (Probably Bar raiser)
1. Top 3 unique salaries and all employees having that per department
2. LC 601
Round 3: Only LP
FACT_ORDER_ITEM product_id, customer_id, view_day, item_price, quantity, page_view_id, is_ordered
Note: This table gets 100M/day and has data for 5+years
DIM_CUSTOMER customer_id, address, age, education
Note: this table has 1B records
We need to create geographic and demographic dashboards based on these weekly, monthly, and yearly tables, keeping in mind the huge volume of data within them for any joins
Quite long but the interviewers stays calm and waited for me to answer and even asked me to relax. The interview goes for three rounds i got upto second round
Domande di colloquio [1]
Domanda 1
Walk through my experience
My technical skills
My projects
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Amazon (Seattle, WA) nel mese di giu 2024
Colloquio
The Interview process is bit length which comprises of Phone Screening round(areound 75 mins) foused on Python, SQL and 1 Leadership principle. Loop round consists of 5 interview out of which one is bar riser round.
Domande di colloquio [1]
Domanda 1
1. Few questions on Pyspark(3), Python(3), Sql(5).
2. More focused on amazon leadership principles
