amazon logo
Amazon· Data Engineer II

Amazon Data Engineer II Phone Interview Experience

Result
Rejected
Posted
14 Dec 2024
246 reads

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)

  1. 01

    Users Who Changed City Multiple Times

    Data Structures & Algorithms

    Given a table with columns user, frmdt, todt, and city, find users who changed their city more than 3 times in the last year.

  2. 02

    Distinct Connected City Pairs

    Data Structures & Algorithms

    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
    Output:
    a  b
    b c
    d e

  3. 03

    Merge Two Sorted Arrays

    Data Structures & Algorithms

    Merge two sorted arrays.

  4. 04

    Smallest Missing Positive Integer

    Data Structures & Algorithms

    Find the smallest missing positive integer in an array containing elements from 1 to n.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Amazon recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!