Deutsche Bank Data Analyst Interview Questions, Process, and Tips

Q1. Sas proc format
Add your answer
Q2. How have you debug macros
Ans. 
I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.
• Reviewing the macro code line by line to identify any syntax errors or logical mistakes

• Using print statements to output variable values and check for unexpected results

• Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues

• Testing the macro with different inputs to
Answered by AI
Add your answer
Q3. How big data handled by you
Ans. 
I handle big data by using advanced analytics tools and techniques to extract valuable insights.
• Utilize data visualization tools like Tableau or Power BI to analyze and present data

• Use programming languages like Python or R for data manipulation and statistical analysis

• Implement machine learning algorithms to uncover patterns and trends in large datasets

• Leverage cloud computing platforms like AWS or Google Cloud for sc...read more
Answered by AI
Add your answer

Leetcode easy to medium questions

Q1. Different types of sorting algorithms
Ans. 
Sorting algorithms are methods used to arrange elements in a list in a specific order.
• Bubble Sort - compares adjacent elements and swaps them if they are in the wrong order

• Merge Sort - divides the list into smaller sublists, sorts them, and then merges them back together

• Quick Sort - selects a 'pivot' element and partitions the list into two sublists around the pivot

• Insertion Sort - builds the final sorted list one elem...read more
Answered by AI
Add your answer
Q2. Question of increasing subsequence
Add your answer
Q3. Data Structure and Algorithms, OOPs , Operating System and DBMS questions
Add your answer

Q1. 2nd highest Salary SQL question
Add your answer
Q2. Project related questions
Add your answer
Q3. SQL ,DBMS questions
Add your answer

Q1. Why you want to join this company?
Add your answer
Q2. What are your positive and negative qualities?
Add your answer

Having 10 mcqs with 2 coding questions of medium level

Q1. Find missing number from 1 to n without using extra space and O(n) tc
Ans. 
Find missing number from 1 to n without using extra space and O(n) tc
• Use XOR operation to find the missing number

• Iterate through the array and XOR each element with its index and the result

• The missing number will be the final result after XORing all elements and indices
Answered by AI
Add your answer

General aptitude questions

Q1. Some behavior questions with company values
Add your answer