SQL: joins, aggregations Python: basic data structures
Data Interview Questions
132,723 data interview questions shared by candidates
How can Facebook figure out when users falsify their attended schools?
What is the expectation of the variance?
Interview Questions were average on difficulty level if you put some thought to it. Screening rounds were more of question answers based where they gave you a problem and expected an answer. Python: Find the max no from the given set of elements in an array (without using max function) Find the minimum absolute difference between the set of elements of an array. Python Coding Questions that involved a hashmap. Know your basics well Print Max element of a given list Print median of a given list Print the first nonrecurring element in a list Print the most recurring element in a list HCF/Greatest common Factor of List LCM of list Sql: find the highest salary per department Select employee from departments where max salary of the department is 40k Select employee assigned to projects Select employee which have the max salary in a given department Select employee with second highest salary Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day Typical questions around Group by, Joins during screening round they used MYSQL so practice solutions with basic SQL as the version i was working on didn't support analytical functions or other advanced features. Face To Face Rounds (Fullstack): To begin I was asked about different metrics which could be reported given the dataset/information or scenario. Then interviewer picked up a metrics and asked to draw on whiteboard what kind of graph/chart will I use to display the information. Then going further asked about the table structures and data model which will be required to support the dashboard. Interviewer then provided the initial data set which is 1 case was a log file and in another some detail level tables, I was asked to write a programming code to read, parse and load data to tables. Then along the way once we have our code tables and dashboard finalized i was asked to write SQL's for different steps in the whole pipeline.
Are you willing to work weekends and in the downtown client office which requires you to pay for your own parking?
(python) Given two sentences, construct an array that has the words that appear in one sentence and not the other.
What skills do you process to be successful in this role?
If you can build a perfect (100% accuracy) classification model to predict some customer behavior, what will be the problem in application?
When you have a time series data by monthly, it has large data records, how will you find out significant difference between this month and previous month
You searched for any website in your browser for example "www.google.com" and you couldn't able to reach the site, then what might be the problem?
Viewing 321 - 330 interview questions