Deutsche Bank Interview Experience

Swarangi Patil
2023-06-15
Deutsche Bank

About Deutsche Bank/Role:

The 8th or 9th company to visit the campus. It is a German investment bank. Offices present in Pune and Bangalore. Job role offered is Graduate Analyst. The stack you are expected to work on would be Java (Springboot). Knowledge of GCP would help.

 

CTC offered: 19.625 lpa (joining bonus 3 lakh included)

In hand salary: 15 lpa

 

1. Aptitude Round: 

3 coding questions were asked. One on N-Queen problem (backtracking). The rest of the two were medium level questions and fairly difficult compared to other company's aptitude rounds. 

 

2. Technical Round 1:

We were informed in advance the name of the interviewers. It is a good practice to research the interviewer's skills on LinkedIn in such a case. I was asked the following questions:

  1. Introduction
  2. Where do you see yourself in 5 years?
  3. Explain normal forms in DBMS
  4. How do you implement 2nd NF in a database?
  5. What is Atomicity? Is it same as Consistency?
  6. How do you achieve Atomicity in a database?
  7. Explain ACID principles
  8. What is a lock in DBMS?
  9. How are locks implemented?
  10. There was a question about a specific lock type and I was unable to answer it so he shifted to SQL.
  11. Given an employee table, with employee name, employee id employee salary, another department table with department id and employee id, create a new table which provides the highest salaries of employees department wise.
  12. Write a code for 3d matrix multiplication 

 

3. Technical Round 2:

Almost one third of the people got selected for the next round. The next interviewer went through the resume. The following questions were asked:

  1. Introduction
  2. Which language are you proficient in? I answered Java. The interviewer was used to C++. 
  3. I was asked to write the code for a very simple problem.
  4. A sorting question: Given a list of numbers, which would be the fastest way to sort it. I answered merge sort. He asked me to take a look at the numbers closely. The list was arranged in a way that you would not require to sort it through any sorting technique. A few more list examples were shown and the approach to sort was checked here
  5. Puzzle: If there is a bus of 100 seats each numbered 1-100 and passengers each numbered 1-100, if all the passengers entered in a random order inside the bus and sat on any seat number, what is the probability that the 100th passanger gets the seat same as his number? Ans: 50%
  6. The first project in my Resume used AWS. Related questions were: Why have you used AWS in the project? Why are lambda functions necessary in your project? What is the alternative for EC2 in GCP?
  7. What have you studied about GCP? Name a few services and their uses.                 There were a few more questions which I am unable to recall. Interviewer was very friendly and supportive. 

 

4. Profit Round:

This round was a check the communication skills as well as the capability to handle social scenarios. Similar to an HR round.

 

5. HR Round:

The usual questions about strength, weaknesses, why Deutsche Bank, goals, etc.

 

Tips:

  1. Read well about the job description and company background before applying to any company.
  2. DBMS, SQL were majorly asked
  3. Have a good project as the first one in your resume
  4. Read a few GFG puzzles
  5. A little knowledge of GCP can be very helpful.
  6. Confidence > Correctness of the answer.

 

 

All articles