I applied online. I interviewed at Amazon (Johannesburg) in Jul 2021
Interview
you will be asked to complete a test then telephonic interview .Knowledge around Analytics, Business Intelligence, Databases experience, any programming experience, any experience of analytical tools or technologies and any technical knowledge relating to the Technical Fundamentals . I would also recommend doing some research around the AWS specific Analytics services.
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
Interview questions [1]
Question 1
Walk through my experience
My technical skills
My projects
I applied online. I interviewed at Amazon (Seattle, WA) in Feb 2025
Interview
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
Interview questions [3]
Question 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
I applied online. The process took 4 weeks. I interviewed at Amazon (Seattle, WA) in Jun 2024
Interview
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.
Interview questions [1]
Question 1
1. Few questions on Pyspark(3), Python(3), Sql(5).
2. More focused on amazon leadership principles
