HSBC Group Data Manager Interview Questions and Answers

Basic aptitude test like distance problem , age etc

Q1. Explain error handling in PySpark
Ans. 
Error handling in PySpark involves using try-except blocks and logging to handle exceptions and errors.
• Use try-except blocks to catch and handle exceptions in PySpark code

• Utilize logging to record errors and exceptions for debugging purposes

• Consider using the .option('mode', 'PERMISSIVE') method to handle corrupt records in data processing
Answered by AI
Add your answer

Q1. Data Warehousing related questions
Add your answer

Q1. Data Modelling related questions
Add your answer

I was asked Python, sql, coding questions

Case study on how would you identify the total number of footfall on a airport

Q1. Asked about skillsets & tools used in the current job. I was asked basic questions on SQL & Tableau
Add your answer

Detailed interview on SQL, Tableau & Alteryx

Q1. How would you decide if a person can be a customer of a private jet company
Ans. 
To determine if a person can be a customer of a private jet company, factors such as income level, travel frequency, and location must be considered.
• Consider the individual's income level to determine if they can afford private jet services

• Evaluate the person's travel frequency to see if they would benefit from the convenience of private jet travel

• Take into account the person's location and travel destinations to asses
Answered by AI
Add your answer

Q1. Money you want for this position
Add your answer
Q2. Why to choose this position and not another
Add your answer

2 questions based on Algorithm and logic

Q1. Questions on basic python, hadoop, sql etc
Add your answer

Asked questions from python and SQL

Q1. What are tupples
Ans. 
Tuples are ordered collections of elements, similar to lists but immutable.
• Tuples are created using parentheses ()

• Elements in a tuple can be of different data types

• Tuples are immutable, meaning their elements cannot be changed once created
Answered by AI
Add your answer
Q2. What is credit risk
Ans. 
Credit risk refers to the potential loss that a lender may incur due to a borrower's failure to repay a loan or meet their financial obligations.
• Credit risk is the risk of default on a debt that may arise from a borrower failing to make required payments.

• It is a key consideration for banks and financial institutions when lending money.

• Factors that contribute to credit risk include the borrower's credit history, financi...read more
Answered by AI
Add your answer