Upload Button Icon Add office photos

Deutsche Bank

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

Deutsche Bank Mainframe Developer Interview Questions, Process, and Tips

Updated 5 Jul 2024

Deutsche Bank Mainframe Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(10 Questions)

  • Q1. How will you increase performance of cobol program when its using number of cursors?
  • Ans. 

    To increase performance of a COBOL program using multiple cursors, consider optimizing the SQL queries, reducing the number of cursors, and using efficient data structures.

    • Optimize SQL queries to retrieve only necessary data

    • Reduce the number of cursors by combining multiple queries into one

    • Use efficient data structures like arrays or tables to store and manipulate data

    • Avoid unnecessary looping and processing within cur

  • Answered by AI
  • Q2. How will you resolve division by zero error Socb
  • Ans. 

    To resolve division by zero error, check for zero before performing division operation.

    • Check if the denominator is zero before performing division operation

    • Handle the error by displaying a message or returning a default value

    • Use conditional statements or try-catch blocks to prevent division by zero

  • Answered by AI
  • Q3. How will you abend the program? by moving error code to Return code
  • Ans. 

    Abend the program by moving error code to Return code

    • To abend the program, set the return code to a non-zero value indicating an error

    • This can be done using a conditional statement to check for errors and then setting the return code accordingly

    • For example, in COBOL, you can use the ACCEPT statement to move the error code to the return code

  • Answered by AI
  • Q4. Inner Join Outer Join Left Join , String ,Unstring , Inspect all questions
  • Q5. How will you check if file is empty ?
  • Ans. 

    To check if a file is empty, you can use file size or read the file and check for any content.

    • Check the file size using system functions like stat() or file length property

    • Read the file and check if there is any content present

    • Use file handling functions to determine if the file is empty

  • Answered by AI
  • Q6. How will you read your file in different record structure ?
  • Ans. 

    To read a file with different record structures, use a combination of file parsing techniques and data manipulation.

    • Identify the record structure of each section in the file

    • Use conditional logic to parse each record based on its structure

    • Implement error handling for unexpected record structures

    • Utilize tools like regular expressions or custom parsing functions

    • Consider using libraries or frameworks that support flexible

  • Answered by AI
  • Q7. Is SQLCA EXEC SQL is mandatory ?
  • Ans. 

    No, SQLCA EXEC SQL is not mandatory for Mainframe Developer.

    • SQLCA EXEC SQL is not mandatory but can be used for error handling and status checking in COBOL programs.

    • It is used to retrieve information about the most recent SQL operation.

    • Developers can choose to use SQLCODE and SQLSTATE instead of SQLCA EXEC SQL.

  • Answered by AI
  • Q8. How will you give data from Cobol to JCL ?
  • Ans. 

    Data from Cobol can be passed to JCL using file handling techniques like writing data to a dataset or passing parameters through PROCs.

    • Use file handling techniques to write data from Cobol program to a dataset that can be accessed by JCL.

    • Pass parameters from Cobol program to JCL using PROCs.

    • Use symbolic parameters in JCL to reference data from Cobol programs.

  • Answered by AI
  • Q9. What syntax you give in Parm parameters to not be abend job when Subscript had ended his limit?
  • Ans. 

    Use the COND parameter in the JCL to prevent job abend when subscript limit is reached.

    • Use COND parameter in JCL to check for subscript limit before executing subsequent steps

    • Set COND parameter to check for specific return code when subscript limit is reached

    • Add a condition to bypass subsequent steps if subscript limit is exceeded

  • Answered by AI
  • Q10. How you will add 10 th additional record in file using Cobol program , what is the path.
  • Ans. 

    To add the 10th additional record in a file using a Cobol program, you would need to read the file sequentially and write the new record at the appropriate position.

    • Read the file sequentially until you reach the 9th record

    • Write the 10th record at the current position in the file

    • Update the file with the new record

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - no tips

Skills evaluated in this interview

Mainframe Developer Jobs at Deutsche Bank

View all

Interview questions from similar companies

I was interviewed before Mar 2016.

Interview Questionnaire 

2 Questions

  • Q1. Some technical questions were asked
  • Q2. They spring hibernate MVC flow and core java and Oracle connectivity questions

Interview Preparation Tips

Round: Technical + HR Interview
Experience: There was a Team manager and his junior for the interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Behavioural and culture fit

I applied via Company Website and was interviewed in Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Questions asked around 30 from asp.net, MVC, web api , c#, SQL etc
  • Q2. Some non tech questions also.

Interview Preparation Tips

Interview preparation tips for other job seekers - After selecting in state bank of india, I want to share my interview experience:

There were 5 persons in interview panel and they all asked questions both technical as well as non technical.
First they started from non technical questions. Like Why Madhubani painting is famous ? What is going on delhi university at that time contract teachers were on strike. Etc.
They asked about 30 questions from technical from asp.net, aap.net MVC, c#, SQL injection, XSS, CSRF, View vs Table, Function Vs SP, web services vs web api services, banking domain etc.
Overall it was a great experience. I answered almost 80 percentage questions. When interview result declared after 20 days, My name was there and I finally selected one of the big public sector bank. That is SBI. I would like to say Thank You Naukari.com.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Coding Test 

