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
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
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Project related questions from your CV Add Answer
2
Technical Round (2 Questions)
- Q1. Question on transformers Add Answer
- Q2. Comparison of transfer learning and fintuning. View Answers (1)
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Aug 2024.
2 Interview Rounds
1
Coding Test Round
*****, arjumpudi satyanarayana
2
Technical Round (5 Questions)
- Q1. What is the python language View Answers (1)
- Q2. What is the code problems View Answers (1)
- Q3. What is the python code View Answers (1)
- Q4. What is the project View Answers (1)
- Q5. What is the lnderssip View Answers (1)
Interview Preparation Tips
Topics to prepare for IBM Data Scientist interview:
- Python
- Machine Learning
Skills evaluated in this interview
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
kiran khaira
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Asked questions related to stats , Senario based. Interviewer was very nice Add Answer
- Q2. Asked questions on Python Programming and asked for Programs Like How can update List , Asked to Build a Tough Dict , Class etc. Add Answer
2
HR Round (2 Questions)
- Q1. Why u want to join? Add Answer
- Q2. What is your future goal? Add Answer
bhagirath saini
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Complex sql question based on lead lag Add Answer
- Q2. Question based on data index Add Answer
- Q3. Question based on data engineer Add Answer
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
Capgemini Interview FAQs
How many rounds are there in Capgemini Business Intelligence Consultant interview?
Capgemini interview process usually has 3 rounds. The most common rounds in the Capgemini interview process are Technical and Behavioral.
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
At
par with the average Business Intelligence Consultant Salary in India
View more details
|
Consultant
57.4k
salaries
|  ₹5.1 L/yr - ₹18 L/yr |
|
Associate Consultant
53.9k
salaries
| ₹2.9 L/yr - ₹10 L/yr |
|
Senior Consultant
47.7k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
|
Senior Analyst
21.2k
salaries
| ₹2 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹13 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
Share an Interview