To succeed in the Genpact hiring process, you must approach your preparation with a balance of technical rigor, domain-specific knowledge, and structured communication. The interviewers want to see how you think, how you handle data, and how you articulate your findings to both technical teams and business stakeholders.

Technical and Analytical Proficiency – You must master the foundational tools of data analysis. Expect to be tested on intermediate to advanced MS Excel and SQL. Brush up on database normalization, joins, aggregations, and common Excel formulas. If you are a fresher, be ready to demonstrate a solid grasp of basic statistics, probability, and mathematical concepts.

Domain and Functional Knowledge – Genpact is a domain-driven organization. If you are interviewing for a specific vertical like BFSI or Supply Chain, you must understand the end-to-end processes, industry terminologies, and regulatory landscapes of that sector. Review the job description carefully and align your preparation with the required functional skills.

Structured Problem-Solving – When presented with business cases or situational questions, do not jump straight to a solution. First, clarify the scope of the problem, break it down into logical components, and talk through your methodology. Interviewers value a structured approach over a rushed, potentially incorrect answer.

Stakeholder Communication and Culture Fit – As a Business Analyst, you will act as a bridge between clients and technical teams. You must demonstrate high emotional intelligence, active listening, and the ability to explain complex technical concepts in simple business terms. Align your answers with Genpact's core values: curiosity, courage, incisiveness, and integrity.

The interview process for a Business Analyst at Genpact is structured, thorough, and designed to evaluate both your technical capabilities and your cultural alignment. Depending on whether you are applying as a campus recruit, a lateral hire, or for a highly specialized client-facing role, the process typically spans 2 to 3 rounds and can be completed within one to two weeks.

For freshers and campus applicants, the process often begins with an Online Assessment (OA) on platforms like HackerRank, testing basic aptitude, logical reasoning, and introductory coding or SQL concepts. This is frequently followed by a Group Discussion (GD) round to evaluate communication, teamwork, and structured thinking under pressure, before progressing to technical and personal interviews.

For experienced professionals, the journey starts with an initial recruiter screening to discuss your background, location preferences, and salary expectations. From there, you will face one or two rigorous technical rounds focusing heavily on your resume, past projects, SQL, Excel, and domain-specific case studies. Some roles, especially those embedded directly with Genpact's global clients, may also require 2 to 3 client-specific interview rounds to ensure a perfect functional and cultural fit.

This visual timeline illustrates the typical progression of a candidate through the Genpact selection pipeline. You should use this to pace your preparation, ensuring you master your technical fundamentals before the online assessments, while saving your deep project deep-dives and behavioral stories for the later managerial and client rounds. Note that the exact steps may vary slightly based on your experience level and geographical location.

SQL & Data Manipulation

Data lies at the heart of every business decision at Genpact. Interviewers will evaluate your ability to write clean, efficient queries to extract actionable business insights from relational databases.

Be ready to go over:

• Joins and Set Operations – Understanding the logical differences and performance implications of INNER, LEFT, RIGHT, and FULL OUTER JOINs, as well as UNION vs. UNION ALL.
• Data Filtering and Aggregation – Mastering GROUP BY, HAVING, and WHERE clauses, and knowing when to apply aggregations like SUM, AVG, and COUNT.
• Subqueries and CTEs – Writing nested queries and Common Table Expressions to simplify complex data extraction tasks.
• Advanced concepts (less common) – Window functions (e.g., ROW_NUMBER, RANK, DENSE_RANK), query optimization techniques, and basic database indexing.

Example questions or scenarios:

• "Given a table of customer transactions, write a query to find the total spending of customers who made more than five purchases last month."
• "How do you handle duplicate rows in a table when you only want to retrieve unique records?"

Excel & Statistical Foundations

Whether building a quick operational prototype or analyzing business metrics, you will need a strong command of spreadsheet modeling and basic statistical analysis.

Be ready to go over:

• Lookup and Reference Formulas – Using INDEX/MATCH, VLOOKUP, XLOOKUP, and nested IF statements to connect disparate datasets.
• Data Visualization – Designing clean, professional dashboards using Pivot Tables, Pivot Charts, and conditional formatting.
• Descriptive and Inferential Statistics – Understanding mean, median, standard deviation, probability distributions, permutations, and combinations.
• Advanced concepts (less common) – VBA/Macros for automation, regression analysis, and predictive modeling basics.

Example questions or scenarios:

• "How would you design an Excel model to forecast inventory requirements based on historical seasonal sales data?"
• "Explain a scenario where a high standard deviation in process cycle times would indicate an operational issue to a client."

Domain-Specific Functional Knowledge

Genpact operates across highly specialized industries. You must prove that you understand the business rules, operational workflows, and regulatory compliance standards of your target domain.

Be ready to go over:

• Procurement and Supply Chain – End-to-end procurement activities, vendor management, inventory optimization, and logistics KPI tracking.
• BFSI and Payments – Financial regulations, payment processing pipelines, credit risk assessment, and compliance auditing.
• Agile Methodologies – Managing prioritization, backlog refinement, user story creation, and sprint timelines.
• Advanced concepts (less common) – ServiceNow implementation, ERP systems integration, and robotic process automation (RPA) workflows.

Example questions or scenarios:

• "Walk me through how you would handle a sudden disruption in a client's supply chain using data-driven insights."
• "How do you translate a complex, compliance-heavy banking policy into functional requirements for a software development team?"

Project Walkthrough & Behavioral Fit

Your technical skills are only as valuable as your ability to apply them in real-world business environments. Interviewers will dive deep into your resume to assess your execution capabilities and leadership potential.

Be ready to go over:

• Resume Deep Dive – Explaining your past projects, individual contributions, technologies used, and quantifiable business outcomes.
• Stakeholder Management – Handling difficult clients, managing scope creep, and aligning cross-functional teams.
• Problem-Solving in Ambiguity – Navigating projects with missing data, changing requirements, or tight deadlines.
• Advanced concepts (less common) – Negotiating project timelines with senior leadership and driving change management initiatives within client organizations.

Example questions or scenarios:

• "Tell me about a project where you went the extra mile. What was the business outcome, and what did you learn from the experience?"
• "Describe a time when you realized a project requirement was flawed mid-way through development. How did you handle it?"