Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Amazon Team. If you also belong to the team, you can get access from here

Amazon Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Amazon Data Engineer Interview Questions and Answers for Freshers

Updated 6 Apr 2025

Amazon Data Engineer Interview Experiences for Freshers

2 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 28 Feb 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL - Given 2 tables with some nullls and asked to output the count of rows we get for all types of joins
  • Q2. Types of joins and explain cross join
  • Ans. 

    Types of joins in SQL include inner, outer, left, right, and cross join.

    • Inner join: Returns rows when there is a match in both tables

    • Outer join: Returns all rows when there is a match in one of the tables

    • Left join: Returns all rows from the left table and the matched rows from the right table

    • Right join: Returns all rows from the right table and the matched rows from the left table

    • Cross join: Returns the Cartesian produ

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Projects and impact

Interview Preparation Tips

Interview preparation tips for other job seekers - For Data Engineer Internship, they ask easy to medium DSA and sql questions. That is it. Be good with basics

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

It was a mix of 1 coding question and MCQ's on topics like python, SQL, Git, Computer Networks, Linux etc.

Round 3 - Interview round-1 

(2 Questions)

  • Q1. This round was about SQL, Python the interviewer gave a problem and asked to write SQL query and they tested my SQL skills on basic concepts.
  • Q2. The interviewer asked to write python code for basic problems. This round was lasted about 40-45 mins
Round 4 - Interview round-2 

(1 Question)

  • Q1. Again this round was focussed on my SQL skills the interviewer asked to write queries. SQL medium-hard level concepts. This lasted for 40-45 mins
Round 5 - HR 

(1 Question)

  • Q1. This was final round the interviewer asked about everything I mentioned in my resume, behavioural questions, situational questions etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with your basics.
Mention the skills which you are strong and confident in Resume.
Know your projects well.

Data Engineer Interview Questions Asked at Other Companies for Fresher

asked in LTIMindtree
Q1. If you want very less latency - which is better standalone or cli ... read more
asked in LTIMindtree
Q2. When a spark job is submitted, what happens at backend. Explain t ... read more
asked in LTIMindtree
Q3. How do you do performance optimization in Spark. Tell how you did ... read more
asked in Procore
Q4. What is Data Lake? Difference between data lake and data warehous ... read more
asked in Procore
Q5. Why do we need a data warehouse, why can't we store in the normal ... read more

Data Engineer Jobs at Amazon

View all

Interview questions from similar companies

I appeared for an interview before May 2021.

Round 1 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Easy

  • Q1. 

    Find the k-th Node from the End of a Linked List

    Given the head node of a singly linked list and an integer 'k', this problem requires you to determine the value at the k-th node from the end of the linke...

  • Ans. 

    To find the k-th node from the end of a linked list, iterate through the list to determine the size, then traverse again to reach the k-th node from the end.

    • Iterate through the linked list to determine its size.

    • Calculate the position of the k-th node from the end based on the size of the list.

    • Traverse the list again to reach the k-th node from the end.

    • Return a pointer to the k-th node from the end.

  • Answered by AI
Round 2 - Video Call 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Easy

High level System Design

  • Q1. Can you design a system like Uber, explaining the various components and architecture involved?
  • Ans. 

    Designing a system like Uber involves components like user app, driver app, server, database, and algorithms for matching and routing.

    • User app for booking rides and tracking

    • Driver app for accepting rides and navigation

    • Server for handling requests and communication between apps

    • Database for storing user, driver, and ride information

    • Algorithms for matching riders with drivers and routing

  • Answered by AI
Round 3 - HR 

Round duration - 45 minutes
Round difficulty - Easy

Basic HR questions

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Software Engineer in HyderabadEligibility criteriaAbove 7 CgpaUber interview preparation:Topics to prepare for the interview - Data Structures, React JS, JavaScript, DBMS, AlgorithmsTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Practise DSA/coding consistently
Tip 2 : Choose a tech stack and Make side hobby projects
Tip 3 : Give mock interviews for your preparation evaluation

Application resume tips for other job seekers

Tip 1 : Pointers about your current job responsibility
Tip 2 : Side Projects with Tech stack

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic Questions about core concept.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on core concepts and basic programs.

Interview Preparation Tips

Round: Test
Tips: Just try coding as much as you can in the four years of graduation.

Round: Interview
Experience: Three Coding Interview and a Behavioral Interview were conducted.
Tips: Try to get some prior knowledge about the company's infrastructure.w

