Interviews:

Online Assessment: Hackerrank (2 hours)

• 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 (1 hour)

Two interviewers joined the call from the hiring team, Optimization of code/queries is expected. So always strike for the optimal solution

• 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.

On Site Interviews

After getting the comprehensive feedback from Round 0, got a call from the HR for on-site interviews. Decided on the date for the interviews (usually one day in between Tuesday to Thursday)
Each interview was one hour

Round 1: DSA (1 hour)

• 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)

Round 2: Data Manipulation (1 hour)

• 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)

Round 3: Systsem Design / Data Architecture (1 hour)

• 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 optimize it for querying
• We discussed the scenario and multiple corner cases and how to fix those in data architecture.

It was again 7/10

Round 4: Technical Discussion (1 hour)

• 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

Round 5: Hiring Manager (1 hour)

• 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 depends on it, So I am never very confident on it. So again 7/10

So Overall I would say it was 7.5/10, I might be under-estimating because of the hints I have received from the interviewers, let's wait and see how things turn out.

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