Amazon Data Engineer II Phone Interview Experience
- Result
- Rejected
- Posted
- 14 Dec 2024
Summary
I recently interviewed for a Data Engineer II role at Amazon. After successfully completing the online assessment which included SQL MCQs and coding questions, I proceeded to a phone interview. This round involved two SQL and two Data Structures & Algorithms questions, but unfortunately, I was rejected at this stage.
How it went
I started my application journey for the Data Engineer II position at Amazon through their careers page. I was soon shortlisted for an online assessment. This assessment comprised 20 multiple-choice questions focusing on MySQL and ETL concepts, along with four coding questions – two easy and two medium SQL problems. After clearing the online assessment, I received an invitation for a phone interview. During the phone interview, I faced two SQL questions and two Data Structures & Algorithms questions. Despite my efforts, I was unfortunately rejected after this round.
Questions asked (4)
- 01
Users Who Changed City Multiple Times
Data Structures & Algorithms
Given a table with columns
user,frmdt,todt, andcity, find users who changed their city more than 3 times in the last year. - 02
Distinct Connected City Pairs
Data Structures & Algorithms
Given a table with
sourceanddestinationcolumns, print distinct pairs of connected cities. For example:
Output:Source Destination
a b
b a
c b
b c
d e
a b
b c
d e
- 03
Merge Two Sorted Arrays
Data Structures & Algorithms
Merge two sorted arrays.
- 04
Smallest Missing Positive Integer
Data Structures & Algorithms
Find the smallest missing positive integer in an array containing elements from 1 to n.