HackerEarth / Hacker rank Test

Round 2 - Technical 

(1 Question)

  • Q1. Find the lowest cost when given days you want to use metro if you have cost of a day 1 ,7 and 30 day pass. DP Problem
  • Ans. 

    Using dynamic programming to find the lowest cost for metro passes based on given days.

    • Create an array to store the minimum cost for each day.

    • Iterate through each day and calculate the minimum cost based on 1, 7, or 30 day pass.

    • Update the minimum cost for each day using dynamic programming.

    • Return the minimum cost for the total number of days needed.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Normal HR Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare DP and Graph Problems and know how banks work

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. What is static in java?
  • Ans. 

    Static is a keyword in Java used to create class-level variables and methods.

    • Static variables are shared among all instances of a class

    • Static methods can be called without creating an instance of the class

    • Static blocks are used to initialize static variables

    • Static import is used to import static members of a class

  • Answered by AI
  • Q2. Write a program to replace consecutive same character by single '$' . for e.g. string='Heelo Wworldd'. Output- H$lo $orl$.
  • Ans. 

    The program replaces consecutive same characters in a string with a single '$'.

    • Iterate through each character in the string

    • Compare the current character with the next character

    • If they are the same, replace the next character with '$'

    • Continue until the end of the string

  • Answered by AI
  • Q3. Difference between Function overloading and Function overrriding
  • Ans. 

    Function overloading is having multiple functions with the same name but different parameters. Function overriding is having a derived class implement a method with the same name and parameters as a method in its base class.

    • Function overloading is used to provide different ways of calling a function with different parameters.

    • Function overriding is used to provide a specific implementation of a method in a derived class...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Read all OOPs concept before going to interview. Prepare SQL also.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. LRU cache design
  • Ans. 

    LRU cache design involves maintaining a cache with limited capacity and removing the least recently used item when the cache is full.

    • Use a doubly linked list to maintain the order of items based on their usage.

    • Implement a hash map for fast access to items in the cache.

    • When a new item is accessed, move it to the front of the linked list to mark it as the most recently used.

    • When the cache is full, remove the item at the ...

  • Answered by AI
  • Q2. Current project

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. System design , HLD, LLD , coding question
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How to find out prime number
  • Ans. 

    Prime numbers are numbers that are only divisible by 1 and themselves.

    • Start by checking if the number is less than 2, as prime numbers start from 2.

    • Iterate from 2 to the square root of the number and check if the number is divisible by any of these numbers.

    • If the number is not divisible by any number in the range, then it is a prime number.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - want to answer
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Coding round java
  • Q2. Spring boot and devops activities

Interview Preparation Tips

Interview preparation tips for other job seekers - Na
Contribute & help others!
anonymous
You can choose to be anonymous

Deutsche Bank Interview FAQs

How many rounds are there in Deutsche Bank Mainframe Developer interview?
Deutsche Bank interview process usually has 1 rounds. The most common rounds in the Deutsche Bank interview process are Technical.
How to prepare for Deutsche Bank Mainframe Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Deutsche Bank. The most common topics and skills that interviewers at Deutsche Bank expect are Cobol, JCL, Cics, Agile and Application Development.
What are the top questions asked in Deutsche Bank Mainframe Developer interview?

Some of the top questions asked at the Deutsche Bank Mainframe Developer interview -

  1. How will you abend the program? by moving error code to Return c...read more
  2. what syntax you give in Parm parameters to not be abend job when Subscript had ...read more
  3. How will you read your file in different record structur...read more

Recently Viewed

INTERVIEWS

Apco Infratech

No Interviews

INTERVIEWS

Apco Infratech

No Interviews

INTERVIEWS

Deutsche Bank

No Interviews

SALARIES

UKG

INTERVIEWS

Deutsche Bank

No Interviews

INTERVIEWS

Deutsche Bank

No Interviews

INTERVIEWS

Company Interviews

No Interviews

INTERVIEWS

Apco Infratech

No Interviews

INTERVIEWS

Apco Infratech

No Interviews

DESIGNATION

Tell us how to improve this page.

Deutsche Bank Mainframe Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.5k Interviews
IDFC FIRST Bank Interview Questions
3.9
 • 641 Interviews
IndusInd Bank Interview Questions
3.5
 • 601 Interviews
Yes Bank Interview Questions
3.7
 • 429 Interviews
Barclays Interview Questions
3.8
 • 269 Interviews
View all
Mainframe developer

Pune

4-7 Yrs

Not Disclosed

Explore more jobs
Associate
4.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
3.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Vice President
3.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
2.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Financial Analyst
1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Deutsche Bank with

Barclays

3.8
Compare

JPMorgan Chase & Co.

4.0
Compare

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview