Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by HDFC Bank Team. If you also belong to the team, you can get access from here

HDFC Bank Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

HDFC Bank Data Engineer Interview Questions, Process, and Tips

Updated 28 Jan 2025

Top HDFC Bank Data Engineer Interview Questions and Answers

HDFC Bank Data Engineer Interview Experiences

4 interviews found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2024.

Round 1 - Technical 

(1 Question)

  • Q1. I was asked to write code and some scenario based question on Big Data etc
Round 2 - Case Study 

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

Interview Preparation Tips

Interview preparation tips for other job seekers - HDFC dont offer good ctc and what i understood from them till now they are more using legacy system and relied on lot of vendors

1). Prepare well on Pyspark, Lakehouse Arch
2).Basic Sql & bit case studies

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Jan 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What are joins of sql
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. Explain about self join
  • Ans. 

    Self join is a SQL technique where a table is joined with itself to compare rows within the same table.

    • Self join is used when we want to compare rows within the same table.

    • It requires aliasing the table with different names to differentiate between the two instances.

    • Commonly used in hierarchical data structures or when comparing related records.

  • Answered by AI

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain spark stages and tasks
  • Ans. 

    Spark stages are a collection of tasks that are executed together to perform a specific computation.

    • Stages are created based on the transformations and actions in a Spark job.

    • Each stage consists of a set of tasks that can be executed in parallel.

    • Stages are divided into two types: narrow (one-to-one) and wide (one-to-many) transformations.

    • Tasks within a stage are executed on different partitions of the data in parallel.

    • ...

  • Answered by AI
  • Q2. Sql windoq questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. Advance delta table optimizatoins
  • Q2. Data modelling in previous project
  • Ans. 

    Implemented data modelling using star schema in a retail analytics project.

    • Designed star schema to optimize query performance

    • Used fact and dimension tables to organize data

    • Implemented ETL processes to populate the data warehouse

    • Utilized tools like SQL, Python, and Apache Spark for data modelling

  • Answered by AI

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 23 Nov 2022

I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • 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
  • 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...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. What is your expected salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL in detail. Practice scenario based SQL questions. Read all the data warehousing concepts in detail.

Skills evaluated in this interview

HDFC Bank interview questions for designations

 Data Analyst

 (10)

 Data Scientist

 (4)

 Data Science

 (1)

 Data Operator

 (1)

 Data Entry Operator

 (13)

 Senior Data Analyst

 (1)

 Data Scientist Intern

 (1)

 Data Entry jobs

 (1)

Interview questions from similar companies

I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About your self

Interview Preparation Tips

Interview preparation tips for other job seekers - please select my profile

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • 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
Round 2 - Behavioral interview 

(1 Question)

  • Q1. Tell me a time you resolve conflict
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Behavioural and culture fit

I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Coding Test 

SQL server

Round 2 - Coding Test 

SQL DBA

Round 3 - HR 

(1 Question)

  • Q1. Salary discussed, Appts test

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best... be prepared question
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Assignment 

Easy on cyber security

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduce yourself this is
  • Q2. What is your work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Contribute & help others!
anonymous
You can choose to be anonymous

HDFC Bank Interview FAQs

How many rounds are there in HDFC Bank Data Engineer interview?
HDFC Bank interview process usually has 2 rounds. The most common rounds in the HDFC Bank interview process are One-on-one Round, Technical and Case Study.
How to prepare for HDFC Bank Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at HDFC Bank. The most common topics and skills that interviewers at HDFC Bank expect are Auditing, Azure, Business Intelligence, Data Warehousing and Devops.
What are the top questions asked in HDFC Bank Data Engineer interview?

Some of the top questions asked at the HDFC Bank Data Engineer interview -

  1. What are the windows functions in ...read more
  2. data modelling in previous proj...read more
  3. what are joins of ...read more

Recently Viewed

DESIGNATION

DESIGNATION

INTERVIEWS

HDFC Bank

No Interviews

INTERVIEWS

HDFC Bank

No Interviews

INTERVIEWS

HDFC Bank

No Interviews

INTERVIEWS

Medley Pharmaceuticals

No Interviews

INTERVIEWS

ICICI Bank

No Interviews

INTERVIEWS

HDFC Bank

No Interviews

DESIGNATION

INTERVIEWS

Google

No Interviews

Tell us how to improve this page.

HDFC Bank Data Engineer Interview Process

based on 3 interviews

Interview experience

3.3
  
Average
View more
HDFC Bank Data Engineer Salary
based on 85 salaries
₹4.2 L/yr - ₹17.3 L/yr
At par with the average Data Engineer Salary in India
View more details

HDFC Bank Data Engineer Reviews and Ratings

based on 8 reviews

3.6/5

Rating in categories

2.8

Skill development

2.9

Work-life balance

2.3

Salary

4.6

Job security

2.5

Company culture

1.9

Promotions

2.4

Work satisfaction

Explore 8 Reviews and Ratings
Deputy Manager
15.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
10.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
9.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
6.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Manager
6.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare HDFC Bank with

ICICI Bank

4.0
Compare

State Bank of India

3.8
Compare

Axis Bank

3.8
Compare

Kotak Mahindra Bank

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview