Data Interview Questions

132,954 data interview questions shared by candidates

Product questions heavily focused on FB products. How would you measure success of a new product? SQL assignment was to write a query which computes conversion rates for 2 products given the log of users actions with type of action for each product type.
avatar

Data Scientist

Interviewed at Meta

3.5
Sep 23, 2017

Product questions heavily focused on FB products. How would you measure success of a new product? SQL assignment was to write a query which computes conversion rates for 2 products given the log of users actions with type of action for each product type.

Data Model: LinkedIn data model - model for 1st degree connection Python: 1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion) 2. Find the number of words in a sentence /avg length of word SQL On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries 1. Count of stores in OR state with area_sqft > 25000 2. avg number of Female Customers group by state 3. Customer FirstName, Last Name and count of unqiue products purchased by state followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
avatar

Senior Data Engineering Manager

Interviewed at Meta

3.5
Aug 26, 2020

Data Model: LinkedIn data model - model for 1st degree connection Python: 1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion) 2. Find the number of words in a sentence /avg length of word SQL On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries 1. Count of stores in OR state with area_sqft > 25000 2. avg number of Female Customers group by state 3. Customer FirstName, Last Name and count of unqiue products purchased by state followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))

Viewing 1151 - 1160 interview questions

Glassdoor has 132,954 interview questions and reports from Data interviews. Prepare for your interview. Get hired. Love your job.