HDFC Bank Human Resource Interview Questions and Answers

The first round which is online assessment for eliminating candidates was conducted consist of medium level aptitude questions there were 3 sub sec have duration of 20 15 15 minutes and questions 15 10 10 respectively and you cannot move to further section there is time constraints for each then followed by 15 minutes psychometric section having 50 questions that's all for screening round the total duration was 65 min.
Total 24 candidates were selected from this round out of 200 plus

Q1. Project and coding
Add your answer

Q1. Coding and problem solving
Add your answer

Q1. Scenario base problem solving
Add your answer

Q1. Negotiations Discussion with HR
Add your answer

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

Share banking working hours and work

Q1. Banking level questions
Add your answer
Q2. What is icic bnk rating ambitions level working ?
Ans. 
ICICI Bank aims to achieve high credit ratings to demonstrate financial stability and attract investors.
• ICICI Bank strives to maintain a strong credit rating to showcase financial health

• Higher credit ratings make the bank more attractive to investors

• Achieving high credit ratings reflects positively on the bank's financial stability

• ICICI Bank's rating ambitions indicate a focus on maintaining a strong financial position
Answered by AI
Add your answer

Pyspark, Hive, Yarn, Python

Q1. Questions on windowing function
Add your answer
Q2. Questions on spark arch and python
Add your answer

Normal coding questions

Q1. Big data questions , project architecture
Add your answer

Q1. Introduce yourself
Add your answer
Q2. Are you comfortable in night shift
Add your answer

Selected for final round

Q1. Why you want to join this job
Add your answer