Skip to contentSkip to footer

Systems Analyst Business Analyst Interview Questions

Salaries
Interviews

2,766 systems analyst business analyst interview questions shared by candidates

1st round was a written test that comprises with a very difficult SQL test. They give you tables with the data on a paper and asks you questions. Either you crack the test or no, they will call you for the 1st 1:1 round. Questions from the written test. 1. How to generate data from two or more table without using sub-queries? 2. Cross Join, Left Join and Right Join? 3. How to get rank/position of John? etc.. 2nd round with the panel 1:1 on the same day: Asked about my background, my past work culture and responsibilities that I had, I cleared this round and was asked to wait for 3rd round. 3rd round 1:1 with a senior manager it seems and this will be the deciding round a) General walk-through on my profile b) Gave me a business scenario/case, where I should start questioning the interviewer to collect information/requirements c) Asked about BRD/FSD/SRS, what is not covered on BRD/FSD/SRS? e) How do you initially gather the requirements? f) What are the techniques that you use personally to gather requirements? g) How well are you with data/SQL? h) Rate yourself between 1 to 10 on sql?
avatar

Business Systems Analyst

Interviewed at Epsilon

3.6★
Aug 26, 2019

1st round was a written test that comprises with a very difficult SQL test. They give you tables with the data on a paper and asks you questions. Either you crack the test or no, they will call you for the 1st 1:1 round. Questions from the written test. 1. How to generate data from two or more table without using sub-queries? 2. Cross Join, Left Join and Right Join? 3. How to get rank/position of John? etc.. 2nd round with the panel 1:1 on the same day: Asked about my background, my past work culture and responsibilities that I had, I cleared this round and was asked to wait for 3rd round. 3rd round 1:1 with a senior manager it seems and this will be the deciding round a) General walk-through on my profile b) Gave me a business scenario/case, where I should start questioning the interviewer to collect information/requirements c) Asked about BRD/FSD/SRS, what is not covered on BRD/FSD/SRS? e) How do you initially gather the requirements? f) What are the techniques that you use personally to gather requirements? g) How well are you with data/SQL? h) Rate yourself between 1 to 10 on sql?

Viewing 471 - 480 interview questions

Glassdoor has 2,766 interview questions and reports from Systems analyst business analyst interviews. Prepare for your interview. Get hired. Love your job.