i
HDFC Bank
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
I was interviewed in Dec 2024.
2nd with VP which is easy but he seems not okay with my ECTC
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
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.
I applied via Referral and was interviewed before Oct 2023. There were 2 interview rounds.
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.
...
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
What people are saying about HDFC Bank
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.
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.
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...
HDFC Bank interview questions for designations
I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.
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.
Behavioural and culture fit
I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.
SQL server
SQL DBA
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
Easy on cyber security
based on 3 interviews
Interview experience
based on 8 reviews
Rating in categories
Deputy Manager
15.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
10.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
9.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Relationship Manager
6.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Manager
6.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
ICICI Bank
State Bank of India
Axis Bank
Kotak Mahindra Bank