Deutsche Bank came to our campus on 16th July for Online Coding round followed by 4 Interview Rounds on 20th July.
1) Aptitude/Coding Round:
It was a coding contest consisting of 3 coding questions. This round was conducted on hackerearth platform, so make sure you're comfortable with it.
45 students were shortlisted for further interview process.
2) Technical 1: (45 min)
The interview started with the introduction. Then he asked me to introduce without mentioning technical stuff and academic background. Again he asked to give introduction for atleast 2 min.
I managed to hold introduction for 1.5 min.
After that he asked some questions about linux and told me to rate myself in linux, I said 7/10.
He asked a couple of questions I could answer some of them, then he asked again are you sure on your rating for linux, I said yes.
He asked favourite subject, I said DSA. He told to write any program using any DSA, I wrote a string search program using Trie and explained everything to him, he was quite impressed at that time. Then he asked some real-life applications and we had some discussions around this.
He also asked the basics of Memory hierarchy and some comparison.
Then he moved to OS and asked some OS related questions.
32 students were selected for further interview process.
3) Technical 2: (45 min)
The interview started with basic introduction.
He started with asking questions about my projects. He asked about the challenges and how I overcame those challenges.
Then he saw MYSQL in my one of the project and started asking the DBMS related questions.
He asked me to design a database for a scenario.
-Create table on given conditions/constraints(constraints were wrong)
-Then he asked me to correct the constraints(by dropping them)
-Asked some SQL queries on joins, aggregate functions, group by, etc.(make sure you practice SQL beforehand)
Then He moved to DSA,
--Write a program to Convert Roman String to Decimal(IX → 9)
--Write a program to reverse a Linked List
Then he asked about OOPS,
--Pillars of OOPs,
--Real life examples of OOPS around us(in the library, as interview was conducted in Library)
19 students were selected for further interview process.
4) Professional Fitment Round: (25 min)
The Round started with basic Introduction.
Then he asked me about my internship at Siemens.
Then he asked some Situational Questions, what will you do if…
16 students were selected for HR round.
5) HR round: (20 min)
Started with introduction, She asked me
How was your day? What mistake you did?
Why do you want to join DB?
Describe yourself in 3 words (cover the answer with proper examples).
What will you do if one of your colleague isn't working?
What will you do if you've arguments with making a decisions on a project?
Finally 15 students including me were selected for the Deutsche Bank Grad Offer.
TIPS:
1. Be confident and have a smile on your face, even if you failed to give the answer.
2. Try to communicate with the interviewer, ask doubts, they may give you wrong information and expect you to ask.
3. Discuss your approach while solving problem and ask for hints if you need.
4. Be ready with some examples supporting your answer.
5. Be ready for the common questions that can be asked on your projects.
ALL THE BEST