General Tips: Practice as much problems as you can online or offline.
Skill Tips: Coding is the key for any software company.
Skills: Coding
College Name: IIT KHARAGPUR
Motivation: Its the best in business

Interview Questionnaire 

4 Questions

  • Q1. You are given a large array of n bits. Each bit is initially 0. You perform several operations of the type
  • Ans. 

    Solution to performing operations on a large array of bits.

    • Use bitwise operators to perform operations on individual bits

    • Use a loop to iterate through the array and perform the operations

    • Ensure that the array is large enough to accommodate all the bits

    • Consider using a data structure like a bitset for efficient bit manipulation

  • Answered by AI
  • Q2. Questions on Network programming
  • Q3. Questions on array,heap and binary trees
  • Q4. Round was both HR+Technical

Interview Preparation Tips

Round: Test
Experience: Questions can be found here:

-----/
Tips: Try to solve all 3.
Duration: 60 minutes
Total Questions: 3

Round: Technical Interview
Experience: First discuss the solution and then paper-code it.
Tips: Try to code without mistakes.

Round: Technical Interview
Experience: First, I was asked to discuss my project based on networking and then I was given a question on network programming
Tips: Pay attention on discussion

Round: Technical Interview
Experience: Provide the optimised solution and code it without any mistakes.

Round: HR Interview
Experience: Why linkedin?
What changes will you make in 6 months?
Internship project: Discussion and lot of common questions on that.
Basic Questions of C++ and Java

Skills: Data Structure, Core courses understanding, Algorithms
College Name: IIT GUWHATI

Skills evaluated in this interview

Interview Preparation Tips

Round: CODING ROUND
Experience: In the coding round there were 3 questions to be solved in about 3 hrs.

Round: HR Interview
Experience: Expect the usual crazy questions like "Why LinkedIn?" and if you are already placed, be ready to give a proper justification for "Why LinkedIn and not XYZ?" so on. Be cool, you need not be accurate. Be well prepared with your resume and expect questions from them.
Tips: For the interview, just be confident and have a good resume ready with you.

Round: Other Interview
Experience: Coding Interview:
Simple coding questions. Make sure you first explain the logic to them and then you may be asked to write the code for it on the board using any language of your choice. Syntax is not a big deal, but don't make any logical errors. They are very friendly and may suggest certain solutions of their own. Make sure you can grasp them quickly. Find faults in your own code before they find it. Always try to give the best optimal solution. In case you are unable to do so then suggest possible improvements.

Round: Other Interview
Experience: Design Interview:
Some people may find this round a bit uneasy. But this round tests how good you are at designing solutions to problems. Most of the candidates were asked to build an online gaming system. And then they keep adding extra constraints and ideas and see if you can integrate them to your design. Database knowledge may be tested. They may also ask questions pertaining to you projects listed in your resume.

General Tips: An updated LinkedIn account with decent connections. ;)
Skill Tips: Be very strong with your coding ability. Whenever you code, do follow some standard procedures and make the code look simple and structured. Whenever you solve a coding question make sure you answer it completely for all the test cases. Partial results will only indicate that there is something wrong with the logic. Try to solve a complete question rather than multiple questions with partial results.
College Name: NIT SURATHKAL

Interview Preparation Tips

General Tips: It might help in general to try to become a better developer at all times. One way to get good at it is to really enjoy what you do!Do random projects, use linux, Read Hacker News (-----/)  daily and wear hippie computer t-shirts (:-P) - Interviewers really LOVE talking about these, especially HR rounds (my HR interviewer was also a programmer).
College Name: NIT SURATHKAL

Interview Questionnaire 

3 Questions

  • Q1. Some question on KMP
  • Q2. Simulation Question
  • Q3. Topological Sort Question

Interview Preparation Tips

Round: Test
Experience: Simple
Tips: Online Coding Questions
Duration: 60 minutes

Round: Technical Interview
Experience: Moderately difficult
Tips: Thorough understanding of all the algorithms is required.

Round: Technical Interview
Experience: Easy
Tips: Need to start a question afresh without attacking it the way you have solved questions in the past

Round: Technical Interview
Experience: Easy/moderately difficult
Tips: The idea was not that easy to click.

Skills: Coding
College Name: IIT BOMBAY
Motivation: Facebook has revolutionised social networking.

