Bajaj Finserv Data Engineer Interview Questions and Answers for Freshers

Q1. Investment banks mostly ask multithreading questions or core concepts of java language.
Add your answer

Q1. In 2nd round also, they asked java and spring related questions.
Add your answer

There was one coding round that contains one average type algo and we have to write the program for that.

DSA round was the first round in the coding test

Q1. It mainly focused on core Java principles
Add your answer
Q2. Ooops principales spring boot spring security
Add your answer

Q1. Coding related usual questions available on leetcode
Add your answer

Q1. Coding related usual questions available on leetcode
Add your answer

Q1. Usual managerial questions. Easy round.
Add your answer

Q1. Java Api debugging.
Add your answer
Q2. DSA coding question with modifications
Add your answer

Q1. Ai parking management system design
Ans. 
Designing an AI parking management system to optimize parking space usage and improve efficiency.
• Utilize sensors to detect available parking spaces in real-time

• Implement machine learning algorithms to predict parking demand and optimize space allocation

• Integrate with mobile apps for users to easily find and reserve parking spots

• Use computer vision for license plate recognition and enforcement of parking rules
Answered by AI
Add your answer

Q1. Behavioral questions
Add your answer

Q1. Explain difference between numpy array and list
Ans. 
Numpy arrays are more efficient for numerical operations compared to lists.
• Numpy arrays are homogeneous in nature, while lists can contain different data types.

• Numpy arrays support vectorized operations, making them faster for numerical computations.

• Numpy arrays require less memory compared to lists for large datasets.

• Example: np_array = np.array([1, 2, 3]) vs list = [1, 2, 3]
Answered by AI
Add your answer
Q2. Coding question: Reverse words in sentence
Add your answer

Q1. Covid Case Study
Add your answer
Q2. Merge two dataframe
Ans. 
Merging two dataframes combines them into a single dataframe based on a common column or index.
• Use the merge() function in pandas library in Python to merge dataframes

• Specify the common column or index to merge on

• Choose the type of join (inner, outer, left, right) based on your requirement
Answered by AI
Add your answer

DFS questions, and Python coding challenge

Q1. Python technical questions
Add your answer

Q1. What are the windows functions in sql
Ans. 
Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.
• Window functions are used to calculate running totals, moving averages, and rank values.

• They are applied to a set of rows defined by an OVER clause.

• Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Answered by AI
Add your answer
Q2. Explain CTE in detail
Ans. 
CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTE is defined using the WITH keyword followed by a name and a SELECT statement.

• It can be used to simplify complex queries, improve readability, and reduce code duplication.

• CTE can also be recursive, allowing for hierarchical queries.

• Example: WITH sales AS (SELECT * FROM order...read more
Answered by AI
Add your answer

Q1. What is your expected salary
Add your answer

Basic code to be written