Programmer Analyst Interviews

Programmer Analyst Interview Questions

As a programmer analyst, you’re being hired for your brain, so expect your brain to be put to the test with challenging analytical questions. Expect technical questions about writing software and also questions about general analytical and problem solving skills. Also, you ultimately need to be able to communicate results to the business leaders, so expect to be tested on your ability to present your findings in a concise and coherent way.

22,439 programmer analyst interview questions shared by candidates

Draw an ER diagram on the white board. I was given two table names (customer and account). I had to figure out what fields would typically be in these tables. Then I was asked to write one query to fetch data from the tables. I can't remember it specifically but I had to use an inner join. The weird questions: if you have a triangle with a person at each corner of the triangle, and they are moving in all directions, what is the probability that they will collide? And if you are in a pitch black room with a sock drawer of 20 blue and 20 green socks, what is the minimum number of times you have to reach inside to GUARANTEE a matching pair of socks the same color?
avatar

Analyst Applications Programmer

Interviewed at Bank of America

3.9
Dec 8, 2016

Draw an ER diagram on the white board. I was given two table names (customer and account). I had to figure out what fields would typically be in these tables. Then I was asked to write one query to fetch data from the tables. I can't remember it specifically but I had to use an inner join. The weird questions: if you have a triangle with a person at each corner of the triangle, and they are moving in all directions, what is the probability that they will collide? And if you are in a pitch black room with a sock drawer of 20 blue and 20 green socks, what is the minimum number of times you have to reach inside to GUARANTEE a matching pair of socks the same color?

Viewing 571 - 580 interview questions

Glassdoor has 22,439 interview questions and reports from Programmer analyst interviews. Prepare for your interview. Get hired. Love your job.