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
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Business Intelligence Consultant Interview Questions and Answers for Experienced
Updated
23 Feb 2022
1 interview found
Sort by:
Popular
Anonymous
I applied via Recruitment Consulltant and was interviewed in Aug 2021.
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. It was purely based on Power BI Add Answer
2
Technical Round (1 Question)
- Q1. It was purely based on SQL Add Answer
3
Behavioral Round (1 Question)
- Q1. It was to understand what you have worked on and to basically understand will you be a suitable fit for client interactions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Do prepare BI and SQL technical. Once you crack these two interviews, third one will be easy to crack.
Interview questions from similar companies
Interview Questions
- Q1. Write a query to display the duplicate records without using group by.
View Answers (1)
- Q2. What is the use of ‘for XML’ command
View Answers (2)
- Q3. What is the difference between stuff() and substring()
View Answers (1)
- Q4. Explain the transaction property in SSIS
View Answers (1)
- Q5. How will you pass db connection string on runtime
View Answers (1)
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Mar 2021.
5 Interview Rounds
Interview Questions
- Q1. On SSIS about the project,Incremental Load,Event Handler,Debugging Error,Variable and Parameters
View Answers (1)
- Q2. SQL questions what is View, difference of Union and Union All
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - It was very great experience while getting interviewed with Panels from Genpact.They make you feel relaxed and they are to try understand you rather grill you.Just prepare the skills mentioned in Resume.
Interview Questions
- Q1. How can you do query optimization?
View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - They will ask about the live projects you worked on..Try to explain it better with your role
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Job Portal and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (9 Questions)
- Q1. Explain XGBoost algoritm View Answers (1)
- Q2. XgBoost algorithm has 10-20 features. How are the splits decided, on which feature are they going to be divided? View Answers (2)
- Q3. Do you have any experience on cloud platform? View Answers (1)
- Q4. What is entropy, information gain? View Answers (1)
- Q5. What is hypothesis testing? View Answers (1)
- Q6. Explain precision and recall, when are they used in which scenario? View Answers (1)
- Q7. What is data imbalance? View Answers (1)
- Q8. What is SMOTE?
Do you have any experience working on Time Series?
Code analysis of global variable? View Answers (1)
- Q9. Find 5th highest salary in every department.
What are window functions
Difference between union and union all
Difference between delete and truncate. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare basics well. Go through the top questions asked for SQL,Python,Data Science.
Well versed with resume projects and concepts used in it.
Well versed with resume projects and concepts used in it.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-
2 Interview Rounds
1
One-on-one Round (4 Questions)
- Q1. Cosine similarity View Answers (1)
- Q2. What is difference between recall and precission View Answers (2)
- Q3. How to remove stop words and how it works View Answers (1)
- Q4. Whats the goal of project Add Answer
2
One-on-one Round (1 Question)
- Q1. Pipeline design Add Answer
Skills evaluated in this interview
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
I applied via Naukri.com and was interviewed in Jul 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Pandas basics and SQL joins nlp Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - It was good
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
-
I applied via Naukri.com and was interviewed in Oct 2023.
2 Interview Rounds
1
Technical Round (3 Questions)
- Q1. Discussion on projects mentioned in the Resume Add Answer
- Q2. Two Python live coding questions Add Answer
- Q3. Few DL, ML, Transformers, and NLP questions
Few questions on deployment tools mentioned in the resume Add Answer
2
HR Round (1 Question)
- Q1. General HR discussion Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Nov 2023.
3 Interview Rounds
1
Resume Shortlist Round
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
2
Aptitude Test Round
Logical reasoning, current affairs, numericals
3
One-on-one Round (1 Question)
- Q1. Genuinely HR round Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Always make an eye contact with the Interviewer for better confidence.
Rohit Mishra
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Company Website and was interviewed in Nov 2023.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Can you discuss one of your project in detail and why have you chosen those specific model to start with? Add Answer
Capgemini Interview FAQs
How many rounds are there in Capgemini Business Intelligence Consultant interview for experienced candidates?
Capgemini interview process for experienced candidates usually has 3 rounds. The most common rounds in the Capgemini interview process for experienced candidates are Technical and Behavioral.
What are the top questions asked in Capgemini Business Intelligence Consultant interview for experienced candidates?
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Intelligence Analyst Interview Questions
- Business Intelligence Developer Interview Questions
- Senior Business Intelligence Analyst Interview Questions
- Manager - Business Intelligence Interview Questions
- Artificial Intelligence Intern Interview Questions
- Artificial Intelligence Developer Interview Questions
- Data Scientist Interview Questions
- Lead - Business Intelligence Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
12%
less
than the average Business Intelligence Consultant Salary in India
View more details
|
Consultant
55.3k
salaries
|  ₹5.1 L/yr - ₹18 L/yr |
|
Associate Consultant
52.9k
salaries
| ₹2.9 L/yr - ₹11.9 L/yr |
|
Senior Consultant
45.8k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
|
Senior Analyst
20.7k
salaries
| ₹2 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
19.8k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Explore more salaries
Compare Capgemini with
Wipro
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Business Intelligence Consultant Interview Questions for Experienced
Share an Interview