Analyst Entwickler Interview Questions

475 analyst entwickler interview questions shared by candidates

SQL Questions 1. Write a SQL statement to get list of all students whose name starts with 'a'. 2. There is a employee table which consists a list of all employees of a office month wise and the columns are id, name, salary and month. You have a write a SQL statement to get a list of top 3 salary getters for each month. Probability Questions 1. There is biased coin in which probability of getting heads is 3 times more than tails, you toss the coin three times and and each coin toss is independent. What is the probability of getting at most 2 tails. 2. There are 75 students in a class divided in 3 equal groups of 25 each, you have to pick 2 students from these 75 . What is the probability of picking both students from same group. 3. There are 5 black balls and 10 red balls in a basket. What is the probability. That the third ball you picked will be black ball and what is the probability that the last ball you pick will be black. Data structures Questions 1. What is the best sorting algorithm and what is its time complexity in each case( best, average and worst). 2. Explain merge sort and how does t work. 3. How do you find square root a number without using Math.sqrt function. 4. How do you find if the given number is prime or not.
avatar

Analyst BA3 Software Developer

Interviewed at Barclays

4
Sep 15, 2021

SQL Questions 1. Write a SQL statement to get list of all students whose name starts with 'a'. 2. There is a employee table which consists a list of all employees of a office month wise and the columns are id, name, salary and month. You have a write a SQL statement to get a list of top 3 salary getters for each month. Probability Questions 1. There is biased coin in which probability of getting heads is 3 times more than tails, you toss the coin three times and and each coin toss is independent. What is the probability of getting at most 2 tails. 2. There are 75 students in a class divided in 3 equal groups of 25 each, you have to pick 2 students from these 75 . What is the probability of picking both students from same group. 3. There are 5 black balls and 10 red balls in a basket. What is the probability. That the third ball you picked will be black ball and what is the probability that the last ball you pick will be black. Data structures Questions 1. What is the best sorting algorithm and what is its time complexity in each case( best, average and worst). 2. Explain merge sort and how does t work. 3. How do you find square root a number without using Math.sqrt function. 4. How do you find if the given number is prime or not.

1st interview: (situational) (tell me about yourself, why Deloitte, adv, and dis of cloud, tell me about projects on your resume) 2nd interview: (behavior) 1. tell me about you a time you had to think on your feet 2. Tell me about a time when your work displayed your integrity. 3. Tell me about a time when you had to lead a team. 4. Have you ever faced conflict in any project? Time you failed 5. Discuss a time when you worked in a group and had difficulty working with group members. How did you work with them? 6.Explain one of the most ambiguous situations you have faced in your professional life 3rd interview: (technical) 1.What is an abstract class 2.What is a var and constraint in JavaScript 3. Purpose of error handling and what are the components of error handling? 4. Name and describe the 4 main OOP concepts programming and what is inheritance. please give an example 5. a bunch of SQL questions ( joins, filtering, sorting, grouping and deleting) 6. What is a foreign key, primary key, and secondary key
avatar

Solution Analyst (Software Developer)

Interviewed at Deloitte

3.8
Nov 16, 2023

1st interview: (situational) (tell me about yourself, why Deloitte, adv, and dis of cloud, tell me about projects on your resume) 2nd interview: (behavior) 1. tell me about you a time you had to think on your feet 2. Tell me about a time when your work displayed your integrity. 3. Tell me about a time when you had to lead a team. 4. Have you ever faced conflict in any project? Time you failed 5. Discuss a time when you worked in a group and had difficulty working with group members. How did you work with them? 6.Explain one of the most ambiguous situations you have faced in your professional life 3rd interview: (technical) 1.What is an abstract class 2.What is a var and constraint in JavaScript 3. Purpose of error handling and what are the components of error handling? 4. Name and describe the 4 main OOP concepts programming and what is inheritance. please give an example 5. a bunch of SQL questions ( joins, filtering, sorting, grouping and deleting) 6. What is a foreign key, primary key, and secondary key

Q: He asked me where should he ask questions from. But he did not limit the questions to that topic. Intermediate level questions related to JAVA, like exception handling and multithreading were the main ones. I later asked to ask me questions from Android also. In Android, he asked me about different layouts, horizontal and vertical layout, and a few specific questions. One case based question was also there. Your client is bank. How will you ensure that the account number they type is correct?
avatar

Sr. Software Developer/Analyst

Interviewed at Zensar Technologies

3.7
Dec 4, 2020

Q: He asked me where should he ask questions from. But he did not limit the questions to that topic. Intermediate level questions related to JAVA, like exception handling and multithreading were the main ones. I later asked to ask me questions from Android also. In Android, he asked me about different layouts, horizontal and vertical layout, and a few specific questions. One case based question was also there. Your client is bank. How will you ensure that the account number they type is correct?

Viewing 321 - 330 interview questions

Glassdoor has 475 interview questions and reports from Analyst entwickler interviews. Prepare for your interview. Get hired. Love your job.