Data Interview Questions

132,702 data interview questions shared by candidates

SQL questions on promotions, sales schema. 1. find top 5 sales products having promotions 3. what %age of sales happened on first and last day of the promotion Python:- 1. [1,None,1,2,None} --> [1,1,1,2,2] Ensure you take care of case input[None] which means None object. 2. find s in missisipi. 3. Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings # For example: # - string 1 : "Firstly this is the first string" # - string 2 : "Next is the second string" # # - output : ['Firstly', 'this', 'first', 'Next', 'second']
avatar

Data Engineer

Interviewed at Meta

3.6
Sep 11, 2020

SQL questions on promotions, sales schema. 1. find top 5 sales products having promotions 3. what %age of sales happened on first and last day of the promotion Python:- 1. [1,None,1,2,None} --> [1,1,1,2,2] Ensure you take care of case input[None] which means None object. 2. find s in missisipi. 3. Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings # For example: # - string 1 : "Firstly this is the first string" # - string 2 : "Next is the second string" # # - output : ['Firstly', 'this', 'first', 'Next', 'second']

How would you measure the health of Mentions, Facebook's app for celebrities? How can FB determine if it's worth it to keep using it? If a celebrity starts to use Mentions and begins interacting with their fans more, what part of the increase can be attributed to a celebrity using Mentions, and what part is just a celebrity wanting to get more involved in fan engagement?
avatar

Data Scientist

Interviewed at Meta

3.6
Mar 29, 2017

How would you measure the health of Mentions, Facebook's app for celebrities? How can FB determine if it's worth it to keep using it? If a celebrity starts to use Mentions and begins interacting with their fans more, what part of the increase can be attributed to a celebrity using Mentions, and what part is just a celebrity wanting to get more involved in fan engagement?

how did you analyze data? Who uses your data analysis results? how large is the data set you work with? sql question one: the first table is customer purchase table, with five columns, customer id, purchase date, product id, unit price, unit purchased, write queries to retrieve data with unique customer id that made over $100 purchase in the past seven days. sql question two: a second table is the customer details table, with two columns, customer id, registration date, write queries to retrieve data with unique customer id that made over $100 purchase who registered in the past ten days. probability question: what is the probability of generating ten consecutive numbers in ascending order out of 100 numbers? this is a random number generation question.
avatar

Data Analyst

Interviewed at Amazon

3.5
Nov 8, 2016

how did you analyze data? Who uses your data analysis results? how large is the data set you work with? sql question one: the first table is customer purchase table, with five columns, customer id, purchase date, product id, unit price, unit purchased, write queries to retrieve data with unique customer id that made over $100 purchase in the past seven days. sql question two: a second table is the customer details table, with two columns, customer id, registration date, write queries to retrieve data with unique customer id that made over $100 purchase who registered in the past ten days. probability question: what is the probability of generating ten consecutive numbers in ascending order out of 100 numbers? this is a random number generation question.

Viewing 151 - 160 interview questions

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