HSBC Group Interview Questions, Process, and Tips

Q1. Introduction by my self
Add your answer
Q2. Pyspark related getting the column names
Add your answer

Q1. SOLID Principle
Add your answer
Q2. Throw vs throw ex
Ans. 
throw vs throw ex is used in exception handling in C#
• throw is used to rethrow the current exception without losing the original stack trace

• throw ex is used to throw a new exception while preserving the original exception information

• It is recommended to use throw without specifying ex to avoid losing important exception details
Answered by AI
Add your answer

Q1. What is stressed exit?
Ans. 
Stressed exit refers to the process of an employee voluntarily leaving a company due to work-related stress.
• Occurs when an employee feels overwhelmed or burnt out from work

• May result from excessive workload, lack of support, or toxic work environment

• Can lead to decreased productivity and morale within the team

• Employers should address the root causes of stress to prevent further exits
Answered by AI
Add your answer
Q2. What do you check in a business continuity plan?
Ans. 
A business continuity plan should include checks for critical business functions, communication strategies, data backup procedures, and testing protocols.
• Critical business functions and processes

• Communication strategies for internal and external stakeholders

• Data backup and recovery procedures

• Testing protocols to ensure the plan is effective

• Emergency response and escalation procedures
Answered by AI
Add your answer

Coding test was pretty easy

Q1. Reverse a string
Add your answer
Q2. About projects
Add your answer

Q1. Explain about yourself
Add your answer
Q2. Where do you see yourself in 5 years
Add your answer

Q1. What is lazy evaluation in spark.
Ans. 
Lazy evaluation in Spark delays the execution of transformations until an action is called.
• Lazy evaluation allows Spark to optimize the execution plan by combining multiple transformations into a single stage.

• Transformations are not executed immediately, but are stored as a directed acyclic graph (DAG) of operations.

• Actions trigger the execution of the DAG and produce results.

• Example: map() and filter() are transformat...read more
Answered by AI
Add your answer
Q2. What is mapreduce
Ans. 
MapReduce is a programming model and processing technique for parallel and distributed computing.
• MapReduce is used to process large datasets in parallel across a distributed cluster of computers.

• It consists of two main functions - Map function for processing key/value pairs and Reduce function for aggregating the results.

• Popularly used in big data processing frameworks like Hadoop for tasks like data sorting, searching...read more
Answered by AI
Add your answer

Q1. What is skewness and skewd tables
Ans. 
Skewness is a measure of asymmetry in a distribution. Skewed tables are tables with imbalanced data distribution.
• Skewness is a statistical measure that describes the asymmetry of the data distribution around the mean.

• Positive skewness indicates a longer tail on the right side of the distribution, while negative skewness indicates a longer tail on the left side.

• Skewed tables in data engineering refer to tables with imba...read more
Answered by AI
Add your answer

Q1. What is spark and explain working
Ans. 
Spark is a distributed computing framework designed for big data processing.
• Spark is built around the concept of Resilient Distributed Datasets (RDDs) which allow for fault-tolerant parallel processing of data.

• It provides high-level APIs in Java, Scala, Python, and R for ease of use.

• Spark can run on top of Hadoop, Mesos, Kubernetes, or in standalone mode.

• It includes modules for SQL, streaming, machine learning, and gra...read more
Answered by AI
Add your answer