Status: Experienced Data Engineer
Position: Data Engineer at Amazon
Location: Dublin Ireland
Date: April 7 2022

Phone Interview 1

Generic Question :

• What are your career goals
• Why amazon
• Career Summary

Python Question (basic) :

• Write a class that initalizes string and function inside the class to return the string
• Given a string with mixed upper case and lower case letter, arrange the letters in the order with lower case first followed by upper case

SQL question (easy): (cannot remember the dataset):

• Join (inner and self)
• group by
• rank aggregate

Pipeline and infra design :

• Design a ETL pipeline for the ticketing system (provided the json data as sample input)
• Desgin and consideration for the Infrastructure for the ETL pipeline
• Data model for the ingested data
• Generate reporting query from the data model

Interviewer was very friendly and the tone was very light of the interview, felt at ease. Time was little tight.