HSBC Securities and Capital Markets Analyst Interview Questions and Answers

Q1. Difference between rank & dense rank
Ans. 
Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.
• Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

• For example, if there are two rows with the same value and rank 1, the n...read more
Answered by AI
Add your answer
Q2. Given two tables Tell how many values would be there for left right inner outer join
Ans. 
The number of values in different types of joins depends on the relationship between the tables.
• In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

• In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...read more
Answered by AI
Add your answer
Q3. Find the newest customer id for every product
Ans. 
Use SQL query to find the newest customer id for every product
• Use GROUP BY clause to group by product

• Use MAX() function to find the newest customer id for each product

• Join the tables if necessary
Answered by AI
Add your answer

Q1. What is equity ?
Ans. 
Equity represents ownership in a company and is calculated as assets minus liabilities.
• Equity is the value of an asset after deducting any liabilities associated with that asset.

• It represents the ownership interest in a company.

• Equity can be in the form of common stock, preferred stock, or retained earnings.

• Investors use equity to assess the financial health and performance of a company.

• Equity can also refer to fairnes
Answered by AI
Add your answer
Q2. What is derivatives?
Ans. 
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
• Derivatives can be used for hedging, speculation, or arbitrage.

• Common types of derivatives include options, futures, forwards, and swaps.

• Derivatives allow investors to take on leverage and potentially amplify returns.

• They are traded on exchanges or over-the-counter (OTC) markets.

• Derivatives are used in various indus...read more
Answered by AI
Add your answer

Q1. About current role
Add your answer
Q2. Roles and responsibilities
Add your answer

Q1. Inndepth about skill
Add your answer
Q2. What is your hands on experience
Add your answer

Q1. About aml kyc Sanction screening
Add your answer
Q2. Stages of money laundering, structuring fifo
Ans. 
Money laundering involves three main stages: placement, layering, and integration. Structuring involves breaking up large transactions into smaller ones to avoid detection.
• Placement: The initial stage where illegal funds are introduced into the financial system, often through cash deposits or investments.

• Layering: The process of moving the funds through a series of complex financial transactions to obscure their origin...read more
Answered by AI
Add your answer

Detailed case study on Market Entry, Business Process Optimisation and Value Steam Mapping

Q1. Technical Questions regarding Advanced Excel, Power BI, Tableau
Add your answer

Case Study on Market Entry

Q1. Case Study plus organisation fit round.
Add your answer

Q1. Past experience
Add your answer

Q1. Guestimate about cars in city
Add your answer

Basic coding based on job profile

Q1. More about project
Add your answer

Q1. Salary negotiation
Add your answer