← Back to experiences
[ OK ] Loaded —
[ INFO ]
$ cd
$ ls -lt
01
02
03
04
05
$ ls -lt
01
02
03
04
05
user@intervues:~/experiences/…$
Level: Senior-Level
Round: Full Journey · Type: Multiple Types · Difficulty: 5/10 · Duration: 360 min · Interviewer: Unfriendly
Topics: SQL, Data Modeling, ETL, Behavioral
Location: San Francisco Bay Area
Interview date: 2018-10-01
I had a full interview journey for a Data Engineer role. Initially, a recruiter contacted me on LinkedIn for a Senior Engineer/Lead position, but I felt unprepared. I was contacted again in August for a Data Engineer role, and I scheduled a phone interview.
Round 1 (Phone Screen): The first phone screen was with an interviewer of Indian descent and an observer. I was asked 2-3 SQL questions and one coding question. I failed to fully answer the coding question, but later realized it was a question I had seen before. I received feedback that my performance wasn't great, but I was given a second chance with a longer interview.
Round 2 (Phone Screen): The second phone screen was with a male interviewer of Chinese descent. I answered around 5-6 SQL questions and 4-5 coding questions. The questions were easier than the first round, and I was scheduled for an onsite interview.
Onsite Interview: The onsite interview consisted of one round of data modeling, two rounds of ETL, and one behavioral round. The content aligned with the provided prep materials. There were no direct coding questions during the onsite, but I was asked to write SQL and Python code to calculate metrics based on the data model I designed during the case study.