IDFC FIRST Bank Data Engineer Interview Questions and Answers

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

Behavioural and culture fit

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

Easy on cyber security

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

Good went well nicce process

Medium level questions

Q1. Asked about core subjects
Add your answer
Q2. Asked about my project
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

Q1. SQL Basics and Good Communication
Add your answer
Q2. Structured Profile Summary
Add your answer