Due to the NDA I had to sign, I will not mention key things. I was asked questions that tested my knowledge about SQL, business sense, and probability/math.
Data Interview Questions
132,980 data interview questions shared by candidates
In Mexico, if you take the mean and the median age, which one will be higher and why?
If you draw 2 cards from a shuffled 52 card deck, what is the probability that you'll have a pair?
Certain programming commands
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))
How many orders of Fries does McDonald's sell in a year?
What percent of all products in the grocery chain's catalog are both low fat and recyclable?
Write a query that returns product_family, units_sold, percentage of promoted.
Write a python program to remove duplicates , keep the first occurrance
Viewing 1141 - 1150 interview questions
See Interview Questions for Similar Jobs
Computer OperatorNoc OperatorConfiguration Management AnalystCirculation ManagerDatacenter TechnicianManager AnalyticsMailroom ClerkMail SorterMedical Office ClerkMedical Office ReceptionistManual Software TesterMail Room ClerkMedical ClerkMedical Office SpecialistManager Marketing AnalyticsMedical Billing ClerkMedical Record Retrieval SpecialistMedical Claims ProcessorMarketing Analytics Manager