Professional networking platform with rich data and ML-driven recommendations.
4 Rounds
~21 Days
Hard
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
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
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
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
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
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
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
Data Engineer
•
Coding
•
medium
Write a SQL query to identify the second highest salary within each engineering department at LinkedIn.
#Window Functions
#Ranking
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.