Amazon Data Engineer Interview Questions
58+ questions from real Amazon Data Engineer interviews, reported by candidates.
Round Types
Top Topics
Questions
Amazon interview
Recently gave telephonic round for Data engineer position. Interview went well with couple of LP questions , scenario questions and SQL questions. It been 5 days and no response from...
I just did 2nd round of amazon interview for data engineer position. They asked me leetcode hard SQL problem 262. Trips and Users. I was able to do this problem,...
Find the departments having average salary greater than 500. SQL 2. Given Employees table, the age of employees have been set incorrect. The age of 2nd row is 1st row,...
Amazon recent BI SQL interview question
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...
Amazon | Data Engineer
Initial Phone Screen . Interviewer was super helpful. Nice Experience Behaviourial : 4 Leadership Question a. Tell me when you said no to customer and how you handle it b. Tell time when...
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
Amazon BIE Interview Prep
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...
Hi Everyone! While preparing for my data engineering intern interview at Amazon, I found very little information about the rounds and what questions are asked. So I decided to write...
Data Engineer | Amazon | Interview call | L4
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...
Radiomics | OA 2023
Hi folks! Recently, I tried to pass an interview in Radiomics. Here is the task that they asked to solve. Is anybody able to solve it? __ ## Introduction The task is to **build a...
Amazon BI analyst interview questions
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...
Hello Guys, I have interviews coming up in next week for the role of Data Engineer Intern at Amazon. Can anyone please share their intereview experience so that I can get...
Amazon | Senior Data Engineer | USA | Jan 2022 | [Offer]
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...
Waitlisted by Amazon for Data Engineer Intern 2022 position
Has anyone been placed on Amazon\'s waitlist for the post of Data Engineer Intern 2022? If yes, did anyone of you hear back and when after being waitlisted? I just...
Amazon | Data Engineer | phone call interview | L4
3 SQL 1 Python , a lot of data warehouse problem and 1 behavior question. 1 hour 1. pretty simple, group by having 2. deep dive, but i think i didn\'t get...
Amazon | DE | Dubai | Reject
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...
Amazon BIE L5
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...
What Amazon Looks for in Data Engineer Interviews
Amazon Data Engineer interviews are calibrated against the level and scope expected of the role. Across 58+ verified candidate reports on LeakCode, the consistent signals interviewers look for: clear problem decomposition before coding, explicit complexity reasoning, structured handling of edge cases, and the ability to articulate trade-offs between two reasonable approaches.
The discriminator between candidates who advance and candidates who do not is rarely the final correctness of the solution. It is the path to the solution: did you ask clarifying questions, did you state your approach before coding, did you handle edge cases without prompting, and did you communicate your reasoning throughout. Reports tagged "no hire" frequently cite a working solution with poor communication; reports tagged "strong hire" cite clear thinking even when the final solution was incomplete.
How To Use This Question Set
Real interview reports are a calibration tool, not a memorization target. Companies update their question pools every 2-4 months; memorizing exact problems risks misleading you when the interviewer uses a variant. The high-leverage use: identify the patterns that appear repeatedly in Amazon Data Engineer reports, practice those patterns on similar (not identical) problems, and use the reports to understand the interviewer's typical follow-up depth.
Filter the questions below by round type, difficulty, and recency. Focus first on reports from the past 6-12 months; older reports may reference questions that have since rotated out of Amazon's pool. Reports tagged with quantified difficulty (e.g., "medium-hard") are higher-signal than reports without difficulty tags.
Round-by-Round Expectations
Amazon Data Engineer loops typically span 4-6 rounds across phone screens and on-site or virtual on-site interviews. The structure varies by company: some run 1 recruiter screen + 1 technical phone + 3-4 on-site rounds; others run 1 recruiter screen + 1 OA + 4-5 on-site rounds. The recruiter screen is logistics and culture-light; the technical phone screen is medium-difficulty coding; the on-site loop covers coding, system design (at L4+ levels), and behavioral rounds.
Each round is designed to surface a specific signal. Coding rounds: correctness, code quality, complexity reasoning, communication. System design rounds: requirements clarification, design judgment, operational thinking. Behavioral rounds: ownership scope, leadership, ambiguity tolerance, conflict navigation. Strong candidates explicitly hit each signal dimension out loud during the round; weak candidates focus only on solving the prompt.
Common Interview Mistakes At This Combination
Reports tagged "no hire" at Amazon Data Engineer commonly cite: jumping into code without clarifying requirements, coding silently for 10+ minutes without verbalizing approach, missing edge cases (empty input, single element, very large input, overflow), and producing a working solution that the candidate cannot explain or refactor when probed. Strong candidates avoid these patterns by following a consistent template: clarify, verbalize approach, code with narration, test with examples.
Behavioral and design rounds have their own failure modes. Behavioral: stories that use "we" instead of "I" diluting individual signal, stories with no quantified outcome, defensiveness when probed about failure. Design: not asking clarifying questions, not stating requirements out loud, designing for a single server when the prompt clearly implies scale, ignoring operational concerns (deployment, monitoring, rollback). These show up in roughly half of Amazon Data Engineer interview retrospectives on LeakCode.
See All 58 Amazon Data Engineer Questions
Full question text, answer context, and frequency data for subscribers.
Get Access