Current Position: Data Engineer | Top Consulting Firm (MBB)
YOE: 4.2 years
I went through a typical process at Google. I have applied through a referral and recruiter reached out to me within a week.
The process started in Mid October 2020
Interview Process:Round 1 (Recruiter Screening): Recruited asked me few technical questions on SQL and DSA. She walked me through the details around the position and learned about my exp.
To shcedule next rounds, I asked for a month to prepare.
Round 2 (Phone Screen): This round was conducted by two interviewers, one of them is just the observer and the other one was leading the interview. This round lasted for 1 hr.
The interviewer has mixed set of questions on the below topics:
- Big Data and Distributed Computing Concepts
- Data Modeling (Asked me to design a data model of random movie ticket booking application)
- SQL
- Coding (LC easy)
After 2 days, I got a revert from my recruiter that the feedback was positive and they would like to move for the onsite rounds. I asked for two week for preperation and the recruiter was okay with that.
Onsite 1st Interview (Coding) : I was asked LC medium level coding question that I need to solve in 45 mins. I was not able to come-up with the optimal solution but provided O(n) solution.
Onsite 2nd Interview (System Design): I was asked a system design question which was mostly related to designing the archetecture for distributed system for one of the analytical applications (Won't be able to provide exact details due to NDA).
Then he asked some ETL concepts and one troubleshooting question.
After few days I got a feedback from the recruiter that my feedback is positive but they want to re-assses my coding round again. I asked for a week time to prepare.
Onsite 3rd Interview(Coding): I was given LC medium level question and this time I was able to come up with the optimal solution within time.
Onsite 4th Interview(Googlyness): This was a hiring manager round with a mix of tech and non tech related questions.
On tech side I was asked around 5 SQL questions from the datamodel they have provided and 2 troubleshooting questions.
Non-Tech side I was asked typical behavioral questions.
Pereperation
LC questions: 464 (50% Easy 50% medium)
Topics Covered: Strings, Arrays,Hashmaps, Linkedlist,Trees, BFS,DFS, Stacks, Queues, Binary Search
System Design:
Verdict: : Rejected in Hiring Manager Round.