Amazon Data Engineer Interview Questions

Review this list of 25 Amazon Data Engineer interview questions and answers verified by hiring managers and candidates.

+ Share interview

Asked at Amazon, Adobe, Apple + 10 more • a year ago
Calculate the trapped rainwater between bars in a given array.
IDE
Hard
Data Engineer
Data Structures & Algorithms
+4 more
13 answers
+10
"from typing import List def traprainwater(height: List[int]) -> int: if not height: return 0 l, r = 0, len(height) - 1 leftMax, rightMax = height[l], height[r] res = 0 while l < r: if leftMax < rightMax: l += 1 leftMax = max(leftMax, height[l]) res += leftMax - height[l] else: r -= 1 rightMax = max(rightMax, height[r]) "
Anonymous Roadrunner - "from typing import List def traprainwater(height: List[int]) -> int: if not height: return 0 l, r = 0, len(height) - 1 leftMax, rightMax = height[l], height[r] res = 0 while l < r: if leftMax < rightMax: l += 1 leftMax = max(leftMax, height[l]) res += leftMax - height[l] else: r -= 1 rightMax = max(rightMax, height[r]) "See full answer
Data Engineer
Data Structures & Algorithms
+4 more
Asked at Amazon • 4 years ago
What is the difference between OLTP and OLAP?
Data Engineer
Technical
+1 more
1 answer
"OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"
Nikunj V. - "OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"See full answer
Data Engineer
Technical
+1 more
Asked at Amazon • 2 years ago
Design a data pipeline that updates hourly and powers a dashboard showing the most common Alexa user requests, broken down by country.
Data Engineer
Data Pipeline Design
Add answer
Data Engineer
Data Pipeline Design
Asked at Amazon, Adobe, Apple + 1 more • a month ago
Top k frequent elements
Data Engineer
Data Structures & Algorithms
+3 more
1 answer
"Leetcode 347: Heap + Hashtable Follow up question: create heap with the length of K instead of N (more time complexity but less space )"
Chen J. - "Leetcode 347: Heap + Hashtable Follow up question: create heap with the length of K instead of N (more time complexity but less space )"See full answer
Data Engineer
Data Structures & Algorithms
+3 more
Asked at Amazon • 2 years ago
Given an array of children’s ratings, assign at least one candy to each child so that higher-rated children get more than their neighbors, and return the minimum total candies needed.
Data Engineer
Data Structures & Algorithms
+3 more
Add answer
Data Engineer
Data Structures & Algorithms
+3 more