HSBC Group
200+ Interview Questions and Answers
You are given a singly Linked List of integers. Your task is to return true if the given singly linked list is a palindrome otherwise returns false.
For example:
The given linked list is ...read more
You have been given an array “ARR” of integers and an integer ‘K’. Your task is to find a pair of distinct indices ‘i’ and ‘j’ such that ARR[i] == ARR[j] and | i - j | <= ‘K’.
Input Format :
T...read more
You have been given a 2-D array 'MAT' of size M x N where 'M' and 'N' denote the number of rows and columns, respectively. The elements of each row are sorted in non-decreasing order.
Moreo...read more
Given a Binary Tree with integer nodes, your task is to find the maximum level sum among all the levels in the Binary Tree. The sum of any level...read more
You are given a Singly Linked List of integers. You need to reverse the Linked List by changing the links between nodes.
Input Format :
The first line of input contains a single integer T, re...read more
You are given a singly Linked List of integers. Your task is to return true if the given singly linked list is a palindrome otherwise returns false.
For example:
The given linked list is 1...read more
Q7. Which is field for bank to bank instructions in MT700?
The field for bank to bank instructions in MT700 is 47A.
Field 47A is used for bank to bank instructions in MT700.
It is an optional field that can be used to provide additional instructions to the beneficiary bank.
Examples of instructions that can be included in this field are payment terms, shipping instructions, and other special instructions.
The format of the instructions should be agreed upon between the banks involved in the transaction.
For a given integer array/list 'ARR' of size 'N' containing all distinct values, find the total number of 'Inversions' that may exist.
An inversion is defined for a pair of integers in the array...read more
Q9. How will you find the top 5 customer of HSBC from the entire world?
Top 5 customers of HSBC can be found by analyzing transaction history and account balances.
Analyze transaction history of all HSBC customers worldwide
Identify customers with highest transaction volumes and account balances
Rank customers based on transaction volumes and account balances
Select top 5 customers based on ranking
Consider other factors such as creditworthiness and profitability
Write a program to find x to the power n (i.e., x^n). Take x and n from the user. You need to print the answer.
Note: For this question, you can assume that 0 raised to the power of 0 is 1...read more
Q11. Technical : 1. What is hedge/mutual fund ? 2. What is equalization payment ? 3. What are corporate actions and its types ? 4. Basic accrual journals 5. What are trading participants ( stock exch, clearing house...
read moreAnswers to technical questions related to fund administration.
Hedge funds are alternative investment vehicles that use various strategies to generate high returns.
Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of securities.
Equalization payment is a payment made to investors in a mutual fund to ensure that all investors receive the same distribution of income and capital gains.
Corporate actions are events init...read more
Which data structures are used for implementing LRU cache?
Ninja is a genius in mathematics. He got an interview call from MIT. During the interview, the professor asked Ninja a challenging question.
Given two integers 'N1' and 'N2', the professor ...read more
Given a linked list, whose nodes represent the coordinates of the cartesian plane. Find the minimum and the maximum slope of simultaneous points of coordinates.
Linked List : P1(X1, Y1) -> P2( X2, Y2)...read more
Q15. One puzzles--How to calculate the average no of person coming to the airport daily?
The average number of people coming to the airport daily can be calculated by taking the total number of people arriving and departing and dividing it by two.
Collect data on the number of arrivals and departures for a given period, such as a week or a month.
Add the number of arrivals and departures together to get the total number of people coming to the airport.
Divide the total number by the number of days in the period to get the average number of people coming to the airpo...read more
What do you understand by functional dependency and transitive dependency in DBMS?
Q17. What do you mean from sanctions and embargo If we have to adjust 100 billion/ million money in the economy and suppse we have 3 months time. What all can we do to apportionment and allocation of given money tha...
read moreWhat is normalization and what are the different types of normalization?
Q19. What are all basic documents required for LC issuance.
Basic documents required for LC issuance
Commercial invoice
Bill of lading
Packing list
Insurance certificate
Certificate of origin
Proforma invoice
Purchase order
Letter of credit application
Beneficiary certificate
Q20. How to find the no of petrol pump in the city
Use online maps or directories to find the number of petrol pumps in the city.
Search for petrol pumps on online maps like Google Maps or MapQuest.
Use online directories like Yelp or Yellow Pages to find petrol pumps in the city.
Check with local authorities or city websites for a list of petrol pumps in the area.
Ask locals or taxi drivers for recommendations on petrol pumps in the city.
Q21. Can we send MT734 for second time quoting additional discrepancies?
Yes, MT734 can be sent for the second time with additional discrepancies.
MT734 is a message type used in banking for the issuance of a letter of credit.
It can be sent multiple times with additional discrepancies until the issuing bank accepts the discrepancies.
However, it is important to ensure that the discrepancies are genuine and not fabricated.
Sending multiple MT734s can delay the process and may result in additional charges.
It is advisable to consult with the issuing ban...read more
What is a bootstrap program in OS?
How is an abstract class different from an interface?
What is IPC? What are the different IPC mechanisms?
Q25. 2. What is is difference between incoterms 2010 and 2020?
Incoterms 2020 has some new rules and changes compared to Incoterms 2010.
Incoterms 2020 has introduced a new Incoterm called DPU (Delivered at Place Unloaded)
Incoterms 2020 has changed the level of insurance required for CIF (Cost, Insurance and Freight) and CIP (Carriage and Insurance Paid To)
Incoterms 2020 has clarified the responsibilities of buyers and sellers in relation to security-related requirements
Incoterms 2020 has updated the FCA (Free Carrier) rule to allow for b...read more
Q26. What are check points in LC application and contract?.
Check points in LC application and contract ensure compliance with terms and conditions.
Check points are specific milestones or events that must be met or completed during the LC application and contract process.
They ensure that all parties involved are complying with the terms and conditions of the LC.
Examples of check points include submission of required documents, verification of information, and confirmation of payment.
Check points help to minimize risk and ensure a smoo...read more
Q27. What is DBMS and RDBMS and difference between them?
DBMS stands for Database Management System, while RDBMS stands for Relational Database Management System. RDBMS is a type of DBMS.
DBMS is a software system that allows users to define, create, maintain and control access to the database.
RDBMS is a type of DBMS that stores data in a structured format using tables with rows and columns.
RDBMS enforces a set of rules called ACID properties to ensure data integrity, while DBMS may not necessarily enforce these rules.
Examples of DB...read more
How is a stack different from a queue?
Q29. What are check points from compliance perspective for LC issuance.
Check points for LC issuance from compliance perspective
Verify the authenticity of the LC application and supporting documents
Ensure compliance with local and international laws and regulations
Conduct due diligence on the parties involved in the transaction
Verify the accuracy of the LC terms and conditions
Ensure proper documentation and record keeping
Monitor and report any suspicious activities or transactions
Q30. 1. What is udf in Spark? 2. Write PySpark code to check the validity of mobile_number column
UDF stands for User-Defined Function in Spark. It allows users to define their own functions to process data.
UDFs can be written in different programming languages like Python, Scala, and Java.
UDFs can be used to perform complex operations on data that are not available in built-in functions.
PySpark code to check the validity of mobile_number column can be written using regular expressions and the `regexp_extract` function.
Example: `df.select('mobile_number', regexp_extract('...read more
Q31. Who can sign an insurance policy/certificate?
An insurance policy/certificate can be signed by the insured, the insurer, and a licensed agent or broker.
The insured is the person or entity purchasing the insurance policy/certificate.
The insurer is the company providing the insurance coverage.
A licensed agent or broker can also sign the policy/certificate on behalf of the insured or insurer.
The signature of all parties involved is necessary to make the policy/certificate legally binding.
For example, if John purchases a car...read more
Q32. What are the lions of HSBC? Do you know the symbol and story behind it?
The lions of HSBC are a symbol of strength and stability. They represent the bank's commitment to its customers.
The lions are a pair of bronze statues that stand guard outside HSBC's headquarters in London.
They were designed by sculptor Nick Elphick and installed in 2002.
The lions are modeled after the original lions that stood outside the bank's Shanghai office in the early 20th century.
The lions are a symbol of the bank's heritage and its commitment to its customers.
The lio...read more
Q33. How to understand customer behaviour based on credit card transaction? What would be your approach?
To understand customer behaviour based on credit card transaction, I would analyze spending patterns, transaction frequency, and purchase categories.
Analyze spending patterns to identify high and low spenders
Analyze transaction frequency to identify regular and irregular customers
Analyze purchase categories to identify customer preferences and interests
Use data visualization tools to identify trends and patterns
Compare customer behavior to industry benchmarks and competitors
I...read more
What is meant by static polymorphism?
Q35. Sanctions screen and type of risks and different sanctions
Q36. Merge two unsorted lists such that the output list is sorted. You are free to use inbuilt sorting functions to sort the input lists
Merge two unsorted lists into a sorted list using inbuilt sorting functions.
Use inbuilt sorting functions to sort the input lists
Merge the sorted lists using a merge algorithm
Return the merged and sorted list
Q37. What are the 4 pillars of OOPs?
Encapsulation, Inheritance, Polymorphism, Abstraction
Encapsulation: Bundling data and methods that operate on the data into a single unit
Inheritance: Ability of a class to inherit properties and behavior from another class
Polymorphism: Ability to present the same interface for different data types
Abstraction: Hiding the complex implementation details and showing only the necessary features
What is the difference between overloading and overriding?
Q39. what is the difference between clustering and classification.
Clustering groups data points based on similarity while classification assigns labels to data points based on predefined categories.
Clustering is unsupervised learning while classification is supervised learning.
Clustering is used to find patterns in data while classification is used to predict the category of a data point.
Examples of clustering algorithms include k-means and hierarchical clustering while examples of classification algorithms include decision trees and logist...read more
Q40. How to ingest csv file to spark dataframe and write it to hive table.
Ingest CSV file to Spark dataframe and write to Hive table.
Create SparkSession object
Read CSV file using SparkSession.read.csv() method
Create a dataframe from the CSV file
Create a Hive table using SparkSession.sql() method
Write the dataframe to the Hive table using dataframe.write.saveAsTable() method
Q41. What is Enterprise Value of a firm and how to calculate
Enterprise Value is the total value of a company, including debt and equity.
Enterprise Value = Market Capitalization + Debt - Cash
Market Capitalization = Total number of shares outstanding x current market price per share
Debt = Total outstanding debt of the company
Cash = Total cash and cash equivalents held by the company
EV is used to determine the true value of a company, as it takes into account both debt and equity
EV can be used to compare companies with different capital ...read more
Q42. What is Object oriented programming?
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
Objects are instances of classes, which define the structure and behavior of the objects.
Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.
Example: Inheritance allows a class to inherit properties and methods from another class.
Example: Encapsulation hides the internal state of an object and only exposes necessary ...read more
What are Private and Special IP addresses?
What is meant by normalization and denormalization?
Q45. SQL query for getting 2nd highest salary from each department
SQL query to retrieve the second highest salary from each department
Use the RANK() function to assign a rank to each salary within each department
Filter the results to only include rows with a rank of 2
Group the results by department to get the second highest salary for each department
Q46. What are the sanction country, how risk is calculated, constitution documents required for like Pvt Ltd, partnership, limited co. , Nri documents , onboarding process.
Sanctioned countries, risk calculation, and required documents for onboarding different types of entities and NRIs.
Sanctioned countries include Iran, North Korea, Syria, and others.
Risk is calculated based on factors such as the country's political stability, economic conditions, and regulatory environment.
Constitution documents required for Pvt Ltd, partnership, and limited co. include certificate of incorporation, partnership deed, and memorandum of association.
NRI document...read more
Q47. How to delete duplicate rows from a table
To delete duplicate rows from a table, use the DISTINCT keyword or GROUP BY clause.
Use the DISTINCT keyword to select unique rows from the table.
Use the GROUP BY clause to group the rows by a specific column and select the unique rows.
Use the DELETE statement with a subquery to delete the duplicate rows.
Create a new table with the unique rows and drop the old table.
Q48. Write down code implementing all 4 pillars of OOPs.
Code implementing all 4 pillars of OOPs
Encapsulation: Encapsulate data within classes and provide public methods to access and modify the data.
Inheritance: Create a hierarchy of classes where child classes inherit attributes and methods from parent classes.
Polymorphism: Allow objects of different classes to be treated as objects of a common superclass through method overriding and overloading.
Abstraction: Hide complex implementation details and only show the necessary feature...read more
Q49. What is SQL and who its different from mySQL?
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL stands for Structured Query Language and is used to communicate with databases.
SQL is a standard language that can be used with various database management systems.
MySQL is a specific open-source relational database management system that uses SQL.
MySQL is one of the most popular database management systems that uses SQL for querying and managing ...read more
Q50. What are different types of join? And how they differ from each other?
Different types of join include inner, outer, left, right, cross, and self join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables and null values for non-matching rows.
Left join returns all rows from the left table and null values for non-matching rows from the right table.
Right join returns all rows from the right table and null values for non-matching rows from the left table.
Cross join returns the Cartesian product of b...read more
Q51. Tell me about some important event in terms of economics and how it has affected the markets?
The 2008 financial crisis had a significant impact on the global markets.
The 2008 financial crisis was triggered by the collapse of Lehman Brothers, a major investment bank.
It led to a severe credit crunch and a global recession.
Stock markets around the world experienced sharp declines, with the Dow Jones Industrial Average losing over 50% of its value.
The crisis exposed weaknesses in the financial system and led to increased regulation and reforms.
Central banks implemented u...read more
Q52. What are the window functions you have used?
Window functions are used to perform calculations across a set of rows that are related to the current row.
Commonly used window functions include ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and NTILE.
Window functions are used in conjunction with the OVER clause to define the window or set of rows to perform the calculation on.
Window functions can be used to calculate running totals, moving averages, and other aggregate calculations.
Window functions are s...read more
Q53. Write a code to find the 2nd largest element in an array.
Code to find the 2nd largest element in an array
Sort the array in descending order and return the element at index 1
Iterate through the array and keep track of the two largest elements
Handle edge cases like arrays with less than 2 elements
Q54. Describe the situation when someone used your computer without informing you?
I was frustrated when someone used my computer without informing me.
I discovered that someone had used my computer without my knowledge.
I felt frustrated and violated because my personal space was invaded.
I confronted the person and asked them why they used my computer without informing me.
I emphasized the importance of respecting personal boundaries and seeking permission before using someone else's belongings.
I took measures to ensure the security of my computer and persona...read more
Q55. How do you handles null values in PySpark
Null values in PySpark are handled using functions such as dropna(), fillna(), and replace().
dropna() function is used to drop rows or columns with null values
fillna() function is used to fill null values with a specified value or method
replace() function is used to replace null values with a specified value
coalesce() function is used to replace null values with the first non-null value in a list of columns
Explain the difference between the DELETE and TRUNCATE command in a DBMS.
Q57. How to make pivot table range auto and how to adjust pivot to not show nil value.
To make pivot table range auto, select the data range and press Ctrl + T. To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.
To make pivot table range auto, select the data range and press Ctrl + T.
To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.
Q58. Why is enterprise value more important than an equity value, tell the difference between the two
Enterprise value is more important than equity value as it includes debt and cash, giving a more accurate picture of a company's total value.
Enterprise value takes into account a company's debt and cash, while equity value only considers the value of the company's shares.
Enterprise value is a more comprehensive measure of a company's total value, as it reflects the cost of acquiring the entire business.
Equity value can be misleading as it does not account for a company's debt...read more
Q59. How the connect two grids which are different frequencies?
Q60. What is imputer function in PySpark
Imputer function in PySpark is used to replace missing values in a DataFrame.
Imputer is a transformer in PySpark ML library.
It replaces missing values in a DataFrame with either mean, median, or mode of the column.
It can be used with both numerical and categorical columns.
Example: imputer = Imputer(inputCols=['col1', 'col2'], outputCols=['col1_imputed', 'col2_imputed'], strategy='mean')
Example: imputed_df = imputer.fit(df).transform(df)
Q61. How did you implement transformational changes explain with example
Implemented transformational changes through clear communication, collaboration, and a focus on the end goal.
Identified areas for improvement and set clear goals
Engaged stakeholders and communicated the vision for change
Collaborated with team members to develop and implement new processes
Provided training and support to ensure successful adoption of changes
Measured and evaluated the impact of changes to ensure success
Example: Implemented a new project management system that s...read more
Q62. Case studies how to target customers based on data base
Targeting customers based on database requires analyzing data and creating personalized campaigns.
Analyze customer data to identify patterns and preferences
Segment customers based on demographics, behavior, and interests
Create personalized campaigns using targeted messaging and offers
Use A/B testing to optimize campaigns and improve results
Q63. What is field 43T in MT700?
Field 43T in MT700 is used for the bank's reference number.
Field 43T is an optional field in MT700.
It is used by the bank to assign a reference number to the transaction.
The reference number can be used by the bank to track the transaction.
The format of the reference number is not specified in the MT700 standard.
The reference number can be alphanumeric and can have a maximum length of 16 characters.
Q64. Difference between C and C++?
C is a procedural programming language while C++ is an object-oriented programming language.
C is a procedural programming language, while C++ supports both procedural and object-oriented programming.
C does not have classes and objects, while C++ does.
C does not support function overloading, while C++ does.
C does not have exception handling, while C++ does.
C does not have namespaces, while C++ does.
Q65. Finance elective of first term – What are the different ratios? What ratios to apply in different sectors?
Different ratios used in finance and their application in different sectors.
Different ratios used in finance include liquidity ratios, profitability ratios, solvency ratios, and efficiency ratios.
Liquidity ratios measure a company's ability to meet short-term obligations, such as the current ratio and quick ratio.
Profitability ratios assess a company's ability to generate profits, such as return on equity and gross profit margin.
Solvency ratios evaluate a company's long-term ...read more
Q66. What are different types of banking products?
Banking products include savings accounts, checking accounts, loans, credit cards, and investment accounts.
Savings accounts: earn interest on deposited funds
Checking accounts: used for daily transactions and bill payments
Loans: borrowed money with interest
Credit cards: allows purchases on credit with interest
Investment accounts: used to invest in stocks, bonds, and mutual funds
Q67. Difference between Delete, Truncate and Drop?
Delete removes specific rows from a table, Truncate removes all rows from a table, and Drop removes the table itself.
Delete is a DML command that removes specific rows from a table based on a condition.
Truncate is a DDL command that removes all rows from a table but keeps the table structure.
Drop is a DDL command that removes the entire table along with its structure.
Q68. How can a company remove its debt but not affect the cash flow?
A company can remove its debt without affecting cash flow by refinancing debt at lower interest rates, increasing revenue, or selling assets.
Refinance debt at lower interest rates to reduce debt burden
Increase revenue through sales growth or cost-cutting measures
Sell assets to generate cash and pay off debt
Negotiate with creditors for better repayment terms
Define the 7 different layers of the OSI Reference Model
Q70. What is merge sort and its Algorithm ?
Merge sort is a divide and conquer algorithm that divides the input array into two halves, sorts them recursively, and then merges them.
Divide the input array into two halves
Recursively sort each half
Merge the sorted halves back together
Q71. What is your area of interest?
My area of interest is machine learning and artificial intelligence.
I enjoy working with large datasets and developing algorithms to analyze and extract insights from them.
I have experience with various machine learning techniques such as regression, classification, and clustering.
I am also interested in natural language processing and computer vision.
Some examples of my work include developing a recommendation system for an e-commerce website and building a chatbot for custo...read more
Q72. How to handle difficult situations with stakeholder
Handling difficult situations with stakeholders requires effective communication, active listening, and problem-solving skills.
Stay calm and professional
Listen actively to their concerns
Acknowledge their perspective
Identify the root cause of the issue
Collaborate on finding a solution
Communicate clearly and transparently
Follow up to ensure resolution
Q73. Is one time item in CFO an alarming item for a comany seeking debt?
Yes, one-time items in CFO can be alarming for a company seeking debt.
One-time items can distort the true financial health of a company
Lenders may view one-time items as unsustainable sources of income
It may raise concerns about the company's ability to generate consistent cash flow
Companies should provide explanations for one-time items to lenders
Q74. How would you approach regulatory changes, how would you identify stakeholders?
Approach regulatory changes by conducting thorough research, engaging with relevant stakeholders, and implementing necessary adjustments.
Research current regulations and upcoming changes
Identify key stakeholders such as regulatory bodies, industry associations, and internal departments
Engage with stakeholders to understand their concerns and gather feedback
Collaborate with legal and compliance teams to ensure adherence to regulations
Implement necessary changes and communicate...read more
Q75. How would resolve the customer query if your facing a vulnerable customer
I would handle the query with empathy and patience, ensuring their needs are met.
Listen actively and attentively to their concerns
Acknowledge their emotions and validate their feelings
Provide clear and concise information
Offer support and assistance in finding a solution
Follow up to ensure their satisfaction
Q76. What do you check in a business continuity plan?
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
Q77. Total number of incoterms.
There are 11 incoterms in total.
Incoterms are international commercial terms used in international trade.
They define the responsibilities of the buyer and seller in terms of transportation, insurance, and customs clearance.
Examples of incoterms include FOB, CIF, EXW, and DDP.
The latest version of incoterms is Incoterms 2020, which replaced Incoterms 2010.
Q78. How bank works and major keys items of banking BS
Banking involves accepting deposits and lending money. Major items in banking balance sheet include assets, liabilities, and equity.
Banks accept deposits from customers and use the funds to make loans to other customers
Assets on a bank's balance sheet include cash, loans, and investments
Liabilities on a bank's balance sheet include deposits and borrowings
Equity on a bank's balance sheet represents the value of the bank's assets minus its liabilities
Banks are regulated by gove...read more
Q79. Tell me what all electronic components you know
Q80. Make the customer get full service and go back with smile
To make the customer get full service and go back with a smile, provide personalized attention, exceed expectations, resolve issues promptly, and create a positive and memorable experience.
Offer personalized attention and listen to the customer's needs
Exceed customer expectations by going the extra mile
Resolve any issues or complaints promptly and effectively
Create a positive and friendly atmosphere
Provide clear and helpful communication
Offer additional perks or surprises to ...read more
Q81. What reviews to be focused by the bank for next 12 months
Q82. What to do if wrong report was sent by you?
Acknowledge the mistake, inform the concerned parties, and provide the correct report as soon as possible.
Admit the mistake and take responsibility
Notify the recipients of the incorrect report
Provide the correct report as soon as possible
Take steps to prevent similar mistakes in the future
Q83. Revenue recognition -How would you recognise revenue and walk through
Revenue recognition involves identifying when and how revenue should be recorded in financial statements.
Revenue should be recognized when it is earned and realized or realizable
The amount of revenue recognized should be the amount that is expected to be received
Revenue recognition should follow the matching principle
Examples of revenue recognition methods include percentage of completion, completed contract, and installment sales
Revenue recognition may also involve accountin...read more
Q84. How do you solve conflicts?
I approach conflicts by actively listening, identifying the root cause, and finding a mutually beneficial solution.
Listen to all parties involved and understand their perspectives
Identify the root cause of the conflict
Brainstorm potential solutions with all parties
Find a mutually beneficial solution
Communicate the solution clearly and ensure all parties agree
Q85. Tell me about your understanding on Agile methodologies?
Agile methodologies are iterative approaches to software development that prioritize flexibility, collaboration, and customer feedback.
Agile methodologies involve breaking down projects into smaller, manageable tasks called sprints.
They emphasize continuous collaboration between cross-functional teams, including developers, testers, and product owners.
Agile promotes adaptability and responding to change over rigid planning.
Common Agile frameworks include Scrum, Kanban, and Ex...read more
Q86. What is the life cycle of an LC?
The life cycle of an LC refers to its stages from design to disposal.
Design and development
Manufacturing and testing
Installation and commissioning
Operation and maintenance
Decommissioning and disposal
Q87. What orchestration tools have you worked on? Which tool do you support?
I have experience working with orchestration tools such as Ansible, Puppet, and Chef. Currently, I support Ansible for automation and configuration management.
Worked with Ansible, Puppet, and Chef for orchestration
Currently supporting Ansible for automation and configuration management
Q88. Is negative working capital good for a comapny?
Negative working capital can be good for a company as it indicates efficient management of assets and liabilities.
Negative working capital can indicate that a company is effectively using its short-term assets to fund its short-term liabilities.
It can show that a company is able to quickly convert inventory or accounts receivable into cash to meet its short-term obligations.
However, sustained negative working capital may also indicate liquidity issues or over-reliance on shor...read more
Q89. Design patterns - Prototype and Factory. How would you use Factory pattern in case of inheritence
Factory pattern is used to create objects without exposing the instantiation logic to the client. It can be used in inheritance to create objects of different subclasses.
Factory pattern can be used to create objects of different subclasses without exposing the instantiation logic to the client
It allows for flexibility in creating objects based on certain conditions or parameters
Factory pattern can be used in inheritance to create objects of different subclasses based on the t...read more
Q90. What do you mean by Negative new screening?
Negative news screening refers to the process of identifying and flagging any negative or adverse information about individuals or entities.
Negative news screening is a part of the Know Your Customer (KYC) process in which individuals or entities are checked against various databases and sources for any negative or adverse information.
It helps in identifying potential risks, such as involvement in criminal activities, fraud, money laundering, or being associated with sanction...read more
Q91. Discuss a scenario where you convinced a difficult customer
I convinced a difficult customer by actively listening to their concerns and finding a mutually beneficial solution.
Listened attentively to the customer's complaints and acknowledged their frustrations
Empathized with the customer's situation and showed understanding
Offered a solution that addressed the customer's concerns and met their needs
Followed up with the customer to ensure their satisfaction with the resolution
Q92. What is MT740?
MT740 is a type of SWIFT message used in international trade finance.
MT740 is used to issue a letter of credit (LC) or a standby letter of credit (SBLC).
It is sent by the issuing bank to the advising bank, which then notifies the beneficiary.
The message contains details such as the LC/SBLC amount, expiry date, and terms and conditions.
MT740 is part of the SWIFT MT7xx series, which covers trade finance messages.
It is important for international trade transactions and helps to ...read more
Q93. To tell about regulatory reporting and RWA
Regulatory reporting is the process of providing information to regulatory bodies. RWA is a measure of a bank's risk exposure.
Regulatory reporting involves submitting data to regulatory bodies such as the SEC or FINRA.
This data includes financial statements, risk assessments, and other information required by regulators.
RWA stands for Risk Weighted Assets and is a measure of a bank's risk exposure.
It is calculated by assigning a risk weight to each asset on a bank's balance s...read more
Q94. Model validation metrics in regulatory and scoring models
Model validation metrics are crucial for regulatory and scoring models.
Regulatory models require validation metrics to ensure compliance with regulations and standards.
Scoring models require validation metrics to ensure accuracy and reliability of the model.
Common validation metrics include accuracy, precision, recall, F1 score, and ROC curve analysis.
Validation metrics should be chosen based on the specific requirements of the model and the industry it is being used in.
Regul...read more
Q95. Different kind of Joins in DBMS ?
Different types of joins in DBMS include inner join, outer join, left join, right join, and full join.
Inner join: Returns rows when there is a match in both tables.
Outer join: Returns all rows from one table and only matching rows from the other table.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full join: Returns rows when there is a match i...read more
Q96. 1.What is Fixed income 2.What is Forex 3.Types of Derivatives
Fixed income refers to investments that pay a fixed rate of return, Forex is the foreign exchange market, and derivatives are financial instruments whose value is derived from an underlying asset.
Fixed income investments include bonds, treasury bills, and certificates of deposit.
Forex, or foreign exchange, is the market where currencies are traded.
Types of derivatives include options, futures, and swaps.
Q97. How far do you forecast in a DCF model
The forecast period in a DCF model depends on the nature of the business and the industry it operates in.
The forecast period typically ranges from 5 to 10 years.
For stable and mature businesses, a longer forecast period may be appropriate.
For rapidly changing industries, a shorter forecast period may be more appropriate.
The forecast period should be supported by reasonable assumptions about future growth rates, margins, and capital expenditures.
The terminal value should accou...read more
Q98. Difference between Stacks and Queues?
Stacks are Last In First Out (LIFO) data structures, while Queues are First In First Out (FIFO) data structures.
Stacks: Elements are added and removed from the same end, like a stack of plates. Example: Undo feature in text editors.
Queues: Elements are added at the rear and removed from the front, like a line of people waiting. Example: Print queue in a printer.
Q99. How to transfer file in network within 2 locations ?
Files can be transferred between 2 locations on a network using various methods.
Use file transfer protocols like FTP, SFTP, or TFTP
Use cloud storage services like Dropbox, Google Drive, or OneDrive
Use network file sharing protocols like SMB or NFS
Use remote desktop software like TeamViewer or Remote Desktop Connection
Use email to send small files as attachments
Q100. What is Managed table and External table in hive
Managed tables are physically stored in Hive's warehouse directory while external tables are not.
Managed tables are created and managed by Hive while external tables are created outside of Hive.
Managed tables are physically stored in Hive's warehouse directory while external tables are not.
Managed tables are deleted when the table is dropped while external tables are not.
Managed tables are used for internal purposes while external tables are used for external purposes.
Example...read more
More about working at HSBC Group
Top HR Questions asked in null
Interview Process at null
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month