Deutsche Bank interview experience Real time questions & tips from candidates to crack your interview

Technical Analyst-Intern

Deutsche Bank
upvote
share-icon
5 rounds | 15 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 3 Months
Topics: Data structure and Algorithm, DBMS, OS, OOPS, System Design, Competitive Programming, Development(Angular 9), Puzzles.
Tip
Tip

Tip 1 : If you have ample time then start competitive programming it will increase your speed of implementation and accuracy. I recommend codeforces.
Tip 2 : If your interviews are near, start solving standard coding problems from leetcode, Interview bit, and geeks for geeks.
Tip 3 : Try to do working projects, they make a great impact on the interviewer.
Tip 4 : Practice as many questions as you can. That way, you will not make any silly mistakes on the day of the interview.
Tip 5 : Go through the questions asked in the past years and the interview experiences.

Application process
Where: Campus
Eligibility: 7.5 CGPA
Resume Tip
Resume tip

Tip 1 : Try to add working projects in your resume, they attract the attention of interviewers.
Tip 2 : Add only those skills/programming language that you have worked with, not able to answer the questions asked on those skills/languages is the biggest embarrassment that can happen in an interview.
Tip 3 : Do not add unnecessarily styling to your resume, keep it simple and professional.

Interview rounds

01
Round
Easy
Online Coding Interview
Duration90
Interview date4 Sep 2020
Coding problem3

6-7:30 pm
The webcam was on throughout the test.

1. Ninja and Infinite Size Array

Easy
15m average time
85% success
0/40
Asked in companies
Deutsche BankMorgan StanleyFlipkart limited

Ninja has been given an array/list ‘ARR’ of unknown size and an element ‘TARGET.’ The ‘ARR’ is sorted in ascending order and all the elements of the ‘ARR’ are different. However, the size of the array is unknown to you. So Ninja can only access the 'ARR' using an interface ‘readValueAtIndex’. If you are trying to access a value from the index not present in the ‘ARR,’ you get output ‘10 ^ 9 + 7’.Ninja has to find that the position of the element ‘TARGET’ if it is present in the ‘ARR’.

For example:

Let ‘ARR’ = {2 4 7 10}.

If you want to know that what is the value at the 0-index in ‘ARR’, use ‘readValueAtIndex(0)’. Then the output is 2.

Let’s assume that you are trying to get the value at the 10’th index so, use ‘readValueAtIndex(10)’. Then the output is ‘10 ^ 9 + 7’. Because you are trying to access an index that is greater than the size of ‘ARR’.

Note: If the element ‘TARGET’ is not present in the ‘ARR’ then return -1.

Try solving now

2. Shortest Safe Route In A Field With Landmines

Moderate
20m average time
80% success
0/80
Asked in companies
OlaDeutsche BankBarclays

Recently Ninja has been learning about a new Ninja Technique to cross a field with landmines. The field is in the form of a rectangular matrix of size M x N, having few landmines, which are placed arbitrarily. The landmine gets triggered if a person is any closer than one cell from the position where it is placed. So Ninja must avoid the landmines and any of the four adjacent cells (left, right, above and below), as they are also unsafe.

Initially Ninja is on one side of the field and has to move to the other side. You need to help Ninja apply the new Ninja Technique by providing him with the length of the shortest safe route possible from any cell in the first column to any cell in the last column of the field.

Note that Ninja is only allowed to move only in the direction left, right, above and below i.e., he cannot move diagonally to the next cell.

Note :
The length of the path is the number of steps required to reach from the first column of the field to the last column i.e., one less than the number of cells in the path.
For Example :
Consider the field of size 4*4, shown below. The cells containing landmine are marked with 0 and red colour. The cells near the landmine which are unsafe are marked with a light red colour. 

The shortest safe route for Ninja, starting from any cell in the first column to any cell in the last column of the field is marked with green colour. The length of the path is 3.

Example Matrix

Try solving now

3. Maximum Subarray Sum

Moderate
0/80
Asked in companies
AmazonOracleOptum

You are given an array/list ARR consisting of N integers. Your task is to find the maximum possible sum of a non-empty subarray(contagious) of this array.

Note: An array C is a subarray of array D if it can be obtained by deletion of several elements(possibly zero) from the beginning and the end of array D.

For e.g.- All the non-empty subarrays of array [1,2,3] are [1], [2], [3], [1,2], [2,3], [1,2,3].

Try solving now
02
Round
Easy
Video Call
Duration30 Minutes
Interview date8 Sep 2020
Coding problem3

Morning(10 am)
The interviewer was friendly.

1. Add Two Numbers As Linked Lists

Moderate
20m average time
80% success
0/80
Asked in companies
Goldman SachsInformaticaFacebook

You are given two non-negative numbers 'num1' and 'num2' represented in the form of linked lists.


The digits in the linked lists are stored in reverse order, i.e. starting from least significant digit (LSD) to the most significant digit (MSD), and each of their nodes contains a single digit.


Calculate the sum of the two numbers and return the head of the sum list.


