Bajaj Finserv Data Engineer Interview Questions and Answers

Quantitative And Reasoning questions

There is one code which u will have written in any language u are want.

Q1. Sql joins, window functions
Add your answer
Q2. Writing some queries in front of interviewer
Add your answer

Python features and implementation

Q1. Difference between while and for
Ans. 
While loop is used when the number of iterations is not known beforehand, while for loop is used when the number of iterations is known.
• While loop is entry-controlled, meaning the condition is checked before the loop body is executed.

• For loop is exit-controlled, meaning the condition is checked after the loop body is executed.

• While loop is used when the number of iterations is not known beforehand, for loop is used whe
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Q1. How would you design an API to receive messages at the specified URL?
Ans. 
Designing an API to receive messages at a specified URL
• Define the endpoint URL for receiving messages

• Implement authentication and authorization mechanisms to ensure secure access

• Use HTTP methods like POST for sending messages to the API

• Include error handling and response codes for different scenarios

• Consider implementing message queuing for handling high volumes of messages
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

Mostly asked stuff related to python and SQL as per the requirement of the role. Timing was around 1 pm, the environment and the interviewer were both suitable and friendly respectively.
The overall experience of the interview was great

Round duration - 15 minutes
Round difficulty - Easy

Asked team related question, the environment was ms teams, HR was friendly. Overall interview experience was great

Q1. We were asked to find mean, median and mode of a data and send it through an API link.
Add your answer

Was asked 10 MCQ and 1 coding question of easy difficulty.

Q1. This was technical interview 1 where I was asked about my knowledge on Data warehousing, Big data, Python. Was asked about my projects.
Add your answer

Q1. In Tech interview 2 I was asked a lot on SQL and Python and was grilled on abstract topic of data and its uses. Was grilled on my projects also.
Add your answer

Q1. I was asked to talk about anything other than academics. And was asked some basic HR questions.
Add your answer