HDB Financial Services Interview Questions, Process, and Tips

Reasoning , SQL and probability

Q1. SQL queries and python
Add your answer
Q2. Reasoning and guesstimate
Add your answer

Q1. What are your reasons for wanting to switch jobs?
Add your answer

Optional questions of reasoning maths and science

Optional questions of reasoning maths and English

Q1. Why did you leave your last job
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why u want this target job
Add your answer

Q1. Excel and Sql basic and advanced problems
Add your answer
Q2. How to use Vlookup ?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in a cell

• lookup_value is the value to search for in the first column of the table_array

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table_array from which to retr...read more
Answered by AI
Add your answer
Q3. How to use Splitting?
Ans. 
Splitting is a technique used to divide a string into multiple parts based on a specified delimiter.
• Use the split() method in programming languages like Python, JavaScript, or Java to split a string into an array of substrings.

• Specify the delimiter (e.g. space, comma, hyphen) as an argument to the split() method.

• Access the individual parts of the split string using array indexing.

• Combine splitting with other string man...read more
Answered by AI
Add your answer
Q4. How to use pivot ?
Ans. 
Pivot is a function used in data analysis to summarize and reorganize data.
• Pivot can be used to reorganize rows into columns or columns into rows based on a specific variable.

• It is commonly used in Excel or other spreadsheet software to create summary tables or reports.

• Pivot tables can help analyze large datasets and identify trends or patterns.

• Example: In Excel, you can use the PivotTable feature to summarize sales da
Answered by AI
Add your answer
Q5. How to use concatenation?
Ans. 
Concatenation is the process of combining two or more strings together.
• Use the + operator to concatenate strings in most programming languages.

• In SQL, use the CONCAT function to concatenate strings.

• Concatenation can also be done using string interpolation in some languages.
Answered by AI
Add your answer