Amazon Data Engineer Interview Questions

I leaned pretty heavily on this sub and others while prepping, so wanted to give back by sharing my experience interviewing for an L5 BIE (Business Intelligence Engineer) role at Amazon. **TL;DR** – R

I wanted to share my recent interview experience with Amazon for a Senior BI role. I put in a ton of effort preparing for this—deep-diving into Amazon’s Leadership Principles, structuring my behaviora

I have an interview coming up, BIE L5. Apart from being very proficient in SQL and knowing LPs with supporting stories from the work experience- 1. What all is the candidate tested on? I know it can d

For Data Engineer 1st round below were questions asked. 1) can we have nulls in unique keys? 2) What are the various optimised file systems Distributed file system? [Confused?? Actually the interviewer...

Hello everyone, I have read many interview experience posts about SDE and DE roles at Amazon. I noticed that DE roles revolve mainly around SQL, databases, ETL, and big data, with...

I have Amazon interview in upcoming week for Data engineer role they have told me that there will be 4 section for this interview 1> ETL 2> SQL Queries 3> Handling Big data...

Hi, I have my amazon business intelligence analyst interview (SQL round) on tuesday. Can someone tell me what are the kind of sql questions asked in the interview. Also is there...

Status: 9+ yrs Experience, Currently working as Sr. Data Engineer for Major Video Streaming Platform. Position: Senior Data Engineer (L6) at Amazon Location: Remote, USA Date: January, 2022 There was total 7 rounds of...

Amazon refused me after phone interview without any feedback I am contaminated with an idea to get hired at FAANG as a Data Engineer. Yesterday I had my phone interview with...

Revenue: customer_id (varchar), product_id (varchar), month_start_date (date), 2022-03-01 revenue_amt (decimal) 1. Display the top 10 revenue generating products for year 2020. select top 10 product_id , sum(revenue_amt) as total from Revenue where year(month_start_date) = 2020 group by product_id order...

The interview experience that people posted really helped me to nail the amazon DE interview and i think its my time to contribute to the community. I attended previously for...

Positon : Data Engineer 2, L5 Applied via Referral. Amazon I can\'t share the exact question, hence sharing abstract of it. Phone Screening : \tStarted interview with discussion about project. \tDesign Data Modeling question, based...

I had an interview Amazon for L5 data engineer.There were total 5 rounds of interview Phone Screen: Went well answered all questions (Above Average) Later i have received call from amazon HR...

Phone Interview: 1. Introduction (what did you do?) 2. LP questions x 2 (invent and simplify, something else I can\'t remember) 3. SQL questions x 5: \t For all questions I...

Design an analytics system. 1. The input to the system is fed from another service and contains Personally Identifiable Information(PII) such as email,name etc.. 2. The input comes in the form of...

Amazon WoW is a networking platform for all women engineering students in India that connects them to Amazon leaders, recruiters, and the broader Amazon community.Online t...

Hello All, Hope you are all gearing up for your upcoming interviews. This is going to be a lengthy post so apologies for that. But I wanted to make sure...

Phone Screen 1: 1 hour interview (Technical) 30 mins project discussion and the current technologies from the project SQL : 1. https://leetcode.com/problems/employees-earning-more-than-their-managers/ 2. given table: \t \t \t resultant table: \t 3. dont remember the exact...

customer_id event_date status credit_limit 1 1/1/2019 C 1000 1 1/5/2019 F 1000 1 3/10/2019 1000 1 3/10/2019 1000 1 8/27/2019 L 1000 2 1/1/2019 L 2000 2 1/5/2019 2500 2 3/10/2019 2500 3 1/1/2019 S 5000 3 1/5/2019 6000 3 3/10/2019...

Interviewed on Feb-23 2021 United States 1) How do you rate your SQL skill in the range of 1 to 10? 2) LP question 3) What is Fact and Dimensions tables? 4) He showed...