Professional networking platform with rich data and ML-driven recommendations.

4 Rounds ~21 Days Hard

Start Mock Interview

The Interview Loop

Recruiter Screen (30 min)

Standard fit check, behavioral questions, and resume overview.

Technical Loop (3-4 Rounds)

Deep dive into domain knowledge, coding, and system design.

Interview Question Bank

All Roles Data Engineer 7 Data Scientist 5 Full Stack Engineer 2

All Topics Algorithms 78 System Design 74 Culture Fit 33 Leadership 17 SQL 14 Machine Learning 12 Product Strategy 10 Networking 7

Data Engineer • Coding • medium

Write a SQL query to find the top 3 job postings with the highest application rate (applications / views) in the last 7 days. Only include jobs with at least 100 views.

#Aggregations #Filtering #Sorting

Practice

Data Engineer • Coding • hard

Write a SQL query to calculate the 7-day rolling average of profile views for each user.

#Window Functions #Time Series

Practice

Data Engineer • Coding • medium

Given a 'connections' table and a 'messages' table, write a SQL query to find the percentage of users who connected with each other but never sent a message.

#Joins #Subqueries #Math

Practice

Data Engineer • Coding • medium

Write a SQL query to find members who applied to jobs at companies where they have at least one 1st-degree connection.

#Complex Joins #Filtering

Practice

Data Engineer • Coding • hard

You have a table of user activity logs. Write a SQL query to sessionize the data, where a new session starts if there is a gap of more than 30 minutes between activities.

#Window Functions #Sessionization #CTEs

Practice

Data Engineer • Coding • medium

Write a SQL query to find the cumulative sum of premium subscriptions purchased per month for the year 2023.

#Window Functions #Aggregations

Practice

Data Engineer • Coding • medium

Write a SQL query to identify the second highest salary within each engineering department at LinkedIn.

#Window Functions #Ranking

Practice

Data Scientist • Coding • medium

Write a SQL query to find the top 3 most requested skills for Data Science job postings in the last 30 days.

#Window Functions #Aggregations #Date Functions

Practice

Data Scientist • Coding • medium

Given a 'connection_requests' table, write a query to calculate the daily connection acceptance rate.

#Ratio Calculations #Group By #Case Statements

Practice

Data Scientist • Coding • medium

Write a SQL query to find the percentage of users who sent a LinkedIn message but did not receive a reply within 24 hours.

#Self Joins #Time Intervals #Left Joins

Practice

Data Scientist • Coding • medium

Given a table of job applications, write a SQL query to compute the 7-day rolling average of applications per job category.

#Window Functions #Rolling Averages #Time Series

Practice

Data Scientist • Coding • hard

Write a SQL query to find all 2nd-degree connections for a given user ID.

#Graph Traversal in SQL #Self Joins #Filtering

Practice

Full Stack Engineer • Technical • medium

Design a database schema for LinkedIn connections, handling states like pending, accepted, and blocked.

#Schema Design #SQL #Normalization

Practice

Full Stack Engineer • Technical • medium

Write a SQL query to find the top 3 universities with the highest number of alumni currently working at LinkedIn.

#SQL #Aggregation #Joins

Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now