I applied through a recruiter. I interviewed at Amazon (Seattle, WA) in Jan 2022
Interview
Recruiter reached out to me for a data engineer position.
The next step was a one hour tech screen.
Tech screen was cloud experience, scenario based data pipeline questions and coding question.
Next step was the full loop split over 2 days.
lot of behavior questions (LP) and coding both sql and python.
Got offer after 4 days.
Interview questions [1]
Question 1
1. Lot of Questions on leadership principles, have more than one example for each principle.
2. 1 round SQL ( windows + subquery ) medium to hard in leetcode.
3. 1 round Python( 3 questions) ( lists, strings, recursion, dictionaries)
4. Data pipeline build ( scenario based)
applied through website, recruiter reached out for screening, didn't pass screening and that was it for the recruiter screening process and the interview in general.applied through website, recruiter reached out for screening, didn't pass screening and that was it for the recruiter screening process and the interview in general.
I applied online. I interviewed at Amazon (Austin, TX) in Mar 2022
Interview
Lots of support from the hiring manager and prep materials. Quick feedback. Interview was a mix of behavior situations like a time you stuck to your guns against management when you knew you were right. Stuff like that. And also technical questions mostly about data modelling. How would you handle a table that is too big?
Interview questions [1]
Question 1
Find the time period when the most people were online. time online given in seconds. In either Python or SQL
person time_loggon_on time_online
A 2022-04-04 12:00:00 8000
B 2022-04-04 14:00:00 2000
C 2022-04-04 13:30:00 4000