Deutsche Bank is a German multinational investment bank and financial services company. Generally, they start oncampus hiring in month of July. They offered the job role of Graduate Analyst. Their process of hiring includes 1 aptitude (coding) test round and 4 interview rounds.
Aptitude Test :
In this round, there were 3 coding questions of medium to hard difficulty. 2 medium and 1 hard question. These questions were based on array, string and graph.
The time given to solve these three coding questions was 1 hour 30 minutes.
4 Interview rounds :
Technical Round 1 :
The very first question interviewer asked was my introduction. Next question was where do you see yourself after 5 years. Then as I mentioned about my internship in resume, he started asking questions about my internship. Then he moved towards technical questions on DSA, OOPs and DBMS.
Questions asked during this interview:
1. Write a code to reverse a string:
input - Hello World
output - World Hello
Interviewer asked me to write this code within 5-6 min. And after 5 min he asked me to stop writing. Fortunately, I was able to complete my code within time.
2. All OOPs concept were asked with real time examples.
3. Deep dive into DBMS.
- Normalise given table till 3rd Normal form.
- How will you achieve consistency in database?
- Deep discussion about locking protocols and ACID Properties.
- How to find nth highest salary?
- Lot of SQL queries were asked to frame on joins, aggregate functions and subqueries. For this, they will give you input tables and also will tell you how the output table look like.
This round lasts about 40 min.
Technical Round 2 :
Second Technical round was a deeper discussion about the projects mentioned in my resume.
I mentioned my top 3 projects in resume. Interviewer asked me to explain any of the two projects. So, I explained 1st project. He asked me the following question regarding the 1st project:
1. My contribution in the project.
2. Tech stack and basic questions on mentioned tech stack.
After these questions, I explained 2nd project which we have built during hackathon in which my team was runner up. I shared my screen and gave live demonstration of that project. The interviewer then asked me about my role in this project. He told me to explain the features of this project. He was quite clear with my project idea and implementation because of live demonstration.
Then after project discussion, he asked me question on sorting techniques and their complexities and to compare them and tell which sorting technique is best. He asked me whether I know about JDBC. As I answered Yes, he asked me a question - how to do database connection in Java (basically, a JDBC connection code)?
This round lasts for 35 min.
Professional Fitment Round :
This round was like managerial round. In this round, they will check your communication skills and will ask about your achievements and hobbies. If you mentioned any club related activity or achievement in your resume, they will also like to know about it. Also, they will give you some scenarios and will ask how will you behave in those situations. They will ask you about your area of interest to work (like which technology you are interested to work in). Also during my interview, interviewer asked me whether I have some finance related knowledge. As I answered Yes, he asked me some financial questions like what I know about mutual funds and investments.
This round lasts about 25 min.
HR Round
General discussion about you and your family background. HR will ask questions like which location(city) you will prefer to work, why you want to join deutsche bank and whether you know any product of the company.
It was just 10-12 mins conversation with HR.
Tips:
1. Be confident throughout the interview.
2. Think aloud when interviewer ask you to write a code.
3. DBMS and SQL are much more important. Study it thoroughly.
4. Read about the company's background and their products a little more.