HSBC Group
200+ Ernst & Young Interview Questions and Answers
Q101. What is the difference between Basel and IFRS9 norms
Basel norms focus on capital adequacy and risk management for banks, while IFRS9 norms focus on accounting standards for financial instruments.
Basel norms are set by the Basel Committee on Banking Supervision to ensure banks maintain adequate capital to cover risks.
IFRS9 norms are accounting standards set by the International Financial Reporting Standards Foundation to address classification and measurement of financial instruments.
Basel norms primarily focus on risk manageme...read more
Q102. Give an example of good customer service.
A good example of customer service is when a representative goes above and beyond to resolve a customer's issue with empathy and efficiency.
Listening actively to the customer's concerns
Offering personalized solutions
Following up to ensure satisfaction
Q103. What is lazy evaluation in spark.
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 transformations that are lazily evaluated until an action like collec...read more
Q104. What is skewness and skewd tables
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 imbalanced data distribution, which can impact query performan...read more
Q105. What is spark and explain working
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 graph processing.
Spark uses in-memory processing to speed up ...read more
Q106. understanding of the current state of global economy
The global economy is currently facing challenges due to the COVID-19 pandemic and geopolitical tensions.
COVID-19 pandemic has caused disruptions in global supply chains and reduced consumer demand
Geopolitical tensions between major economies like US-China trade war and Brexit have added to the uncertainty
Central banks have implemented monetary policies to support the economy, but there are concerns about inflation and debt levels
Emerging markets are facing challenges due to ...read more
Q107. Code anything you wish to do
I would like to create a program that generates a random password.
Use a combination of letters, numbers, and special characters
Allow the user to specify the length of the password
Ensure that the password is strong and not easily guessable
Q108. What is Asset Management?
Asset management refers to the process of managing a company's assets to maximize their value and optimize their use.
Asset management involves tracking, maintaining, and disposing of assets.
It includes activities such as inventory management, maintenance scheduling, and financial planning.
Asset management aims to ensure assets are utilized efficiently and effectively.
Examples of assets that can be managed include physical assets like equipment and property, as well as intangi...read more
Q109. How to make your data redundant using cloud services
Data redundancy can be achieved using cloud services through replication and backup.
Choose a cloud service provider that offers data redundancy options
Replicate your data across multiple servers in different locations
Set up automated backups to ensure data is not lost in case of a disaster
Regularly test your redundancy and backup systems to ensure they are working properly
Q110. Design a system that can plug in new adapters with minimal code changes
Use a plugin architecture with interfaces and dependency injection to easily add new adapters
Implement a plugin architecture where each adapter is a separate plugin
Define interfaces for adapters to ensure consistency in implementation
Use dependency injection to dynamically load and use adapters
Utilize configuration files to specify which adapters to load
Ensure proper error handling and logging for easy troubleshooting
Q111. Difference between 2-pole and 4-pole machine
Q112. Explain trade life cycle, SDLC, stakeholder management experience etc
Trade life cycle involves the process of a trade from initiation to settlement, SDLC is the software development life cycle, and stakeholder management involves identifying and engaging with key stakeholders.
Trade life cycle includes trade initiation, trade execution, trade confirmation, trade settlement, and trade accounting.
SDLC consists of phases like planning, analysis, design, implementation, testing, and maintenance.
Stakeholder management involves identifying key stakeh...read more
Q113. What is cpp and how it is used for oops concept
C++ is a programming language used for object-oriented programming (OOP) concepts.
C++ supports OOP concepts like encapsulation, inheritance, and polymorphism.
Classes and objects are the building blocks of C++ OOP.
C++ allows for data abstraction and data hiding through access specifiers.
Virtual functions and templates are also important features of C++ OOP.
Example: A class 'Car' can have properties like 'make', 'model', and 'year', and methods like 'start' and 'stop'.
Q114. With above comparison, which are your product recommendation for bank.
I recommend implementing a digital banking platform with features like mobile banking, online account opening, and AI-powered chatbots.
Implement a user-friendly mobile banking app for easy access to accounts and transactions
Offer online account opening to attract new customers and streamline the onboarding process
Integrate AI-powered chatbots for customer support and assistance with basic banking tasks
Q115. Details of different types of derivatives.
Derivatives are financial instruments whose value is derived from an underlying asset or benchmark.
Types of derivatives include futures contracts, options contracts, swaps, and forward contracts.
Futures contracts are agreements to buy or sell an asset at a predetermined price and date in the future.
Options contracts give the holder the right, but not the obligation, to buy or sell an asset at a specified price within a certain timeframe.
Swaps involve the exchange of cash flow...read more
Q116. Difference between waterfall and agile methodology. Give an example or any experience.
Waterfall is a sequential approach to project management, while Agile is iterative and flexible.
Waterfall follows a linear and sequential process, while Agile is iterative and allows for changes throughout the project.
Waterfall requires all requirements to be defined upfront, while Agile allows for requirements to evolve over time.
Waterfall is best suited for projects with well-defined requirements, while Agile is better for projects with changing requirements.
Waterfall has a...read more
Q117. What is puthon and how compiler works in the laptop
Python is a high-level programming language used for web development, data analysis, artificial intelligence, and more. The compiler translates Python code into machine-readable code.
Python is an interpreted language, meaning that the code is executed line by line without the need for compilation before execution.
Python code is compiled into bytecode, which is then executed by the Python interpreter.
Python has a dynamic type system, which means that the type of a variable is ...read more
Q118. understanding of the derivatives involved in sub-prime crisis
The sub-prime crisis involved complex derivatives such as mortgage-backed securities and credit default swaps.
The sub-prime crisis was caused by the collapse of the housing market and the default of sub-prime mortgages.
Mortgage-backed securities were created by bundling together mortgages and selling them as investments.
Credit default swaps were insurance-like contracts that paid out if a borrower defaulted on their loan.
The complexity of these derivatives made it difficult f...read more
Q119. Important steps for a
Important steps for a Business Analyst
Understand the business objectives and requirements
Conduct thorough research and analysis
Identify and document business processes
Collaborate with stakeholders to gather requirements
Create and maintain project documentation
Analyze data and provide insights
Facilitate communication between technical and non-technical teams
Assist in the implementation and testing of solutions
Monitor and evaluate project progress
Continuously improve processes ...read more
Q120. How you remove impediments
I remove impediments by identifying them, prioritizing them, and working with the team to find solutions.
Identify the impediment
Prioritize the impediment based on its impact on the team's progress
Work with the team to find solutions
Remove the impediment as quickly as possible
Follow up to ensure the impediment does not reoccur
Q121. What is the relationship between jnterest rates and stocks
Q122. Explain the advantages and disadvantages of social media
Social media has advantages like easy communication and networking, but also has disadvantages like cyberbullying and addiction.
Advantages: easy communication, networking, access to information, marketing opportunities
Disadvantages: cyberbullying, addiction, spread of misinformation, privacy concerns
Example: Social media can be used to connect with friends and family, but can also lead to cyberbullying and mental health issues.
Example: Social media can be used for marketing a...read more
Q123. Give a case study for a coffee shop in your area
Case study of a successful coffee shop in my area
The coffee shop is located in a busy commercial area with high foot traffic
They offer a wide variety of coffee options, including specialty brews and seasonal flavors
The shop has a cozy and inviting atmosphere with comfortable seating and free Wi-Fi
They have a loyalty program to encourage repeat customers
The coffee shop actively engages with the local community through events and collaborations with other businesses
They have a ...read more
Q124. Why HSBC? What do you know about credit cards?
HSBC offers a wide range of credit cards with various benefits and rewards, making it a popular choice for customers.
HSBC offers a variety of credit cards tailored to different needs and lifestyles
Their credit cards come with perks such as cashback, travel rewards, and exclusive discounts
HSBC has a strong reputation for customer service and security measures in place to protect cardholders
The bank also provides online tools and resources to help customers manage their credit ...read more
Q125. Handling the frustrated customer?
Handling a frustrated customer requires active listening, empathy, and problem-solving skills.
Stay calm and composed
Listen actively to understand their concerns
Empathize with their frustration
Apologize for any inconvenience caused
Offer a solution or alternative
Follow up to ensure satisfaction
Q126. What is the difference between fraud and scam? How to identify fraud? How to prevent fraud?
Q127. Query to find the top three salaried employees of each department
Query to find the top three salaried employees of each department
Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary
Partition the data by department and order by salary in descending order
Filter the results to only include rows where the row number is less than or equal to 3
Q128. Cheapest option to load data from gcs to bq, pipeline shd be triggered based on file arrival
Use Cloud Functions to trigger Dataflow job for loading data from GCS to BQ
Set up a Cloud Function to trigger when a new file arrives in GCS
Use the Cloud Function to start a Dataflow job that reads the file from GCS and loads it into BigQuery
Dataflow is a cost-effective option for processing large amounts of data in real-time
Utilize Dataflow templates for easy deployment and management
Q129. Mathematics behind random forest, logistic regression?
Random forest is an ensemble learning method that builds multiple decision trees and combines their predictions. Logistic regression is a statistical model used to predict the probability of a binary outcome.
Random forest combines multiple decision trees to improve accuracy and reduce overfitting.
Logistic regression is used to model the probability of a binary outcome based on one or more predictor variables.
Random forest is a non-linear model while logistic regression is a l...read more
Q130. Diffrence between line chart and Bar chart.
Line chart shows trends over time while bar chart compares values between categories.
Line chart displays data as a series of points connected by a line, useful for showing trends over time.
Bar chart displays data as rectangular bars, useful for comparing values between categories.
Line chart is best suited for continuous data while bar chart is best suited for discrete data.
Line chart can show multiple series of data on the same chart while bar chart is typically used for one ...read more
Q131. What are two most important deliverables of BA
The two most important deliverables of a BA are requirements gathering and analysis.
Requirements gathering: identifying and documenting the needs and expectations of stakeholders
Analysis: using data and information to identify patterns, trends, and insights to inform decision-making
Examples: creating user stories, use cases, process flows, data models, and functional specifications
Q132. What is Beta in WACC?
Beta is a measure of a stock's volatility in relation to the overall market.
Beta is used in the calculation of the cost of equity in the WACC formula.
A beta of 1 indicates that the stock's price will move with the market.
A beta greater than 1 indicates that the stock is more volatile than the market.
A beta less than 1 indicates that the stock is less volatile than the market.
Beta can be found by comparing a stock's returns to the returns of the market over a period of time.
Q133. What is Risk? Types of risk?
Risk refers to the potential for loss or harm. Types include market risk, credit risk, operational risk, and more.
Risk is the potential for loss or harm that may arise from various factors.
Types of risk include market risk (fluctuations in market prices), credit risk (default by borrowers), operational risk (internal processes and systems), and more.
Risk can also be categorized as systematic risk (affecting the entire market) and unsystematic risk (specific to a particular co...read more
Q134. Explain complete data pipeline end to end flow
Data pipeline flow involves data ingestion, processing, storage, and analysis.
Data is first ingested from various sources such as databases, APIs, or files.
The data is then processed to clean, transform, and enrich it for analysis.
Processed data is stored in a data warehouse, data lake, or other storage solutions.
Finally, the data is analyzed using tools like SQL, Python, or BI platforms to derive insights.
Example: Data is ingested from a CRM system, processed to remove dupli...read more
Q135. Mainframe technology vsam peeformance via jcl parameter
VSAM performance can be optimized using JCL parameters in mainframe technology.
Use IDCAMS utility to define VSAM datasets with optimal parameters like CISIZE, RECSIZE, etc.
Specify buffering options like BUFNO and BUFL in JCL to improve I/O performance.
Tune the SPACE parameter in JCL to allocate appropriate space for VSAM datasets.
Leverage features like AIX and RLS for improved VSAM performance.
Monitor performance using tools like RMF and SMF to identify bottlenecks and optimi...read more
Q136. What is stressed exit?
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
Q137. Your approach to tackle dynamic objects
I approach dynamic objects by analyzing their behavior and adapting my approach accordingly.
I start by understanding the nature of the dynamic object and its expected behavior
I then analyze its movement patterns and any potential obstacles or hazards
Based on this analysis, I adapt my approach to ensure safe and efficient interaction with the dynamic object
For example, when working with a moving conveyor belt, I would ensure proper safety measures are in place and adjust my mo...read more
Q138. What do you think about policy and procedures
I believe policies and procedures are essential for maintaining consistency and efficiency in customer service.
Policies and procedures provide guidelines for handling customer inquiries and issues.
They help ensure that all customers are treated fairly and consistently.
Following policies and procedures can help prevent errors and misunderstandings.
Examples: having a policy for escalating customer complaints, following a procedure for processing refunds.
Q139. What is sox. Types of risk.
SOX stands for Sarbanes-Oxley Act, which is a US federal law that sets standards for all US public company boards, management, and public accounting firms.
SOX aims to protect investors by improving the accuracy and reliability of corporate disclosures.
Types of risks related to SOX include financial risk, compliance risk, and reputational risk.
Financial risk involves the potential for financial loss due to non-compliance with SOX regulations.
Compliance risk refers to the risk ...read more
Q140. What is the various forecasting methods
Various forecasting methods include qualitative, quantitative, time series, and causal methods.
Qualitative methods involve expert judgment and market research.
Quantitative methods use historical data and statistical techniques.
Time series methods analyze patterns in historical data to make future predictions.
Causal methods consider the relationship between variables to forecast outcomes.
Q141. Enumerate the difference between NOPAT and FCF
NOPAT is the net operating profit after tax, while FCF is the free cash flow.
NOPAT is a measure of a company's profitability that excludes taxes and interest expenses.
FCF is a measure of a company's financial performance that represents the cash generated by the business after accounting for capital expenditures.
NOPAT = Operating Income * (1 - Tax Rate)
FCF = NOPAT + Depreciation & Amortization - Change in Working Capital - Capital Expenditures
Q142. What is Row Level Security?
Row Level Security is a feature that restricts access to specific rows in a database based on user roles and permissions.
It allows for fine-grained control over data access.
It is commonly used in multi-tenant applications where different users should only have access to their own data.
It can be implemented using database views, stored procedures, or application-level logic.
For example, a sales manager may only be able to see sales data for their own team, while a regional man...read more
Q143. Sort Strings Greatest element in array
Find the greatest element in an array of strings.
Convert the strings to numbers if applicable before comparing.
Use a loop to iterate through the array and keep track of the greatest element.
Handle edge cases like empty array or non-numeric strings.
Q144. Implicit and explicit wait in selenium
Implicit and explicit wait are two types of wait in Selenium used to synchronize the test execution with the application.
Implicit wait is used to set a default waiting time for the web elements to load before throwing an exception.
Explicit wait is used to wait for a specific condition to occur before proceeding with the test execution.
Implicit wait is set globally for the entire test script while explicit wait is set for a specific web element or condition.
Examples of explici...read more
Q145. What are option geeks?
Option geeks are individuals who have a deep understanding and interest in options trading and the financial markets.
Option geeks are highly knowledgeable about options contracts, strategies, and pricing models.
They often analyze market trends, volatility, and risk management techniques to make informed trading decisions.
Examples of option geeks include professional traders, financial analysts, and individuals who actively trade options as a hobby.
Q146. How to deal with difficult people
Dealing with difficult people requires patience, empathy, and effective communication.
Listen actively and try to understand their perspective
Remain calm and avoid getting defensive
Use positive language and avoid blaming or criticizing
Find common ground and work towards a mutually beneficial solution
Set clear boundaries and consequences for unacceptable behavior
Q147. Tell ur experience in privacy company
I have 3 years of experience working in a privacy company specializing in data protection and compliance.
Implemented privacy policies and procedures to ensure compliance with data protection regulations
Conducted privacy impact assessments to identify and mitigate privacy risks
Provided training to employees on data protection best practices
Responded to data subject access requests and managed data breach incidents
Q148. Risk and Return comparison of different banking products
Different banking products offer varying levels of risk and return for investors.
Banking products like savings accounts offer low risk but also low return
Investing in stocks or mutual funds carries higher risk but potential for higher returns
Certificates of deposit (CDs) offer a middle ground with moderate risk and return potential
Q149. Write ansible to copy files from machine to another
Use Ansible playbook to copy files from one machine to another
Create an Ansible playbook with tasks to copy files
Use the 'copy' module in Ansible to copy files
Specify source and destination paths in the playbook
Run the playbook using 'ansible-playbook' command
Q150. What is AD? What is a cluster?Etc.
AD stands for Active Directory, a directory service developed by Microsoft. A cluster is a group of connected servers that work together.
Active Directory is used to manage users, computers, and other resources in a network.
It provides a centralized location for authentication and authorization.
A cluster is used to improve the availability and scalability of applications and services.
It involves multiple servers working together to provide redundancy and load balancing.
Example...read more
Q151. What are the components of FSt
FSt stands for Financial Statements. The components of FSt are the Income Statement, Balance Sheet, and Cash Flow Statement.
Income Statement shows the company's revenues and expenses over a period of time.
Balance Sheet shows the company's assets, liabilities, and equity at a specific point in time.
Cash Flow Statement shows the company's inflows and outflows of cash over a period of time.
Financial Statements are used to evaluate a company's financial performance and position.
T...read more
Q152. What are NAV components
NAV components refer to the various elements that make up the Net Asset Value of a fund.
NAV components include assets, liabilities, income, and expenses.
Assets can include stocks, bonds, and other investments held by the fund.
Liabilities can include expenses owed by the fund, such as management fees.
Income can include dividends and interest earned by the fund.
Expenses can include management fees, legal fees, and other costs associated with running the fund.
Q153. Would sale of brand be chargeable to GST in India
Q154. Design a system for large file processing
Utilize distributed computing and parallel processing to handle large file processing efficiently
Use distributed file systems like Hadoop Distributed File System (HDFS) to store and process large files
Leverage parallel processing frameworks like Apache Spark or Apache Flink to process files in parallel
Implement data partitioning and shuffling techniques to distribute workload evenly across nodes
Utilize batch processing or stream processing based on the nature of the files bei...read more
Q155. Give an example of bad customer service.
Being ignored by a customer service representative when seeking assistance.
Long wait times on hold without any updates or assistance
Rude or dismissive behavior from customer service representatives
Lack of follow-up or resolution to customer inquiries or complaints
Q156. What are different types of triggers
Different types of triggers include time-based triggers, event-based triggers, and manual triggers.
Time-based triggers are scheduled to run at specific times or intervals.
Event-based triggers are activated by specific events or conditions.
Manual triggers require human intervention to start the process.
Q157. How screening perform
Screening performs by analyzing data and information to identify potential risks and threats.
Screening involves collecting and analyzing data from various sources such as public records, watchlists, and sanctions lists.
The data is then compared to the client's information to identify any potential risks or threats.
Screening can be performed manually or through automated systems.
Examples of screening include anti-money laundering (AML) and know your customer (KYC) checks.
Scree...read more
Q158. Describe attention to detail with example
I have a strong attention to detail, ensuring accuracy and precision in all tasks.
I meticulously review documents for errors before submitting them.
I consistently double-check data entry to ensure accuracy.
I pay close attention to small details in reports and presentations to maintain professionalism.
I have a proven track record of catching errors that others may have overlooked.
I always strive for perfection in my work, no matter how small the task.
Q159. What is CAPM
CAPM stands for Capital Asset Pricing Model, a financial model used to determine the expected return on an investment.
CAPM is used to calculate the expected return on an investment based on the risk-free rate, market risk premium, and beta of the asset.
It assumes that investors are rational and risk-averse, and that they require compensation for taking on additional risk.
The formula for CAPM is: expected return = risk-free rate + beta x (market risk premium)
CAPM is often used...read more
Q160. Tell the Pros and Cons of Technology.
Technology has revolutionized the way we live and work, but it also comes with its own set of advantages and disadvantages.
Pros: increased efficiency, improved communication, access to information, automation of tasks
Cons: potential job loss, privacy concerns, dependence on technology, environmental impact
Q161. Discuss how was process
Q162. What is meant by Aria Label
Aria Label is a way to provide a text alternative for non-text content such as images or buttons for screen readers.
Aria Label is used in web development to improve accessibility for users with disabilities.
It is added to HTML elements to provide a label that can be read by screen readers.
For example, <img src='image.jpg' alt='Description of image' aria-label='Description of image'>
Q163. Difference between data lake and data warehouse
Data lake is a vast pool of raw data while data warehouse is a structured repository for processed data.
Data lake stores raw, unstructured data in its native format
Data warehouse stores structured, processed data for easy analysis
Data lake is used for exploratory analysis and big data processing
Data warehouse is used for business intelligence and reporting
Data lake allows for storing large amounts of data at low cost
Data warehouse provides fast query performance for specific ...read more
Q164. What is DCF
DCF stands for Discounted Cash Flow, a valuation method used to estimate the value of an investment based on its future cash flows.
DCF is a financial modeling technique used to estimate the value of an investment based on its expected future cash flows.
It involves projecting future cash flows, discounting them back to their present value using a discount rate, and summing them up to arrive at a present value estimate.
DCF is commonly used in M&A to determine the value of a tar...read more
Q165. Write code of react for login page
Code for a login page in React
Create a form component with input fields for username and password
Handle form submission and validation
Use state to store user input and handle login functionality
Q166. what are different queue status
Different queue statuses include New, In Progress, Suspended, Completed, Failed, and Retried.
New - Items that have been added to the queue but not yet processed
In Progress - Items currently being processed by a robot
Suspended - Items that have been paused or stopped temporarily
Completed - Items that have been successfully processed
Failed - Items that encountered an error during processing
Retried - Items that failed but are being retried
Q167. Approach to reduce manual process.
Automate manual processes using technology and streamline workflows.
Identify repetitive tasks that can be automated
Evaluate available technology solutions
Implement automation tools and integrate with existing systems
Train employees on new processes and monitor for efficiency
Continuously review and improve automated processes
Q168. What is mapreduce
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, and counting.
Example: Counting the frequency of words in...read more
Q169. what is vpn how it works
VPN stands for Virtual Private Network, a technology that allows users to securely access a private network over a public network.
VPN creates a secure and encrypted connection between the user's device and the private network.
It masks the user's IP address and encrypts data to ensure privacy and security.
VPN can be used to access restricted websites, secure remote access to a company's network, and protect data while using public Wi-Fi.
Popular VPN services include NordVPN, Ex...read more
Q170. how fast and efficient you are
I am highly efficient and always strive to complete tasks quickly without sacrificing quality.
I prioritize tasks based on urgency and impact on users
I constantly look for ways to streamline processes and improve efficiency
I have a track record of resolving issues promptly and effectively
I am proficient in troubleshooting and problem-solving techniques
Q171. Difference between list and tuple
List is mutable, tuple is immutable in Python.
List can be modified after creation, tuple cannot.
List uses square brackets [], tuple uses parentheses ().
List is used for collections of items that may change, tuple for fixed collections.
Example: list - [1, 2, 3], tuple - (1, 2, 3)
Q172. What is software development
Software development is the process of designing, creating, testing, and maintaining software.
It involves identifying user requirements and designing software to meet those needs.
Developers write code and test it to ensure it works as intended.
Maintenance involves fixing bugs and updating software to keep it current.
Examples include creating mobile apps, web applications, and desktop software.
Q173. What is a solid principal?
SOLID is an acronym for five object-oriented design principles.
SOLID principles help in creating software that is easy to maintain and extend.
S - Single Responsibility Principle
O - Open/Closed Principle
L - Liskov Substitution Principle
I - Interface Segregation Principle
D - Dependency Inversion Principle
Q174. Whats the full form of ISDA
ISDA stands for International Swaps and Derivatives Association.
ISDA is a trade organization that represents participants in the derivatives market.
It sets standards for the industry and provides documentation for transactions.
Examples of ISDA documentation include the ISDA Master Agreement and Credit Support Annex.
Q175. What is list comprehension
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
List comprehension is written inside square brackets []
It consists of an expression followed by a for clause, then zero or more if clauses
Example: squares = [x**2 for x in range(10)]
Q176. Describe conflict resolution with example
I believe in open communication, active listening, and finding common ground to resolve conflicts effectively.
Active listening to understand all perspectives
Encouraging open communication to address issues
Finding common ground and compromise
Seeking win-win solutions for all parties involved
Q177. Use of Stories and Business cases
Stories and business cases are essential tools for project managers to communicate project goals and benefits.
Stories help to create a shared vision among team members and stakeholders.
Business cases provide a rationale for the project, outlining the expected benefits and return on investment.
Both stories and business cases help project managers to align project activities with organizational goals.
Examples: Using a success story from a previous project to inspire team member...read more
Q178. Making spot decisions
Spot decisions require quick thinking and analysis of available information to make the best decision possible.
Gather as much information as possible before making a decision
Consider the potential consequences of each option
Trust your instincts and past experiences
Be prepared to adjust your decision if new information arises
Examples: deciding on a course of action during a crisis, making a split-second decision in a sports game
Q179. 3 strengths and 3 Weaknesses
Strengths: Leadership skills, problem-solving abilities, strong communication. Weaknesses: Impatience, perfectionism, delegation.
Strengths: Leadership skills - ability to motivate and guide team members towards goals
Problem-solving abilities - adept at finding solutions to complex issues
Strong communication - effective at conveying ideas and information clearly
Weaknesses: Impatience - tendency to rush through tasks without thorough consideration
Perfectionism - difficulty in a...read more
Q180. Reasons for switching
Seeking new challenges and growth opportunities in a different company.
Desire for career advancement
Interest in exploring new industries or sectors
Seeking better work-life balance
Company restructuring or downsizing
Relocation to a different city or country
Q181. Golden rules of accounting
Golden rules of accounting are basic principles that guide the process of recording financial transactions.
The three golden rules of accounting are: Debit what comes in, Credit what goes out; Debit the receiver, Credit the giver; Debit all expenses and losses, Credit all incomes and gains.
These rules help ensure that financial transactions are accurately recorded and classified in the accounting system.
For example, when a company receives cash from a customer, the transaction...read more
Q182. Importance of correlation in modelling
Correlation is important in modelling as it helps to understand the relationship between variables and make accurate predictions.
Correlation measures the strength and direction of the relationship between two variables
It helps to identify which variables have a significant impact on the outcome
Correlation can be used to build regression models and make predictions
It is important to note that correlation does not imply causation
For example, in finance, correlation can help to ...read more
Q183. what is a use case diagram
A use case diagram is a visual representation of the interactions between users and a system.
It shows the different ways users can interact with a system
It helps to identify the actors involved in the system
It outlines the various use cases or scenarios of how the system will be used
It is often used in software development to understand and communicate system requirements
Q184. What is market abuse
Market abuse refers to illegal activities in the financial markets that can manipulate prices or deceive investors.
Market abuse includes insider trading, market manipulation, and dissemination of false or misleading information.
Insider trading involves trading securities based on non-public information.
Market manipulation is the intentional distortion of market prices or trading volumes.
Dissemination of false information involves spreading rumors or false statements to influe...read more
Q185. Optimization techniques in tableau?
Optimization techniques in Tableau involve using features like LOD calculations, data blending, and filters to improve performance and efficiency.
Utilize Level of Detail (LOD) calculations to perform complex aggregations without affecting overall performance.
Use data blending to combine data from multiple sources and optimize query performance.
Apply filters to limit the amount of data being processed and displayed, improving speed and efficiency.
Consider using extracts to imp...read more
Q186. How many days is Notice period
Notice period varies by company policy and can range from 15 days to 3 months.
Notice period duration is typically specified in the employment contract.
It can range from 15 days to 3 months depending on company policy.
Some companies may require longer notice periods for senior positions.
Employees are usually expected to work during the notice period or pay in lieu of notice.
Notice period allows time for both the employer and employee to prepare for the transition.
Q187. Appreciations recieved if any
Received multiple appreciations from clients for resolving credit issues promptly and effectively.
Implemented new credit evaluation process resulting in faster approvals
Negotiated payment plans with delinquent customers to prevent further credit issues
Provided training to team members on credit management best practices
Received 'Employee of the Month' award for exceptional performance in credit management
Q188. Explain SOLID Principles
SOLID principles are a set of five design principles in object-oriented programming to make software designs more understandable, flexible, and maintainable.
S - Single Responsibility Principle: A class should have only one reason to change.
O - Open/Closed Principle: Software entities should be open for extension but closed for modification.
L - Liskov Substitution Principle: Objects of a superclass should be replaceable with objects of its subclasses without affecting the func...read more
Q189. Explain Content hugging
Content hugging is a constraint used in Auto Layout to determine how much a view resists growing beyond its intrinsic content size.
Content hugging priority is a value between 1 and 1000, with higher values indicating a stronger resistance to growing.
Views with higher content hugging priorities will try to maintain their intrinsic content size rather than expand to fill available space.
Content hugging is often used in conjunction with content compression resistance to define h...read more
Q190. Load data from hdfs using python
Use PyArrow library to load data from HDFS in Python
Install PyArrow library using pip install pyarrow
Use pyarrow.hdfs.connect to connect to HDFS
Use pyarrow.parquet.read_table to read data from HDFS
Q191. How do you create Wireframes
I create wireframes by gathering requirements, sketching initial ideas, using wireframing tools, and iterating based on feedback.
Gather requirements from stakeholders to understand project goals
Sketch initial wireframe ideas on paper or using digital tools like Sketch or Adobe XD
Create wireframes using wireframing tools to visualize layout, content, and functionality
Iterate on wireframes based on feedback from stakeholders and team members
Q192. Implement search in binary tree
Implement search in binary tree using recursion
Start at the root node
Compare the target value with the current node value
If target is less than current node value, search left subtree; if greater, search right subtree
Repeat process until target is found or node is null
Q193. Explain data frames in pandas
Data frames in pandas are two-dimensional, size-mutable, and potentially heterogeneous tabular data structures with labeled axes (rows and columns).
Data frames are like spreadsheets or SQL tables with rows and columns.
They can hold different types of data in each column.
Data frames can be created from dictionaries, lists, or other data structures.
Operations like filtering, merging, and grouping can be performed on data frames.
Example: df = pd.DataFrame({'A': [1, 2, 3], 'B': [...read more
Q194. Explain Trade Life Cycle
Trade life cycle refers to the stages involved in a trade from initiation to settlement.
Trade initiation: Trade is proposed and agreed upon by parties involved.
Trade execution: Trade is executed on the agreed terms.
Trade confirmation: Parties confirm the details of the trade.
Trade settlement: Payment and transfer of securities are completed.
Trade reconciliation: Any discrepancies are resolved.
Trade reporting: Trade details are reported to relevant parties.
Trade lifecycle can ...read more
Q195. Jira confluence and sharepoint uses
Jira, Confluence, and SharePoint are project management tools used for collaboration, documentation, and task tracking.
Jira is used for task tracking and issue management in software development projects.
Confluence is a collaboration tool for creating and sharing documents, meeting notes, and project plans.
SharePoint is a document management and collaboration tool for organizing and sharing files within a team or organization.
Q196. Alignment with values of HSBC
I align with HSBC's values of integrity, excellence, and sustainability.
I prioritize integrity in all my work, ensuring transparency and honesty.
I strive for excellence by continuously improving my skills and delivering high-quality results.
I am committed to sustainability, supporting initiatives that promote environmental and social responsibility.
For example, I actively participated in a company-wide sustainability campaign to reduce waste and promote recycling.
Q197. Cobol handling of variable file
COBOL can handle variable-length files by using OCCURS DEPENDING ON clause to dynamically allocate memory based on the file size.
COBOL uses OCCURS DEPENDING ON clause to handle variable-length files.
The OCCURS DEPENDING ON clause allows for dynamic allocation of memory based on the file size.
Example: 01 EMPLOYEE-RECORD. 05 EMPLOYEE-ID PIC X(5). 05 EMPLOYEE-NAME PIC X(20). 05 EMPLOYEE-SALARY PIC 9(6)V99 OCCURS DEPENDING ON NUM-EMPLOYEES.
Q198. Difference between CNN and MLP
CNN is used for image recognition while MLP is used for general classification tasks.
CNN uses convolutional layers to extract features from images while MLP uses fully connected layers.
CNN is better suited for tasks that require spatial understanding like object detection while MLP is better for tabular data.
CNN has fewer parameters than MLP due to weight sharing in convolutional layers.
CNN can handle input of varying sizes while MLP requires fixed input size.
Q199. Please explain the inverted yield curve
Q200. What was ur recent hike
I recently hiked to the top of Mount Kilimanjaro in Tanzania.
I hiked with a group of friends and a local guide.
The hike took us 7 days to complete.
We camped at various locations along the way.
The summit day was the most challenging, with steep inclines and high altitude.
The view from the top was breathtaking and made the entire hike worth it.
Top HR Questions asked in Ernst & Young
Interview Process at Ernst & Young
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month