Add office photos
Employer?
Claim Account for FREE

HSBC Group

3.9
based on 4.8k Reviews
Video summary
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by

200+ Ernst & Young Interview Questions and Answers

Updated 15 Jan 2025
Popular Designations

Q101. What is the difference between Basel and IFRS9 norms

Ans.

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

Add your answer

Q102. Give an example of good customer service.

Ans.

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

Add your answer

Q103. 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 transformations that are lazily evaluated until an action like collec...read more

Add your answer

Q104. 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 imbalanced data distribution, which can impact query performan...read more

Add your answer
Discover Ernst & Young interview dos and don'ts from real experiences

Q105. 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 graph processing.

  • Spark uses in-memory processing to speed up ...read more

Add your answer

Q106. understanding of the current state of global economy

Ans.

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

Add your answer
Are these interview questions helpful?

Q107. Code anything you wish to do

Ans.

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

Add your answer

Q108. What is Asset Management?

Ans.

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

View 1 answer
Share interview questions and help millions of jobseekers 🌟

Q109. How to make your data redundant using cloud services

Ans.

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

Add your answer

Q110. Design a system that can plug in new adapters with minimal code changes

Ans.

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

Add your answer

Q111. Difference between 2-pole and 4-pole machine

Add your answer

Q112. Explain trade life cycle, SDLC, stakeholder management experience etc

Ans.

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

Add your answer

Q113. What is cpp and how it is used for oops concept

Ans.

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'.

Add your answer

Q114. With above comparison, which are your product recommendation for bank.

Ans.

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

Add your answer

Q115. Details of different types of derivatives.

Ans.

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

Add your answer

Q116. Difference between waterfall and agile methodology. Give an example or any experience.

Ans.

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

Add your answer

Q117. What is puthon and how compiler works in the laptop

Ans.

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

Add your answer

Q118. understanding of the derivatives involved in sub-prime crisis

Ans.

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

Add your answer

Q119. Important steps for a

Ans.

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

Add your answer

Q120. How you remove impediments

Ans.

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

Add your answer

Q121. What is the relationship between jnterest rates and stocks

Add your answer

Q122. Explain the advantages and disadvantages of social media

Ans.

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

Add your answer

Q123. Give a case study for a coffee shop in your area

Ans.

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

Add your answer

Q124. Why HSBC? What do you know about credit cards?

Ans.

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

Add your answer

Q125. Handling the frustrated customer?

Ans.

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

View 1 answer

Q126. What is the difference between fraud and scam? How to identify fraud? How to prevent fraud?

Add your answer

Q127. Query to find the top three salaried employees of each department

Ans.

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

Add your answer

Q128. Cheapest option to load data from gcs to bq, pipeline shd be triggered based on file arrival

Ans.

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

Add your answer

Q129. Mathematics behind random forest, logistic regression?

Ans.

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

Add your answer

Q130. Diffrence between line chart and Bar chart.

Ans.

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

Add your answer

Q131. What are two most important deliverables of BA

Ans.

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

Add your answer

Q132. What is Beta in WACC?

Ans.

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.

Add your answer

Q133. What is Risk? Types of risk?

Ans.

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

Add your answer

Q134. Explain complete data pipeline end to end flow

Ans.

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

Add your answer

Q135. Mainframe technology vsam peeformance via jcl parameter

Ans.

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

Add your answer

Q136. 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

Add your answer

Q137. Your approach to tackle dynamic objects

Ans.

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

Add your answer

Q138. What do you think about policy and procedures

Ans.

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.

Add your answer

Q139. What is sox. Types of risk.

Ans.

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

Add your answer

Q140. What is the various forecasting methods

Ans.

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.

Add your answer

Q141. Enumerate the difference between NOPAT and FCF

Ans.

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

Add your answer

Q142. What is Row Level Security?

Ans.

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

Add your answer

Q143. Sort Strings Greatest element in array

Ans.

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.

Add your answer

Q144. Implicit and explicit wait in selenium

Ans.

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

Add your answer

Q145. What are option geeks?

Ans.

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.

Add your answer

Q146. How to deal with difficult people

Ans.

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

