Round 1: INITIAL SCREENING
Questions:
- HR explained about the role and asked to go through each requirement, answering honestly about knowledge of each technology mentioned.
- Tech team Fitment round with DE Team Manager:
- Questions based on data engineering tech stack mentioned in the resume, including:
- Spark, Hadoop, MapReduce, Hive, SQL, Spark Streaming, SCDs, etc.
- DE Pipeline requirement gathering: What questions do we, as data engineers, need to ask when developing a data pipeline for a particular use case?
- Questions based on data engineering tech stack mentioned in the resume, including:
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2: VIRTUAL ONSITE INTERVIEWS
Questions: Tech Round 1 (60-75 minutes) with a Senior Data Engineer:
- Data pipeline projects - end to end explanation and reasoning for chosen approaches.
- Spark Streaming - Possible issues and resolutions.
- Spark optimisations.
- Scenario-based pipeline design for batch vs. streaming data requirements.
Tech Round 2 (30-45 minutes) with a Senior Data Engineer:
- SCD.
- Data Modelling.
- 2 Leetcode Easy-Medium DSA questions related to Arrays and Strings.
- 2 SQL Questions.
Stakeholder Management Round (45 minutes) with a Product Owner:
- Behavioral Questions.
- Discussed past situations demonstrating leadership, team spirit, conflict resolution, and collaboration.
- Questions about interacting and effectively communicating with product teams and business stakeholders.
Overall Tech Fitment Round (45 minutes) with Data Engineering Senior Director:
- SCD.
- Spark Streaming.
- Spark optimisations.
- Behavioral questions.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3: FINAL CONFIRMATION CALLS
Questions: Call with HR (30 minutes):
- HR wanted to ensure commitment to the role after accepting the offer letter, discussing loyalty to previous employers.
Call with DE Team Manager (30 minutes):
- Similar to the HR call, the manager sought confidence that the candidate would not quit after accepting the offer.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
RESULT: OFFER ROLLED OUT. I accepted it and joined the company.
Hope this post is of some help to the data engineers out there. Please feel free to ask any doubts!
Good Day!