Analyst Developer Interview Questions | Glassdoor

# Analyst Developer Interview Questions

531

Analyst developer interview questions shared by candidates

## Top Interview Questions

Sort: RelevancePopular Date

### Associate Business Intelligence Analyst Developer at World Wide Technology was asked...

Oct 28, 2011
 Whats the difference between inner join and outer join?2 AnswersInner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the KeySpecified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table.

Dec 4, 2010
 Given a m*n matrix with values -1 or 1, try to flip the values in a given row and a given line efficiently.3 Answersfor(i=0;iR: given row, C: given column for i = 0 to m: Matrix(i, C) *= -1 for j = 0 to n: Matrix(R, j) *= -1 Matrix(R, C) *= -1you can get even more efficiency if you go down to the bit level, since multiplication is expensive. python code follows: let's call the matrix M, and the given row and column r,c respectively for i in range(0,m): M[i][c] = ~M[i][c] + 1 for j in range(0,n): M[i][r] = ~M[i][r] + 1

### Software Development Analyst III at Northrop Grumman was asked...

Feb 25, 2009
 Describe a specific instance where you faced an ethical dilemma, were asked to do something unethical, or advised to lie about something. Describe how you handled the situation and why you handled it the way you did.2 AnswersThey are really trying to see if you have acted with integrity and followed good ethical guidelines in your previous work experience. This is very important if you need to get a security clearance and they don't want to waste money on people who would not pass the background screening since it is very expensive.Maybe they probing to see if you have a working knowledge of a code of ethics (such as the IEEE Computer Society's "Software Engineering Code of Ethics and Professional Practice" ), and understand how to apply them.

### IT Analyst Developer at Boeing was asked...

Mar 16, 2009
 You have no real world experience with what this job requires. If presented with an assignment/project with real world demands and deadlines, how will you meet these needs?2 AnswersThis is when you need to bring up specific school projects and assignments that dealt with problems in a similar way.I would take the assignment or project and work on it in smaller, more managable portions which would allow me to complete the assignment within the required timeframe. If the assignment or project could not be completed within the required timeframe, it would be my responsibility to raise the issue to coworkers in order to complete the work as required.

### Analyst Developer at Goldman Sachs was asked...

Oct 9, 2009
 Write a program that prints out all possible pairs that can be formed from 20 dancers. 2 AnswersIn C (assuming each dancer is represented as a character in a string): #include #include int main() { char* dancers = "abcdefghijklmnopqrst"; int i, j; for(i = 0; i < strlen(dancers); i++) for(j = i+1; j < strlen(dancers); j++) printf("%c %c\n", dancers[i], dancers[j]); }In java String dancers = "abcdefghijklmnopqrst"; char[] dancersArray = dancers.toCharArray(); for(int i=0;i

### Analyst Developer at Goldman Sachs was asked...

Aug 20, 2010
 Name one of the more efficient sorting algorithms2 AnswersHash SortMerge Sort. Used in Java implementations for sorting. O(NlogN) runtime

### Frontline Analyst Developer at Goldman Sachs was asked...

Sep 26, 2012
 How does indexing work in a database? How is it implemented? what happens when user types ABC?2 AnswersImplemented as a tree, When user types ABC, the db will return all matches/subtrees below C - all ABCD's, ABCE's, etc. If there are multiple ABCD's, then the lowermost node-leaf-D-will point to all the ABCD locations.Recursive algorithm for Fibonacci sequence is not nlog(n), it must be ~1.6^n, i.e. very bad, hm..

### Technology Developer and Analyst Program at Bank of America was asked...

Mar 10, 2013
 Swap two numbers while not using the temp variable.3 Answersusing the XOR operatora = a+b; b = a -b; a= a- b;a = a ^ b b = a ^ b a = a ^ b This will avoid over flows which might come in addition steps

### Operations Analyst Development Program at J.P. Morgan was asked...

Oct 28, 2013
 Tell me how you see the company performing in the next 5 years.1 AnswerHey how long did it take for them to get back to you and did they call or email you? I just went through this same process

### Analyst, Strategy and Corporate Development at Cengage was asked...

Apr 30, 2014
 Case study and puzzle1 AnswerDon't shoot from the hip. Take your time to reflect deeply before beginning your response
110 of 531 Interview Questions

More