Amazon Data Engineer II Phone Interview Experience
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.
Full Experience
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.
Interview Questions (4)
Given a table with columns user, frmdt, todt, and city, find users who changed their city more than 3 times in the last year.
Given a table with source and destination columns, print distinct pairs of connected cities. For example:
Source Destination
a b
b a
c b
b c
d e
a b
b c
d e
Merge two sorted arrays.
Find the smallest missing positive integer in an array containing elements from 1 to n.