Genpact
20+ Genpact Interview Questions and Answers
Q1. Delhi is suffering from air pollution due to cars. As a business analyst how would you solve this problem?
Implementing policies to reduce car emissions and promote alternative modes of transportation.
Encourage the use of public transportation by improving infrastructure and increasing frequency of services.
Promote carpooling and ridesharing initiatives to reduce the number of vehicles on the road.
Incentivize the adoption of electric vehicles through subsidies and tax breaks.
Implement stricter emission standards for vehicles and enforce regular emissions testing.
Create designated ...read more
Q2. How do they affect your data analysis?
Data analysis is affected by various factors that can influence the accuracy and reliability of the results.
Data quality: The accuracy, completeness, and consistency of the data can impact the analysis.
Data sources: The reliability and relevance of the data sources used for analysis can affect the outcomes.
Data preprocessing: The way data is cleaned, transformed, and prepared for analysis can impact the results.
Data interpretation: The biases, assumptions, and subjectivity in...read more
Q3. Why the using of financial analysis
Financial analysis helps in understanding the financial health of a company and making informed decisions.
Financial analysis helps in identifying the strengths and weaknesses of a company's financial performance.
It helps in making informed decisions related to investments, mergers and acquisitions, and financial planning.
Financial analysis also helps in identifying potential risks and opportunities for growth.
Examples of financial analysis tools include ratio analysis, trend ...read more
Q4. How to find last quarter end working date through python or sql
To find the last quarter end working date, use Python or SQL to calculate the date based on the current date.
In Python, use the datetime module to calculate the last quarter end working date by subtracting the current date by the number of days in the previous quarter.
In SQL, use date functions like DATEADD and DATEPART to calculate the last quarter end working date based on the current date.
Consider holidays and weekends when calculating the last quarter end working date to ...read more
Q5. What is autocorrelation?
Autocorrelation is the correlation of a signal with a delayed copy of itself.
Autocorrelation is used to identify patterns in time series data.
It is a measure of how similar a signal is to a delayed version of itself.
Autocorrelation can be positive, negative, or zero.
It is commonly used in signal processing, finance, and econometrics.
Autocorrelation can be visualized using a correlogram.
Q6. What is heteroscedasticity?
Heteroscedasticity is a statistical term that refers to the unequal variance of a variable across different levels of another variable.
It is a violation of the assumption of homoscedasticity in regression analysis.
It can lead to biased and inefficient estimates of regression coefficients.
It can be detected through residual plots or statistical tests such as the Breusch-Pagan test.
Examples include income and expenditure, where the variance of expenditure increases with income....read more
Q7. How to calculate number of days between two dates
To calculate number of days between two dates, subtract the earlier date from the later date.
Subtract the earlier date from the later date to get the difference in days
Consider leap years and different month lengths when calculating the difference
Use a programming language or tool that has built-in date functions for easier calculation
Q8. What is enterprise value and how you calculate it?
Enterprise value is a measure of a company's total value, including debt and equity.
Enterprise value = Market capitalization + Total debt - Cash and cash equivalents
It represents the total value of a company that would be required to take over the entire business.
EV is often used in financial analysis to compare companies with different capital structures.
Calculating EV helps in determining the true value of a company's operations.
Q9. Explain what is EDA and how is it helpful
EDA stands for Exploratory Data Analysis. It is helpful in analyzing and understanding data patterns, relationships, and trends.
EDA involves summarizing the main characteristics of the data, often with visual methods like histograms, scatter plots, and box plots.
It helps in identifying outliers, missing values, and patterns in the data that can inform further analysis or modeling.
EDA can also involve statistical tests and techniques to explore relationships between variables ...read more
Q10. How do you handle irate clients
I handle irate clients by remaining calm, actively listening to their concerns, empathizing with their situation, and finding a solution together.
Remain calm and composed
Listen actively to their concerns without interrupting
Empathize with their situation and show understanding
Find a solution together by offering options and alternatives
Follow up to ensure the issue is resolved to their satisfaction
Q11. What do you understand with optimization
Optimization refers to the process of making something as effective or functional as possible.
Optimization involves maximizing efficiency and minimizing waste.
It often involves finding the best possible solution within given constraints.
Examples include optimizing supply chain logistics to reduce costs and improve delivery times.
Optimization can also be applied to processes, systems, and algorithms to improve performance.
Q12. Tell me knowledge on the process.
Knowledge on the process refers to understanding the steps, procedures, and workflows involved in a particular business or project.
Understanding the current processes in place
Identifying areas for improvement or optimization
Documenting processes using tools like flowcharts or process maps
Collaborating with stakeholders to gather requirements and feedback
Analyzing data and metrics to measure process effectiveness
Q13. What are views and why we use it
Views are virtual tables that display data from one or more tables in a database.
Views are used to simplify complex queries by storing them as a virtual table.
They can also restrict access to certain columns or rows of a table.
Views can be used to join multiple tables together and present the data in a more user-friendly format.
Q14. Explain about the complete sourcing cycle
The complete sourcing cycle involves identifying needs, selecting suppliers, negotiating contracts, and managing relationships.
Identifying needs: Understanding the requirements of the organization and determining what goods or services are needed.
Selecting suppliers: Researching potential suppliers, evaluating their capabilities, and choosing the best fit for the organization.
Negotiating contracts: Discussing terms, pricing, and conditions with the selected supplier to reach ...read more
Q15. What is join What is stored procrdures Indexing
Join is used to combine rows from two or more tables based on a related column between them. Stored procedures are precompiled SQL queries stored in the database for reuse. Indexing is a technique to improve the performance of queries by creating indexes on columns.
Join is used to retrieve data from multiple tables based on a related column
Stored procedures are precompiled SQL queries stored in the database for reuse
Indexing is a technique to improve query performance by crea...read more
Q16. what are Parameter actions
Parameter actions allow users to dynamically change parameter values in Tableau dashboards.
Parameter actions enable users to interact with dashboard parameters by clicking on marks or selecting values.
They can be used to filter data, highlight specific information, or drive calculations.
For example, a user can click on a bar chart to update a parameter value and see corresponding changes in other visualizations.
Q17. how to toggle between pages
To toggle between pages, use navigation buttons, links, or keyboard shortcuts.
Use navigation buttons like 'Next' and 'Previous'
Click on links or tabs to switch between pages
Use keyboard shortcuts like Ctrl + Tab to toggle between open tabs
Q18. How do you prioritize
I prioritize by assessing urgency, impact, and resources available.
Assess urgency of tasks and prioritize those with imminent deadlines
Consider impact of tasks on overall project goals and prioritize high-impact tasks
Evaluate resources available and prioritize tasks that align with available resources
Use tools like Eisenhower Matrix or MoSCoW method for effective prioritization
Q19. What is general ledger
General ledger is a complete record of financial transactions of a company, organized by accounts.
General ledger is a key component of the accounting system.
It contains all accounts and their transactions, such as assets, liabilities, equity, revenue, and expenses.
Entries in the general ledger are posted from journals and other subsidiary ledgers.
It provides a detailed record of all financial activities of the company.
General ledger helps in preparing financial statements lik...read more
Q20. Hierarchy of filters in tableau
In Tableau, the hierarchy of filters determines the order in which filters are applied to the data.
Filters are applied in the order they appear in the Filter Shelf.
Context filters are applied first, then dimension filters, and finally measure filters.
Filters can be set to apply to all worksheets or only specific worksheets.
Example: If a context filter is applied to a dimension, it will filter the data before any other filters are applied.
Q21. What is normalization
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by storing data in a structured manner
Normalization ensures data integrity by minimizing anomalies such as update, insert, and delete anomalies
Q22. Discounted cash flow (DCF) formula?
DCF formula calculates the present value of future cash flows by discounting them back to the present using a discount rate.
DCF formula: PV = CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n
PV = Present Value, CF = Cash Flow, r = Discount Rate, n = Number of periods
Discount rate is typically the cost of capital or required rate of return
DCF helps in determining the intrinsic value of an investment or project
Q23. What is AML?
AML stands for Anti-Money Laundering, which refers to a set of regulations and procedures designed to prevent the illegal generation of income.
AML regulations require financial institutions to verify the identity of their customers and report suspicious activities.
Examples of suspicious activities include large cash transactions, structuring transactions to avoid reporting requirements, and transferring funds to high-risk countries.
AML compliance is crucial in preventing mone...read more
Q24. What is CDD/EDD.
CDD/EDD stands for Customer Due Diligence/Enhanced Due Diligence, which are processes used by businesses to verify the identity of their customers and assess the risk associated with their business relationships.
CDD is a standard process used to verify the identity of customers and assess the risk level associated with them.
EDD is a more thorough process that is conducted for higher-risk customers or transactions.
Both CDD and EDD are important in preventing money laundering, ...read more
Q25. Types of General ledger
Types of general ledger include single-entry and double-entry systems.
Single-entry system: Records each transaction as a single entry, typically used by small businesses.
Double-entry system: Records each transaction with both a debit and credit entry, ensuring accuracy and balance.
Examples: QuickBooks (single-entry), SAP (double-entry)
Q26. Create a Pivot table
A pivot table is a data summarization tool used in spreadsheet programs
Select the data range you want to analyze
Go to the 'Insert' tab and click on 'PivotTable'
Choose where you want the pivot table to be placed
Drag and drop fields into the 'Rows' and 'Values' areas to summarize the data
Q27. T codes in SAP
T codes in SAP are transaction codes used to access specific functions or tasks within the system.
T codes are shortcuts to access specific transactions in SAP.
Each T code corresponds to a specific task or function in the system.
Users can enter T codes in the command field to quickly navigate to desired transactions.
For example, T-code VA01 is used to create a sales order in SAP.
Q28. Explain P2P process,
P2P process stands for Procure-to-Pay process, which involves the steps from requisition to payment for goods or services.
P2P process starts with a requisition for goods or services needed by a company.
The next step involves creating a purchase order (PO) to specify the details of the purchase.
Once the goods or services are received, the invoice is matched to the PO and goods receipt.
After verification, the payment is processed to the vendor.
P2P process helps streamline the p...read more
More about working at Genpact
Top HR Questions asked in Genpact
Interview Process at Genpact
Top Business Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month