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

Data Analyst

Capegemini Consulting India Private Limited
upvote
share-icon
3 rounds | 4 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 1 Month
Topics: Data Structures, OOPS, SQL, Python, Java
Tip
Tip

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application process
Where: Campus
Eligibility: 7 CGPA
Resume Tip
Resume tip

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration120 Minutes
Interview date24 Sep 2019
Coding problem1

1. Ninja And His Secret Information

Moderate
30m average time
70% success
0/80
Asked in companies
AppleAdobeCapegemini Consulting India Private Limited

Ninja has recently joined the FBI. Ninja got some secret information ‘SECRET_INFORMATION’ which he wants to share with his team. But he can not send this information directly because of the hackers and security threats they pose.

So Ninja decides to encode this ‘SECRET_INFORMATION’ and then send the encoded ‘SECRET_INFORMATION’ to his team members. This way, only his team members can decode this information and thus share it safely.

As Ninja is busy extracting the ‘SECRET_INFORMATION, he asks you for help.

Can you help Ninja and his friends with encoding and decoding the ‘SECRET_INFORMATION’?

Note:

1. The ‘SECRET_INFORMATION’ may contain any possible character out of 256 valid ASCII characters.
2. While decoding the ‘SECRET_INFORMATION’ do not use class members / global/static variables.
3. Do not use any inbuilt library method/function for decoding the ‘SECRET_INFORMATION’.
Try solving now
02
Round
Medium
Face to Face
Duration60 Minutes
Interview date25 Oct 2019
Coding problem2

1. Technical Questions

SQL join to your database query

What is polymorphism

2. Equilibrium Index

Easy
0/40
Asked in companies
Chegg Inc.Goldman SachsCoinbase

You are given an array Arr consisting of N integers. You need to find the equilibrium index of the array.

An index is considered as an equilibrium index if the sum of elements of the array to the left of that index is equal to the sum of elements to the right of it.

Note:

1. The array follows 0-based indexing, so you need to return the 0-based index of the element.
2. Note that the element at the equilibrium index won’t be considered for either left sum or right sum.
3. If there are multiple indices which satisfy the given condition, then return the left-most index i.e if there are indices i,j,k…. which are equilibrium indices, return the minimum among them
4. If no such index is present in the array, return -1.
Try solving now
03
Round
Easy
HR Round
Duration50 Minutes
Interview date25 Oct 2019
Coding problem1

1. Basic HR Questions

Tell me about yourself.

Why should we hire you?

What keeps you motivated?

Here's your problem of the day

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

Skill covered: Programming

How do you remove whitespace from the start of a string?

Choose another skill to practice
Similar interview experiences
Data Analyst
3 rounds | 4 problems
Interviewed by Capegemini Consulting India Private Limited
456 views
0 comments
0 upvotes
Data Analyst
2 rounds | 4 problems
Interviewed by Capegemini Consulting India Private Limited
0 views
0 comments
0 upvotes
SDE - 1
2 rounds | 3 problems
Interviewed by Capegemini Consulting India Private Limited
472 views
0 comments
0 upvotes
Data Analyst
3 rounds | 4 problems
Interviewed by Capegemini Consulting India Private Limited
426 views
0 comments
0 upvotes