IDFC FIRST Bank Data Engineer Interview Questions and Answers

Q1. I was asked to write code and some scenario based question on Big Data etc
Add your answer

2nd with VP which is easy but he seems not okay with my ECTC

Q1. What is an index and what does it do
Ans. 
An index is a data structure that improves the speed of data retrieval operations in a database by allowing quick access to specific data.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on specific columns in a table to speed up queries that filter or sort by those columns.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer

Q1. Tell me a time you resolve conflict
Add your answer

Spark Sql and Spark Scripting

Data Modelling for retail brand like dmart

ETL Pipeline which handles streaming data as well

Easy on cyber security

Q1. Introduce yourself this is
Add your answer
Q2. What is your work experience
Add your answer

Q1. Java Stream coding questions
Add your answer
Q2. Java Collections
Add your answer
Q3. Spring Boot Annotations
Add your answer
Q4. Sql Queries highest 3 salary employee name
Ans. 
Use SQL query to retrieve the names of the top 3 employees with the highest salary.
• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the top 3.

• Join the employee table with the salary table to retrieve employee names.
Answered by AI
Add your answer

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

Q1. Technical questions related to security
Add your answer

Basic intro and getting to know

1 project to do research and present to the team