Skip to contentSkip to footer

Analist Interview Questions

Salaries
Interviews

157,128 analist interview questions shared by candidates

Here's the deal: You have to know SQL. By all accounts, and according to people within the company, they are no longer hiring people who do not have previous SQL experience. If there is one thing that I can point to that probably cost me the offer, it is that I have not used SQL in a while, and it showed. Everyone with whom I interviewed asked SQL questions. They will give you a set of EMR (Electronic Medical Record) data (2 or 3 tables) and ask questions about how you the tables might be manipulated to provide information. So you not only need to know how to select certain data types and columns to provide insight in theory, but you also must know how to construct the correct select statement. Expect questions on inner/outer joins, unions, subqueries, aggreagtor functions including how to use sum and/or count with group by. If you don't have solid command of SQL and a good bit of fresh, current use, you are probably wasting your time. Yes, SQL is a rather small language in the DML context, and something that can be picked up rather easily, but probably not quickly and completely enough to impress in the interview. Bottom line: don't expect to fake it till' you make it.
avatar

Business Analyst

Interviewed at Advisory Board

3.9★
Feb 27, 2013

Here's the deal: You have to know SQL. By all accounts, and according to people within the company, they are no longer hiring people who do not have previous SQL experience. If there is one thing that I can point to that probably cost me the offer, it is that I have not used SQL in a while, and it showed. Everyone with whom I interviewed asked SQL questions. They will give you a set of EMR (Electronic Medical Record) data (2 or 3 tables) and ask questions about how you the tables might be manipulated to provide information. So you not only need to know how to select certain data types and columns to provide insight in theory, but you also must know how to construct the correct select statement. Expect questions on inner/outer joins, unions, subqueries, aggreagtor functions including how to use sum and/or count with group by. If you don't have solid command of SQL and a good bit of fresh, current use, you are probably wasting your time. Yes, SQL is a rather small language in the DML context, and something that can be picked up rather easily, but probably not quickly and completely enough to impress in the interview. Bottom line: don't expect to fake it till' you make it.

The interview was a structured interview with manager following the paper outline. The manager inquired further to some of the questions along the way though mostly went one level deeper with followup questions. Most the questions that I remember were experience based with some personality based. No big deal the interview was relaxed and the role required dynamism and a strong person which almost seemed hypocritical.
avatar

Associate Business Analyst

Interviewed at Voya Financial

3.6★
May 15, 2015

The interview was a structured interview with manager following the paper outline. The manager inquired further to some of the questions along the way though mostly went one level deeper with followup questions. Most the questions that I remember were experience based with some personality based. No big deal the interview was relaxed and the role required dynamism and a strong person which almost seemed hypocritical.

Viewing 181 - 190 interview questions

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