Deutsche Bank Associate Data Engineer Interview Questions and Answers

Q1. Explain different type of SQL query?
Add your answer

Q1. Tell me about you experience as a data engineer
Add your answer
Q2. In depth technical discussion about projects
Add your answer

Q1. Load 60 GB of csv file and perform transformation.
Ans. 
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
• Use Apache Spark to distribute the workload across multiple nodes for faster processing.

• Utilize Spark's DataFrame API to read the CSV file and apply transformations.

• Consider partitioning the data to optimize performance.

• Use Spark SQL for complex transformations and aggregations.

• Leverage in-memory processing capabi
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer
Q2. SQL basics
Add your answer
Q3. Banking terms
Add your answer

Q1. What is data analyst
Ans. 
A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.
• Collects data from various sources

• Cleans and processes data to ensure accuracy

• Analyzes data using statistical methods and tools

• Interprets data to identify trends and patterns

• Presents findings and recommendations to stakeholders
Answered by AI
Add your answer
Q2. Asked question regarding project mention
Add your answer

Was asking to solve case study based on Python, find the relevant insights

Basic maths questions

Basic topics movies vs series

Q1. Sql Queries were asked
Add your answer
Q2. Was based on resume
Add your answer

Q1. Based on resume the questions were
Add your answer
Q2. Questions about family
Add your answer

Q1. Questions mainly involved window function, recursion, some puzzels
Add your answer