Skip to contentSkip to footer

Analist Interview Questions

Salaries
Interviews

157,128 analist interview questions shared by candidates

Prepare 6-7 situations for behavioral questions and be flexible if they questions is not asked in the way as you are prepared. Try to find the character they asked from your prepared examples. Cases are easy, if you make mistake and feel your answer is awkward, ask for help and modify your calc. I did make a mistake. It was a typo carried to next step's calc. And I found out and asked for help, and found out what's wrong with the formula I wrote.
avatar

Senior Data Analyst

Interviewed at Capital One

5★
Mar 4, 2014

Prepare 6-7 situations for behavioral questions and be flexible if they questions is not asked in the way as you are prepared. Try to find the character they asked from your prepared examples. Cases are easy, if you make mistake and feel your answer is awkward, ask for help and modify your calc. I did make a mistake. It was a typo carried to next step's calc. And I found out and asked for help, and found out what's wrong with the formula I wrote.

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.
avatar

Data Analyst

Interviewed at Meta

3.6★
Dec 16, 2016

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.

Viewing 171 - 180 interview questions

Glassdoor has 157,128 interview questions and reports from Analist interviews. Prepare for your interview. Get hired. Love your job.