Here is what the Amazon Data Engineer interview process looked like.
Amazon Data Engineer job interview summary
How it gets started: internal referral from a former colleague.
Job Level: Mid
Team: Alexa
Years of Experience: 4 years experience
Degree: M.S in computer science
Offer: Yes
TC: ~260 USD
Location: Seattle, WA
Interview process: 6 weeks
Preparation: 3 months
Has a job: yes
Decide to join: N/A
Amazon Data Engineer Job Interview Round 1: recruiter chat
Basic information, most impressive project, team intro, past experience.
Amazon Data Engineer Job Interview Round 2: SQL coding
- Write a function to return the cumulative spend of each customer (similar to SQLPad coding question #113);
- Top 3 products vs. bottom 3 products (similar to SQLPad coding question #94)
Amazon Data Engineer Job Interview Virtual Onsite Round 1: data engineering and big data concept
- How to debug a long-running SQL query?
- Experience in Spark, what is sharding? How to partition data into different parquet files?
- What python libraries have you used to work with S3? What about redshift? Have you ever used boto3?
Amazon Data Engineer Job Interview Virtual Onsite Round 2: ETL
- Quick intro about yourself;
- Design a data pipeline for a user report dashboard that shows the need to know top Alexa user requests by different countries every hour.
Amazon Data Engineer Job Interview Virtual Onsite Round 3: Data Modeling
- What is star schema, what are its pros and cons?
- What is a dimension table? What is a fact table?
- Design the backend data house of a ridesharing app?
Amazon Data Engineer r Job Interview Virtual Onsite Round 4: leadership
- Tell me about a time you have to meet a tight project deadline?
- Follow up: do you have a plan b, and why?
- Have you ever failed at a project? Tell me about your biggest failure.
- Follow up: what would you have done differently?
Amazon Data Engineer job offer
It took about two weeks to hear back from the recruiter. Jason was initially given an oral offer, followed by a written offer shortly after a successful negotiation (10% increase on base and RSU, 15% on sign-on bonus).
Get mentored and become 100% job interview ready for your Amazon Data Engineer Job interview, learn directly from former FAANG hiring managers, BOOK YOUR SESSION TODAY.