Python Questions: Avg length of words, some of the edge cases are having spaces in the beginning and end of the words, returning a float instead of int, returning None for blank input. Valid ip address, edge case to remember is if there are alphanumeric characters. SQL questions: One SQL question was tricky because you have to look at the data to come up with the question, the question is to find the percent of valid promotion, condition to find valid promotion is not specified in the question, so you have to figure it from looking at the data. Other SQL questions are based on a join, group by, top(3)
Data Interview Questions
132,832 data interview questions shared by candidates
How can we tell if two users on Instagram are best friends? (answer question) Ok, how can we use this algorithm in the product?
sql : inner join , cases , order by , limit python: avg length of sentence , valid IP address
What is the difference between Z test and T test?
Flatten a nested dictionary?? ( this was the hardest question in coder pad questions )
Onsite - 3 full stack interviews: given a KPI, choose the right metric, perform ETL (SQL/Code) . 1 lunch interview - casual discussion where you learn more about working in facebook and the interviewer tries to understand if you are a good fit.
the probability of getting a pair, a straight in 52 cards
Why are manhole covers round?
1-Programming: Given data on Facebook members friending/defriending each other on Facebook, find out whether a given pair of members are currently friends. 2- Statistics: Very basic questions on treatment effects under various sampling schemes. 3-Research Design Question: How would you test whether having more friends now increases the probability that a Facebook member is still an active user after 6 months?
Details about my experience in Saudi
Viewing 671 - 680 interview questions