The process began with a basic HR screening, followed by a behavioral screening with the Hiring Manager.

Later, I received a pair coding test. I was informed that the primary focus was on my thought process, not solely on code execution. The test included five questions covering data modeling, SQL, and some basic algorithms.

I recall getting stuck on an algorithms question due to Python syntax, and the interviewer offered some assistance. The remaining questions were answered with correctly executing code.

A few days later, I received a thank-you call from HR, who informed me that I had not been able to solve all the questions. This was for a managerial position, evaluating a developer's mindset.

How would you design LinkedIn's data model?

• SQL
• Inner & outer joins
• Python list iterations