HSBC Group Senior Project Manager Interview Questions and Answers

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.

Corporate actions are events initiated by a company that can affect its stock price and shareholders.

• Types of corporate actions include dividends, stock splits, mergers and acquisitions, spin-offs, and rights issues.

• Dividends are payments made to shareholders from a company's profits.

• Stock splits increase the number of shares outstanding while decreasing the price per share.

• Mergers and acquisitions involve the combinat...read more

Swift is a messaging system used for financial transactions. It has different types and fields for message processing.

• Swift messages are categorized into 5 types - MT0xx, MT1xx, MT2xx, MT3xx, and MT9xx

• Each type has its own set of fields for message processing

• For example, MT103 is used for Single Customer Credit Transfer and has fields like Sender's Reference, Receiver's Reference, Amount, Currency, etc.