Argus Information & Advisory Services Technical Business Analyst Interview Questions | Glassdoor

Argus Information & Advisory Services Technical Business Analyst Interview Questions

Interviews at Argus Information & Advisory Services

1 Interview Review

Experience

Experience
100%
0%
0%

Getting an Interview

Getting an Interview
100%

Difficulty

3.0
Average

Difficulty

Hard
Average
Easy

Helpful (2)  

Technical Business Analyst Interview

Anonymous Employee
Accepted Offer
Positive Experience
Average Interview

Application

I applied online. I interviewed at Argus Information & Advisory Services in October 2017.

Interview

Applied online (LinkedIn), received a phone interview within a couple of days, but the interviewer didn't call at the scheduled time. After a few attempts to reach the interviewer, the HR reached out to me in about 10 days and scheduled a phone interview. The interview was very short, hardly 10-15mins just discussing past experience. I was immediately asked for a next round which would be taken by the hiring manager and that was held in the next few days over the phone.
Prepare for SQL very well on this round. You will be tested on SQL concepts and asked to write a few queries.
One random probability question
One question on credit cards
One question on market sizing

Interview Questions

  • Union vs Union All   Answer Question
  • Explain the different types of join   Answer Question
  • One query on join (using IS NULL)   Answer Question
  • Table has rows having 0s and 1s. How would you replace all 0s with 3 and 1s with 4   1 Answer
  • A view is created from a table, when the view is updated, does the table get updated as well?   Answer Question
  • Find employee names beginning with A   2 Answers
  • How would you display 'hew' when you have field value 'Mathew'?   Answer Question
  • How would you find 2nd highest salary of an employee?   Answer Question
  • Rank vs DenseRank   Answer Question
  • What is the use of RowValue? Explain a scenario where it could be used.   Answer Question
  • What is the use of group by? Explain a scenario where it could be used.   Answer Question
  • How many people drink coffee in the US?   Answer Question
  • If I have 6white and 6 black socks in a back (identical) and I pull one sock out at a time, in how many tries will I get either 2 black or 2 white socks?   1 Answer
  • Describe the order of SQL statements   1 Answer
Don't Miss Out On a Job You Love
Upload a resume to easily apply to jobs from anywhere. It's simple to set up.