Capegemini Consulting India Private Limited interview experience Real time questions & tips from candidates to crack your interview

Analyst

Capegemini Consulting India Private Limited
upvote
share-icon
2 rounds | 6 Coding problems

Interview preparation journey

expand-icon
Journey
Capgemini had a very short recruitment process, and the entire process was conducted online. There were three profiles: Analyst - 4.25 LPA Analyst * - 5.75 LPA Senior Analyst - 7.5 LPA Approximately 300 students from my college were selected for different profiles, with the majority for the Analyst role.
Application story
It was an on-campus drive. The process consisted of two rounds, both conducted online using the Superset platform.
Why selected/rejected for the role?
I was fluent throughout the interview, and my basics were clear. My communication, adaptability, and knowledge helped me crack the interview.
Preparation
Duration: 6 months
Topics: OOPS, DBMS, SQL, DSA, Coding, CN, OS, Software engineering
Tip
Tip

Tip 1: Stick to a DSA sheet. Start with basic questions and gradually increase the level with practice.

Tip 2: Use competitive coding platforms for practice. Participate in contests that will help you build your logic and boost your confidence.

Tip 3: Ensure strong conceptual knowledge.

Tip 4: Have at least two projects on your resume, and make sure you can answer basic questions related to them.

Application process
Where: Campus
Eligibility: No active backlog
Resume Tip
Resume tip

Tip 1: Include some projects on your resume.
Tip 2: Do not include false information on your resume.

Interview rounds

01
Round
Easy
Online Coding Test
Duration120 minutes
Interview date11 Sep 2022
Coding problem3

1. English and Technical MCQ - Cognitive Assessment

The technical assessment consists of questions on data structures, algorithms, database fundamentals, cloud, and networking. For roles specific to your stream, the technical assessment will include stream-specific topics. Details will be shared with your placement office.

Candidate assessment clearance depends on the scores of each module. Each round will be mandatory and an elimination round.

2. Spoken English Assessment

This round is mandatory but not an elimination round.

3. Coding Assessment

The coding or Level 2 technical assessment is a mandatory round, applicable for students eligible for higher package roles. Eligibility will be based on a combination of the student’s academic performance and Capgemini Exceller assessments.

*For roles specific to your stream, the technical assessment will include stream-specific topics. Details will be shared with your placement office.*

1. Single Number

Easy
10m average time
90% success
0/40
Asked in companies
AmazonCultfitPaytm (One97 Communications Limited)

You are given an array A of length N, where N is always an odd integer. There are (N-1)/2 elements in the array that occur twice and one element which occurs once.

Your task is to find the only element that occurs once in the array.

Note: There are (N-1)/2+1 elements that are unique in the array.

Example:
Consider the array be 1,6,4,6,2,4,2
The integers 2, 4, 6 occur twice and only the integer 1 occurs once. 
Problem approach

You can store all the elements in a map, where the key represents the element and the value represents the frequency of that element. Then, you can traverse the hashmap and print all the keys with a value greater than one.

Try solving now

2. SQL Query

Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.

Problem approach

SELECT manager_id, MIN(salary)
FROM employees
WHERE manager_id IS NOT NULL
GROUP BY manager_id
ORDER BY MIN(salary) DESC;

3. Count Even Odd

Moderate
20m average time
90% success
0/80
Asked in companies
BarclaysTeradataWipro

You are given a string of lowercase characters. A magic number M is the summation of the count of characters that occupy even positions in English alphabets and have even frequency, and the count of characters that occupy odd positions in English alphabets and have an odd frequency.

You have to return “EVEN” if M is even, otherwise return “ODD”.

For example:

If we are given a string ‘aabb’.Then we can see the frequency of a=2 and b=2. The position of ‘a’ in alphabets is 1 and the position of ‘b’ is 2. So ‘a’ has an even frequency but its position is odd, so it will not contribute to M. As ‘b’ has an even frequency and its position is also even, so M=1. Now M =1 which is odd, so we have to return “ODD”.
Problem approach

count = 0;
for(int ele : arr){
if(ele%2 == 0) count++;
}
print(count);

Try solving now
02
Round
Easy
Video Call
Duration20 minutes
Interview date17 Sep 2022
Coding problem3

I was shortlisted for the analyst position based on my performance in the assessment. The interviewer asked me very basic questions about OOP, software engineering, and DSA.

1. Kth Smallest and Largest Element of Array

Easy
15m average time
70% success
0/40
Asked in companies
HSBCSalesforceTech Mahindra

You are given an array ‘Arr’ consisting of ‘N’ distinct integers and a positive integer ‘K’. Find out Kth smallest and Kth largest element of the array. It is guaranteed that K is not greater than the size of the array.

Example:

Let ‘N’ = 4,  ‘Arr’ be [1, 2, 5, 4] and ‘K’ = 3.  
then the elements of this array in ascending order is [1, 2, 4, 5].  Clearly, the 3rd smallest and largest element of this array is 4 and 2 respectively.
Try solving now

2. OOPS Question

What is inheritance? (Learn)

What is polymorphism? (Learn)

What do you mean by data abstraction? (Learn)

3. Theory Questions

Explain Waterfall model in SDLC. (Learn)

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

Which SQL keyword removes duplicate records from a result set?

Choose another skill to practice
Similar interview experiences
Analyst
3 rounds | 3 problems
Interviewed by Capegemini Consulting India Private Limited
501 views
0 comments
0 upvotes
Analyst
3 rounds | 3 problems
Interviewed by Capegemini Consulting India Private Limited
515 views
0 comments
0 upvotes
Analyst
2 rounds | 3 problems
Interviewed by Capegemini Consulting India Private Limited
617 views
0 comments
0 upvotes
Analyst
3 rounds | 6 problems
Interviewed by Capegemini Consulting India Private Limited
548 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Analyst
2 rounds | 2 problems
Interviewed by Tata Consultancy Services (TCS)
2166 views
0 comments
0 upvotes
Analyst
3 rounds | 3 problems
Interviewed by Virtusa
693 views
0 comments
0 upvotes
company logo
Analyst
2 rounds | 7 problems
Interviewed by Dunzo
567 views
0 comments
0 upvotes