Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Capgemini Team. If you also belong to the team, you can get access from here

Capgemini Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Capgemini Senior Business Analyst Interview Questions, Process, and Tips for Experienced

Updated 9 Oct 2024

Top Capgemini Senior Business Analyst Interview Questions and Answers for Experienced

  • Q1. Explain about the credit card transaction end to end life cycle, dispute life cycle, parties involved in transaction processing. Explain settlement, batching process.
  • Q2. Write a query to get maximum salary in every department?
  • Q3. Plotting Amortization Schedule on Excel

Capgemini Senior Business Analyst Interview Experiences for Experienced

7 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. BA skill and domain
  • Q2. Payment domain and ISO payment
Round 3 - One-on-one 

(1 Question)

  • Q1. Payment domain and details

Interview Preparation Tips

Interview preparation tips for other job seekers - Na
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Write a query to get maximum salary in every department?
  • Ans. 

    Query to retrieve maximum salary in every department

    • Use GROUP BY clause to group results by department

    • Use MAX() function to retrieve the maximum salary in each department

    • Join the tables if necessary to get department information

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. About past experience and projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't wait for the company to send Offer letter as they are very careless. They will schedule interviews and then after clearing they won't send offer letter neither they will respond.

Skills evaluated in this interview

Senior Business Analyst Interview Questions Asked at Other Companies for Experienced

asked in Sapiens
Q1. Difference between annuity and pension, types of annuity and pens ... read more
asked in EVRY India
Q2. Five concepts in artificial intelligence, In machine learnin ... read more
Q3. Process of how a software is developed and pushed to production
asked in Capgemini
Q4. Explain about the credit card transaction end to end life cycle, ... read more
Q5. Explain a situation where you had to convince stakeholder to modi ... read more
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Tell me about yourself and your work experience
  • Ans. Told about my background and work experience
  • Answered Anonymously
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Questions were related to Banking processes.
  • Q2. Loan Life Cycle
  • Q3. Plotting Amortization Schedule on Excel
  • Ans. 

    To plot an amortization schedule on Excel, use the PMT function to calculate monthly payments and create a table with columns for payment number, payment amount, interest, principal, and remaining balance.

    • Use the PMT function to calculate the monthly payment based on the loan amount, interest rate, and loan term.

    • Create a table in Excel with columns for payment number, payment amount, interest, principal, and remaining ...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. What is long term career goal? General discussion about career.
Round 3 - HR 

(1 Question)

  • Q1. Salary Negotiation

Skills evaluated in this interview

Capgemini interview questions for designations

 Business Analyst

 (23)

 Senior Analyst

 (151)

 Manager Business Analyst

 (1)

 PMO Business Analyst

 (1)

 Business Technology Analyst

 (1)

 Business Consultant Analyst

 (1)

 Lead Business Analyst

 (1)

 Senior Business Consultant

 (1)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Agile related questions
  • Q2. Last project take aways
  • Ans. 

    Improved communication with stakeholders, streamlined project processes, identified areas for cost savings

    • Implemented regular status updates to keep stakeholders informed

    • Utilized project management tools to streamline processes and increase efficiency

    • Conducted cost analysis to identify areas for cost savings, resulting in a 10% reduction in project expenses

  • Answered by AI
  • Q3. Contributions toward project
  • Q4. Scenario based questions

I applied via Naukri.com and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain about the credit card transaction end to end life cycle, dispute life cycle, parties involved in transaction processing. Explain settlement, batching process.
  • Ans. 

    Credit card transaction involves multiple parties and processes including authorization, settlement, and dispute resolution.

    • Credit card transaction starts with authorization where the cardholder swipes or enters their card details for payment.

    • The transaction is then processed by the acquiring bank and sent to the issuing bank for approval.

    • If approved, the transaction is settled where the funds are transferred from the ...

  • Answered by AI
  • Q2. Agile principles, and what's your role in your scrum team, explain. Scrum artifact's and ceremonies

Interview Preparation Tips

Topics to prepare for Capgemini Senior Business Analyst interview:
  • SDLC Life Cycle
  • Credit Cards
  • Dispute resolution
  • Settlements
Interview preparation tips for other job seekers - Keep good knowledge on the domain

I applied via Approached by Company and was interviewed in Apr 2021. There were 2 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Can’t recall the questions ?
  • Q2. Can’t recall the questions?

Interview Preparation Tips

Interview preparation tips for other job seekers - Domain knowledge is must

Interview questions from similar companies

I applied via Approached by Company and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

They give some MCQ question from c#, .net,SQL, angular. Fizz Buzz type coding.

Round 2 - Technical 

(1 Question)

  • Q1. Basic oops concepts, splitter, 3 highest salary in SQL, procedure and functions difference. Basic questions of c#.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is not hard. They ask about your project and your role.

I applied via Referral and was interviewed before Jul 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Introduction confirmation about the interview schedule.
Round 3 - One-on-one 

(2 Questions)

  • Q1. Go through your resume
  • Q2. Testing core knowledge on applied domine.
Round 4 - HR 

(1 Question)

  • Q1. About the salary negotiation.

Interview Preparation Tips

Interview preparation tips for other job seekers - be prepared on basis information Domin on which role you are applied.

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1.  About previous experience, why did I leave the job.
  • Q2. The exact reasons I have provided along with the experience.

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand their question, do not give excuss answers which may prolong in other questions.

Capgemini Interview FAQs

How many rounds are there in Capgemini Senior Business Analyst interview for experienced candidates?
Capgemini interview process for experienced candidates usually has 2 rounds. The most common rounds in the Capgemini interview process for experienced candidates are One-on-one Round, Technical and Resume Shortlist.
How to prepare for Capgemini Senior Business Analyst interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Capgemini. The most common topics and skills that interviewers at Capgemini expect are Business Analysis, Teradata, Data Modeling, Management and Oracle Retail.
What are the top questions asked in Capgemini Senior Business Analyst interview for experienced candidates?

Some of the top questions asked at the Capgemini Senior Business Analyst interview for experienced candidates -

  1. Explain about the credit card transaction end to end life cycle, dispute life c...read more
  2. Write a query to get maximum salary in every departme...read more
  3. Plotting Amortization Schedule on Ex...read more
How long is the Capgemini Senior Business Analyst interview process?

The duration of Capgemini Senior Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Capgemini Senior Business Analyst Interview Process for Experienced

based on 5 interviews

2 Interview rounds

  • Resume Shortlist Round
  • One-on-one Round
View more
Capgemini Senior Business Analyst Salary
based on 355 salaries
₹8.1 L/yr - ₹28 L/yr
20% more than the average Senior Business Analyst Salary in India
View more details

Capgemini Senior Business Analyst Reviews and Ratings

based on 40 reviews

3.2/5

Rating in categories

3.5

Skill development

3.2

Work-life balance

2.8

Salary

3.7

Job security

3.4

Company culture

2.3

Promotions

2.8

Work satisfaction

Explore 40 Reviews and Ratings
Consultant
56.1k salaries
unlock blur

₹5.2 L/yr - ₹18 L/yr

Associate Consultant
50.7k salaries
unlock blur

₹2.9 L/yr - ₹12 L/yr

Senior Consultant
47.4k salaries
unlock blur

₹7.5 L/yr - ₹25 L/yr

Senior Analyst
21.2k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Senior Software Engineer
20.6k salaries
unlock blur

₹3.5 L/yr - ₹13 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview