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 Senior Data Engineer Interview Questions and Answers

Updated 8 May 2024

Amazon Senior Data Engineer Interview Experiences

2 interviews found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Apr 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Tell me about yourself; Projects done; What is Columnar format file in Spark; Internals of Spark, Difference between OLAP and OLTP; About Datawarehouse- facts, dimensions
  • Ans. 

    I am a Senior Data Engineer with experience in various projects involving columnar format files in Spark, understanding Spark internals, OLAP vs OLTP, and data warehousing concepts.

    • Projects: Developed ETL pipelines using Spark for processing large datasets, implemented data quality checks, and optimized query performance.

    • Columnar format file in Spark: It stores data in columnar format to improve query performance by re...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Coding Test 

Find duplicates in a list

Interview Preparation Tips

Interview preparation tips for other job seekers - Leetcode easy to medium questions, data warehousing concepts

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more

Senior Data Engineer Jobs at Amazon

View all

Interview questions from similar companies

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: Resume Shortlist
Experience: You need to submit your CV and they shortlist you on this basis.Fast and accurate coding.
Tips: Clearly specify any technical achievement.

Round: Coding
Experience: You are given 4 hours to solve a few algorithmic questions.Start practicing for this from sometime earlier.
Tips: There are puzzles available on the Facebook page.

Round: Technical Interview
Experience: Three interviews. All almost exclusively technical with 1-2 HR questions.
The questions are mainly algorithmic in nature and you need to code online while talking to them.
Tips: Be as accurate and clean with your code as possible.

General Tips: Be creative while answering the questions. They might ask you questions like 'What changes would you want to make to Facebook?'.
Prepare algorithmic questions for the interviews. Most companies like Facebook, Google, Microsoft and others focus on this.
Technical projects or internships will be beneficial.
Qualifying for or winning programming contests like overnite is very beneficial. Involvement in Social/Cultural activities or sports is not really essential.
Skill Tips: Being good at writing fast and correct code in any language helps a lot.
Skills: Programming
College Name: IIT KHARAGPUR

Interview Questionnaire 

8 Questions

  • Q1. Given two “ids” and a function getFriends(id) to get the list of friends of that person id, write a function that returns the list of mutual friends
  • Ans. 

    Function to return mutual friends given two ids and getFriends(id) function

    • Call getFriends(id) for both ids to get their respective friend lists

    • Iterate through both lists and compare to find mutual friends

    • Return the list of mutual friends

  • Answered by AI
  • Q2. Given an “id” and a function getFriends(id) to get the list of friends of that person id, write a function that returns the list of “friends of friends” in the order of decreasing number of mutual friends,...
  • Ans. 

    Function to return list of friends of friends in decreasing order of mutual friends

    • Use a set to store all friends of friends

    • Iterate through the list of friends of the given id

    • For each friend, iterate through their list of friends and count mutual friends

    • Sort the set of friends of friends by decreasing number of mutual friends

  • Answered by AI
  • Q3. Given a number of time slots – start time and end time,“a b”, find any specific time with the maximum number of overlapping. After solving the problem I had to prove my solution
  • Ans. 

    Given time slots, find a specific time with maximum overlap. Prove solution.

    • Create a list of all start and end times

    • Sort the list in ascending order

    • Iterate through the list and keep track of the number of overlaps at each time

    • Return the time with the maximum number of overlaps

    • Prove solution by testing with different input sizes and edge cases

  • Answered by AI
  • Q4. Given an array of Integers, find the Longest sub-array whose elements are in Increasing Order
  • Ans. 

    Find the longest sub-array with increasing order of integers.

    • Iterate through the array and keep track of the current sub-array's start and end indices.

    • Update the start index whenever the current element is smaller than the previous element.

    • Update the end index whenever the current element is greater than or equal to the next element.

    • Calculate the length of the sub-array and compare it with the longest sub-array found s

  • Answered by AI
  • Q5. Given an array of Integers, find the length of Longest Increasing Subsequence and print the sequence.
  • Ans. 

    Find the length of longest increasing subsequence and print the sequence from an array of integers.

    • Use dynamic programming to solve the problem

    • Create an array to store the length of longest increasing subsequence ending at each index

    • Traverse the array and update the length of longest increasing subsequence for each index

    • Print the sequence by backtracking from the index with the maximum length

    • Time complexity: O(n^2)

    • Exam...

  • Answered by AI
  • Q6. Given a Sorted Array which has been rotated, write the code to find a given Integer
  • Ans. 

    Code to find a given integer in a rotated sorted array.

    • Use binary search to find the pivot point where the array is rotated.

    • Divide the array into two subarrays and perform binary search on the appropriate subarray.

    • Handle edge cases such as the target integer not being present in the array.

  • Answered by AI
  • Q7. You have a number of incoming Integers, all of which cannot be stored into memory. We need to print largest K numbers at the end of input
  • Ans. 

    Use a min-heap to keep track of the largest K numbers seen so far.

    • Create a min-heap of size K.

    • For each incoming integer, add it to the heap if it's larger than the smallest element in the heap.

    • If the heap size exceeds K, remove the smallest element.

    • At the end, the heap will contain the largest K numbers in the input.

  • Answered by AI
  • Q8. Implement LRU Cache
  • Ans. 

    LRU Cache is a data structure that stores the most recently used items and discards the least recently used items.

    • Use a doubly linked list to keep track of the order of items in the cache

    • Use a hash map to store the key-value pairs for fast access

    • When an item is accessed, move it to the front of the linked list

    • When the cache is full, remove the least recently used item from the back of the linked list and the hash map

  • Answered by AI