Example :
Input:
'num1' : 1 -> 2 -> 3 -> NULL
'num2' : 4 -> 5 -> 6 -> NULL

Output: 5 -> 7 -> 9 -> NULL

Explanation: 'num1' represents the number 321 and 'num2' represents 654. Their sum is 975.


Try solving now

2. SQL Questions

Difference between Union and Union all

Two tables were present having similar schema containing some common and distinct data I had to write a query to return a table containing all the entries all both tables but there should be distinct entries in the resulting table.

Given an employee table get all the names starting with the letter a.

3. Find prime numbers

Easy
15m average time
80% success
0/40
Asked in companies
HSBCSalesforceDeutsche Bank

You are given a positive integer ‘N’. Your task is to print all prime numbers less than or equal to N.

Note: A prime number is a natural number that is divisible only by 1 and itself. Example - 2, 3, 17, etc.

You can assume that the value of N will always be greater than 1. So, the answer will always exist.

Try solving now
03
Round
Medium
Video Call
Duration60 Minutes
Interview date8 Sep 2020
Coding problem7

Afternoon around 12 PM
If was from home
The interviewer was professional and did not waste any time.

1. Technical Questions

He asked me the main features of Angular because I have written angular in the skills section of my resume.

2. SQL Question

I don't remember this question precisely but it was somewhat like this:
Two tables were given and he asked me the employee names which were most common in each city.
The tables were like this:
Table 1:employee_id name office_id 
Table 2:Office_id city
This is just an idea of how the question was. The original question was a bit tougher than this because I remember that I had a hard time solving that question but i solved it in not more than 5-7 minutes.

3. Cycle Detection in a Singly Linked List

Moderate
15m average time
80% success
0/80
Asked in companies
GrabThalesSterlite Technologies Limited

You are given a Singly Linked List of integers. Return true if it has a cycle, else return false.


A cycle occurs when a node's next points back to a previous node in the list.


Example:
In the given linked list, there is a cycle, hence we return true.

Sample Example 1

Try solving now

4. Implement Stack With Linked List

Moderate
30m average time
73% success
0/80
Asked in companies
OYOQualcommMathworks

You must implement the Stack data structure using a Singly Linked List.


Create a class named 'Stack' which supports the following operations(all in O(1) time):


getSize: Returns an integer. Gets the current size of the stack

isEmpty: Returns a boolean. Gets whether the stack is empty

push: Returns nothing. Accepts an integer. Puts that integer at the top of the stack

pop: Returns nothing. Removes the top element of the stack. It does nothing if the stack is empty.

getTop: Returns an integer. Gets the top element of the stack. Returns -1 if the stack is empty
Try solving now

5. System Design Question

The interviewer asked me to design a banking system in which the user can use either the current account(rate of interest 10%) or savings account(rate of interest 7%) and the functions that I had to implement were:
1 Withdraw
2 deposit
He asked me to implement this using Object Oriented Concepts.

6. Find Unique

Easy
0/40
Asked in companies
Deutsche BankHSBCJosh Technology Group

You have been given an integer array/list(ARR) of size N. Where N is equal to [2M + 1].

Now, in the given array/list, 'M' numbers are present twice and one number is present only once.

You need to find and return that number which is unique in the array/list.

 Note:
Unique element is always present in the array/list according to the given condition.
Try solving now

7. Puzzle

Suppose you have a 3 liter jug and a 5 liter jug (this could also be in gallons). The jugs have no measurement lines on them either. How could you measure exactly 4 liter using only those jugs and as much extra water as you need?

04
Round
Easy
HR Round
Duration45 minutes
Interview date8 Sep 2020
Coding problem1

They were calling it a pro-fitness round, it was to check if you are professionally fit to work in the company.
It was in the late afternoon around 3 PM
The interviewer was very friendly and engaging.

1. Basic HR Questions

Are you a team player?

What happens if your team is not working as expected?

Problem approach

Tip 1 : In this type of question try to show that you are a team player, even if one of your team members is not working properly, you can cover for his/her mistakes and talk them out of their problems.

05
Round
Easy
HR Round
Duration20 Minutes
Interview date8 Sep 2020
Coding problem1

It was in the evening around 5 PM
The locations and work culture was discussed in that round 
The interviewer was exhausted.

1. Basic HR Questions

Who is your role model?

What keeps you motivated?

Problem approach

Tip 1 : I had done many projects so I had a lot of answers to this question. Having projects helped me in both of my HR and Pro-fit rounds.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
company logo
Technical Analyst-Intern
4 rounds | 4 problems
Interviewed by Deutsche Bank
3142 views
0 comments
0 upvotes
company logo
Software Developer
3 rounds | 5 problems
Interviewed by Deutsche Bank
10254 views
0 comments
0 upvotes
company logo
SDE - Intern
4 rounds | 7 problems
Interviewed by Deutsche Bank
2490 views
0 comments
0 upvotes
company logo
Software Engineer
2 rounds | 5 problems
Interviewed by Deutsche Bank
2976 views
1 comments
0 upvotes