I applied via Campus Placement and was interviewed in Dec 2016. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Given a 2d matrix with some D doors and W walls, we need fill distance matrix with minimum distance to the nearest door
  • Ans. 

    Given a 2D matrix with doors and walls, fill distance matrix with minimum distance to the nearest door.

    • Iterate through the matrix and find the doors

    • Use Breadth-First Search (BFS) to calculate the minimum distance from each cell to the nearest door

    • Update the distance matrix with the minimum distances

  • Answered by AI
  • Q2. Given a read-only array we want to find kth smallest element in unordered array with O(1) space
  • Ans. 

    Find kth smallest element in unordered array with O(1) space

    • Use the QuickSelect algorithm to partition the array and find the kth smallest element

    • Choose a pivot element and partition the array into two subarrays

    • Recursively partition the subarray that contains the kth smallest element

    • Repeat until the pivot element is the kth smallest element

    • Time complexity: O(n) average case, O(n^2) worst case

  • Answered by AI
  • Q3. Design question
  • Q4. Find friends of friend who already are not friends with you
  • Ans. 

    To find friends of friends who are not already friends with you, we can first find your friends and then their friends excluding yourself and your friends.

    • Get your list of friends

    • For each friend, get their list of friends

    • Exclude yourself and your friends from the final list of friends of friends

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: It started with an informal talk after he gave his introduction. We talked about the cyclone that was going to be there and what I did in my internship and my previous projects. Then we moved to questions. After solving both questions he asked if I had questions.
Tips: Just walk the interviewer through the solution you're proposing.

Round: Other Interview
Experience: He started with a design question with how to stream an image such that all clients see the same image at the same time. You need to take care of delays, network problems. He kept on adding new elements like compression, streaming, utc time related issues, client rendering delays and so on.

Round: Other Interview
Experience: This was bar-raiser round.

Skills: Design, Algorithms And Data Structures, Graph Theory
College Name: IIT Madras

Skills evaluated in this interview

Amazon Interview FAQs

How many rounds are there in Amazon Data Engineer interview for freshers?
Amazon interview process for freshers usually has 3-4 rounds. The most common rounds in the Amazon interview process for freshers are HR, Resume Shortlist and Coding Test.
How to prepare for Amazon Data Engineer interview for freshers?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Amazon. The most common topics and skills that interviewers at Amazon expect are Data Modeling, Python, Analytical Chemistry, PLSQL and SAP Business Intelligence.
What are the top questions asked in Amazon Data Engineer interview for freshers?

Some of the top questions asked at the Amazon Data Engineer interview for freshers -

  1. types of joins and explain cross j...read more
  2. Which techniques you would have used on a system you have worked in the past to...read more
  3. Data Warehousing and Big data related problems Data pipelines and ETL related Q...read more
How long is the Amazon Data Engineer interview process?

The duration of Amazon Data Engineer interview process can vary, but typically it takes about 2-4 weeks to complete.

Tell us how to improve this page.

Amazon Data Engineer Interview Process for Freshers

based on 2 interviews

Interview experience

4.5
  
Good
View more
Amazon Data Engineer Salary
based on 337 salaries
₹10 L/yr - ₹35 L/yr
102% more than the average Data Engineer Salary in India
View more details

Amazon Data Engineer Reviews and Ratings

based on 38 reviews

3.3/5

Rating in categories

3.3

Skill development

2.8

Work-life balance

3.7

Salary

2.2

Job security

3.0

Company culture

2.8

Promotions

3.1

Work satisfaction

Explore 38 Reviews and Ratings
Data Engineer, Ad Finance, Display Finance BI

Bangalore / Bengaluru

3-7 Yrs

Not Disclosed

Data Engineer

Bangalore / Bengaluru

1-4 Yrs

Not Disclosed

Data Engineer, MIDAS Digital Intelligence

Chennai

3-6 Yrs

₹ 13.5-60 LPA

Explore more jobs
Customer Service Associate
4.2k salaries
unlock blur

₹0.6 L/yr - ₹6.8 L/yr

Transaction Risk Investigator
3.1k salaries
unlock blur

₹2 L/yr - ₹6.1 L/yr

Associate
2.9k salaries
unlock blur

₹0.8 L/yr - ₹7 L/yr

Senior Associate
2.5k salaries
unlock blur

₹2 L/yr - ₹10.5 L/yr

Program Manager
2.2k salaries
unlock blur

₹9 L/yr - ₹37 L/yr

Explore more salaries
Compare Amazon with

Flipkart

3.9
Compare

TCS

3.7
Compare

Google

4.4
Compare

Netflix

4.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview