I applied through an employee referral. The process took 2 weeks. I interviewed at LinkedIn
Interview
2 phone rounds, on site interview loop. Great recruiter who explained the status, provided feedback, and walked me through the next steps as well as how I should prepare for those next steps
Interview questions [1]
Question 1
Using a set of tables, how would we find out whether users have a certain feature on or off?
I applied through a recruiter. I interviewed at LinkedIn (Sunnyvale, CA) in Apr 2019
Interview
A recruiter reached out to me on LinkedIn(!) regarding DS roles. I spoke to him on the phone - standard HR round, finding best fit. I was told there will be two more phone screens - one SQL coding + another case study based. If I cleared them, next step is on-site. I spoke to one of the hiring managers in the DS team for the first coding exercise. A brief mutual intro and she said she will ask one or two SQL queries depending on time. 45 minutes was set for this. She started with a SQL question regarding LI page views data - how to gather info regarding activity of crawlers (probably not the right name, but I forget what she exactly used). I started writing the code and took almost all remaining time, but I could sense she wasn't happy with my answer. Not surprisingly, I never heard back from them :)
Interview questions [1]
Question 1
There is a table of page view data. Two columns: Member ID and time stamp. You can assume this is for a 24 hour period. Members vs. guests/visitors are differentiable via ID's. Have to come up with a method for determining which all activities are crawler related (and not my members) and write a query for the same as well.
I applied through an employee referral. The process took 4 weeks. I interviewed at LinkedIn (San Francisco, CA)
Interview
The process is a call with the recruiter, two phone screens and then an onsite. I'm still in the process, I just wanted to say: watch out for who you get paired with. The recruiter I spoke with was the rudest recruiter I've chatted with during any interview. Very curt.
Interview questions [1]
Question 1
First tech screen is technical and second is problem solving.