Online Assessment: Hackerrank
Questions:
- Two Leetcode Medium questions on DSA
- Two SQL medium questions on SQL
I was able to solve all 4 within the time with all test-cases passed.
Round 0: Telephonic Screening
Questions:
- One Leetcode Medium question on DSA (with follow ups)
- One SQL Medium question on window/rank (with follow ups)
It went well, so I was certain that I will get a call back.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 1: DSA
Questions:
- Leetcode medium question (top k elements) with optimal approach
- Scenario based question where the choice of data structure was evaluated and complexities of various use-cases within the scenario
It went well in my opinion (7/10).
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2: Data Manipulation
Questions:
- Two Scenarios with different schema of datasets.
- Multiple questions on each scenario, mostly involved timestamps and ranks
- Need to solve each use case with optimized SQL Queries or pyspark
It was also good in my opinion (8/10).
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3: System Design / Data Architecture
Questions:
- End to End data system design with different use cases
- ETL pipelines and data storage was the main focus
- How the data will be stored and how can be optimized for querying
- We discussed the scenario and multiple corner cases and how to fix those in data architecture.
It was again 7/10.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 4: Technical Discussion
Questions:
- We discuss technical projects
- Challenges faced while working on the current project and how we fixed it
- Multiple behavioral/technical questions related to project planning and feature designing/implementation
It was again 8/10.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 5: Hiring Manager
Questions:
- Behavioral questions
- Projects and skills discussions
- Multiple back and forth communication regarding how things work at LinkedIn etc.
- Why LinkedIn? Aspirations and motivation for choosing LinkedIn?
Hiring Manager rounds are crucial and tricky, as most of the interview results depend on it, so I am never very confident on it. So again 7/10.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Timelines
- OA: Feb 11, 2025
- TPS: Feb 18, 2025
- On Site: Feb 25, 2025
- Date of Posting: Mar 01, 2025
- Current Status: Waiting for the final decision