The rest 30minutes was for algorithmic programming in language of your choice. I completed 3.5 questions in 30minutes.
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.
Suppose the Recommended Friends team has updated the algorithm to analyze if the new algorithm is better than the old algorithm.
If the number of Facebook friend requests dropped by 10%, how would you investigate the problem as a data scientist?
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))
Basic data structure and sql statement at a very high level short answers
Write a python program to remove duplicates , keep the first occurrance
How will you analyze if launching stories is a good idea? What data would you look at?
You're at a casino with two dice, if you roll a 5 you win, and get paid $10. What is your expected payout? If you play until you win (however long that takes) then stop, what is your expected payout?
Prepare on financial statements
Viewing 1151 - 1160 interview questions