Interview Preparation Tips

Round: ONLINE CODING ROUND
Experience: Facebook visited our campus in July, 2012. We had an online coding round hosted on InterviewStreet. We were asked to solve just one problem. The given problem boils down to : Given a undirected graph, source and destination, write the code to find the total number of distinct nodes visited, considering all possible paths.
Tips: Those shortlisted had to fly to Delhi for a Personal Interview. There were four rounds of interview, each of 45 minutes. The questions were simple. But just solving the given problem wasn't enough.

There was much more interaction and short questions asked related to the problem

Round: Technical Interview
Experience: The above mentioned questions wer asked in the interview. For every solution I was asked to write the code on paper. The code should also include the implementation of the data structures used (I used heaps - so I was asked to implement heaps ). They are looking for someone with good problem solving skills and conceptually sound in data structures

College Name: BIT MESRA

Skills evaluated in this interview

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 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.

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

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

I appeared for an interview before Apr 2021.

Round 1 - Face to Face 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Medium

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.

  • Q1. 

    Kth Largest Element Problem Statement

    Given an array of distinct positive integers and a number 'K', your task is to find the K'th largest element in the array.

    Example:

    Input:
    Array: [2,1,5,6,3,8], K ...
  • Ans. 

    Find the Kth largest element in an array of distinct positive integers.

    • Sort the array in non-increasing order

    • Return the Kth element from the sorted array

    • Handle multiple test cases

  • Answered by AI
  • Q2. 

    Orange Rotting Problem Statement

    Consider a grid containing oranges. Each cell in this grid can hold one of three integer values:

    • Value 0: Represents an empty cell.
    • Value 1: Represents a fresh orang...
  • Ans. 

    The task is to determine the minimum time required for all fresh oranges to become rotten in a grid.

    • Create a queue to store the rotten oranges and their time of rotting.

    • Iterate through the grid to find the initial rotten oranges and add them to the queue.

    • Perform BFS by popping each rotten orange from the queue, rot adjacent fresh oranges, and add them to the queue with updated time.

    • Continue until the queue is empty, ke...

  • Answered by AI
Round 2 - Face to Face 

Round duration - 45 minutes
Round difficulty - Easy

This was a design round.

Interview Preparation Tips

Eligibility criteriaAbove 8 CGPAUber interview preparation:Topics to prepare for the interview - Design, Algorithms And Data Structures, Graph Theory, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewRejected

Skills evaluated in this interview

Amazon Interview FAQs

How many rounds are there in Amazon Senior Data Engineer interview?
Amazon interview process usually has 1 rounds. The most common rounds in the Amazon interview process are Coding Test and Technical.
How to prepare for Amazon Senior Data Engineer interview?
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, Data Analytics, Python, Analytical Chemistry and Cloud Computing.

Tell us how to improve this page.

Amazon Senior Data Engineer Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

Uber Interview Questions
4.2
 • 149 Interviews
Expedia Group Interview Questions
3.8
 • 76 Interviews
LinkedIn Interview Questions
4.3
 • 66 Interviews
OLX Interview Questions
3.8
 • 57 Interviews
Facebook Interview Questions
4.3
 • 52 Interviews
Groupon Interview Questions
3.1
 • 42 Interviews
Uplers Interview Questions
4.0
 • 41 Interviews
Fareportal Interview Questions
3.4
 • 30 Interviews
Yahoo Interview Questions
4.6
 • 29 Interviews
Airbnb Interview Questions
3.7
 • 23 Interviews
View all
Amazon Senior Data Engineer Salary
based on 78 salaries
₹18.1 L/yr - ₹66.4 L/yr
106% more than the average Senior Data Engineer Salary in India
View more details

Amazon Senior Data Engineer Reviews and Ratings

based on 2 reviews

3.5/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.5

Salary

3.0

Job security

3.5

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Data Engineer, JWO Tech

Bangalore / Bengaluru

5-10 Yrs

₹ 23.2-35 LPA

Senior Data Engineer , Amazon

Bangalore / Bengaluru

4-6 Yrs

₹ 28-45.5 LPA

Sr Data Engineer, AWS Data Platform

Bangalore / Bengaluru

3-7 Yrs

₹ 28-35 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 - ₹36.7 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