Add your answer

Q147. Tell ur experience in privacy company

Ans.

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

Add your answer

Q148. Risk and Return comparison of different banking products

Ans.

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

Add your answer

Q149. Write ansible to copy files from machine to another

Ans.

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

Add your answer

Q150. What is AD? What is a cluster?Etc.

Ans.

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

Add your answer

Q151. What are the components of FSt

Ans.

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

Add your answer

Q152. What are NAV components

Ans.

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.

Add your answer

Q153. Would sale of brand be chargeable to GST in India

Add your answer

Q154. Design a system for large file processing

Ans.

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

Add your answer

Q155. Give an example of bad customer service.

Ans.

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

Add your answer

Q156. What are different types of triggers

Ans.

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.

Add your answer

Q157. How screening perform

Ans.

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

Add your answer

Q158. Describe attention to detail with example

Ans.

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.

Add your answer

Q159. What is CAPM

Ans.

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

Add your answer

Q160. Tell the Pros and Cons of Technology.

Ans.

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

Add your answer

Q161. Discuss how was process

Add your answer

Q162. What is meant by Aria Label

Ans.

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'>

Add your answer

Q163. Difference between data lake and data warehouse

Ans.

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

Add your answer
Ans.

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

Add your answer

Q165. Write code of react for login page

Ans.

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

Add your answer

Q166. what are different queue status

Ans.

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

Add your answer

Q167. Approach to reduce manual process.

Ans.

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

Add your answer

Q168. 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, and counting.

  • Example: Counting the frequency of words in...read more

Add your answer

Q169. what is vpn how it works

Ans.

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

Add your answer

Q170. how fast and efficient you are

Ans.

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

Add your answer

Q171. Difference between list and tuple

Ans.

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)

Add your answer

Q172. What is software development

Ans.

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.

Add your answer

Q173. What is a solid principal?

Ans.

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

Add your answer

Q174. Whats the full form of ISDA

Ans.

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.

Add your answer

Q175. What is list comprehension

Ans.

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)]

Add your answer

Q176. Describe conflict resolution with example

Ans.

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

Add your answer

Q177. Use of Stories and Business cases

Ans.

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

Add your answer

Q178. Making spot decisions

Ans.

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

Add your answer

Q179. 3 strengths and 3 Weaknesses

Ans.

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

Add your answer

Q180. Reasons for switching

Ans.

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

View 2 more answers

Q181. Golden rules of accounting

Ans.

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

Add your answer

Q182. Importance of correlation in modelling

Ans.

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

Add your answer

Q183. what is a use case diagram

Ans.

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

Add your answer

Q184. What is market abuse

Ans.

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

Add your answer

Q185. Optimization techniques in tableau?

Ans.

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

Add your answer

Q186. How many days is Notice period

Ans.

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.

Add your answer

Q187. Appreciations recieved if any

Ans.

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

View 2 more answers

Q188. Explain SOLID Principles

Ans.

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

Add your answer

Q189. Explain Content hugging

Ans.

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

Add your answer

Q190. Load data from hdfs using python

Ans.

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

Add your answer

Q191. How do you create Wireframes

Ans.

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

Add your answer

Q192. Implement search in binary tree

Ans.

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

Add your answer

Q193. Explain data frames in pandas

Ans.

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

Add your answer

Q194. Explain Trade Life Cycle

Ans.

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

Add your answer

Q195. Jira confluence and sharepoint uses

Ans.

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.

Add your answer

Q196. Alignment with values of HSBC

Ans.

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.

Add your answer

Q197. Cobol handling of variable file

Ans.

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.

Add your answer

Q198. Difference between CNN and MLP

Ans.

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.

Add your answer

Q199. Please explain the inverted yield curve

Add your answer

Q200. What was ur recent hike

Ans.

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.

Add your answer
1
2
3
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Ernst & Young

based on 380 interviews
Interview experience
4.2
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

4.0
 • 471 Interview Questions
3.9
 • 246 Interview Questions
4.1
 • 161 Interview Questions
3.3
 • 142 Interview Questions
3.7
 • 139 Interview Questions
View all
Top HSBC Group Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter