i
Capgemini
Filter interviews by
To find duplicates, use indexing and rank calculations.
Create an index on the column(s) where duplicates are expected.
Use rank calculations to identify rows with duplicate values.
For example, use the RANK() function in SQL to assign a unique rank to each row based on the values in the duplicate column(s).
Then, select the rows with a rank greater than 1 to identify the duplicates.
The interview questions cover topics such as columnstore index, Power BI report performance, complex dashboard creation, data modeling, and RLS.
For columnstore index in SSAS, I have experience in creating and optimizing them for better query performance.
To ensure Power BI report performance, I use techniques such as data compression, query optimization, and caching.
I have created complex dashboards with multiple v...
I have used CloudFormation to automate infrastructure deployment. I have written templates in JSON and YAML.
I have used CloudFormation to create and manage AWS resources.
I have written templates in JSON and YAML.
I have used intrinsic functions and parameters to make templates dynamic.
I have used CloudFormation Designer to create templates visually.
I have used CloudFormation StackSets to deploy templates across mul...
Yes, an AWS keypair can be recovered if lost.
To recover a lost AWS keypair, you can create a new keypair and associate it with the existing EC2 instances.
First, create a new keypair in the AWS Management Console or using the AWS CLI.
Then, stop the EC2 instances associated with the lost keypair.
Detach the root volume from each instance and create a new temporary instance.
Attach the root volume to the temporary inst...
What people are saying about Capgemini
Reconciliation is the process of comparing two sets of records to ensure they are in agreement.
Reconciliation involves matching transactions, balances, or statements to identify discrepancies.
It is important for financial accuracy and fraud prevention.
Examples include bank reconciliation, inventory reconciliation, and account reconciliation.
I have worked on various projects in my previous roles.
Managed a team of 10 to successfully complete a software development project for a client in the finance industry
Led a project to implement a new CRM system for a healthcare organization, resulting in a 20% increase in efficiency
Collaborated with cross-functional teams to launch a new product line for a consumer goods company
A stage in IBM InfoSphere DataStage used to generate rows based on specified criteria.
Used to create new rows in a data set based on certain conditions
Can be used to generate test data or to fill in missing data
Can be configured to generate a specific number of rows or to continue generating rows until a certain condition is met
I applied via Naukri.com
A virtual method is a method in object-oriented programming that is declared in a base class and can be overridden in derived classes.
Virtual methods allow for polymorphism, where a method can be called on an object and the specific implementation is determined at runtime based on the actual type of the object.
In C++, virtual methods are declared using the 'virtual' keyword in the base class and can be overridden in de...
Interfaces define contracts for classes to implement, while abstract classes can provide partial implementations.
Interfaces allow multiple inheritance, abstract classes do not
Abstract classes can have constructor, interfaces cannot
Interfaces are used for defining types, abstract classes are used for code reusability
Example: Interface - Comparable, Abstract class - Animal
BW4HANA is a separate product designed for HANA database, while BW on HANA is the traditional BW system running on HANA database.
BW4HANA is a completely new product built on the HANA database, offering enhanced performance and flexibility.
BW on HANA is the traditional BW system that has been optimized to run on the HANA database.
BW4HANA allows for more agile data modeling and integration with modern technologies like m...
A composite provider is a type of data provider in SAP BW that combines data from multiple InfoProviders into a single virtual InfoProvider.
Combines data from multiple InfoProviders
Acts as a virtual InfoProvider
Allows for complex reporting and analysis by combining data sources
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.
The Substr function extracts a substring from a given string based on specified starting position and length.
Substr function syntax: Substr(string, start_position, length).
In this case, 'Data Services' starts at index 5 (0-based), extracting 8 characters.
The result will be 'Services', as it starts from 'S' in 'Services'.
If start_position exceeds string length, it returns an empty string.
The output of the NVL function when 'Job.id' is null or empty
NVL function returns the first non-null value from the list of arguments
If 'Job.id' is not null, the output will be 'Job.id'
If 'Job.id' is null or empty, the output will be an empty string
Experienced manager with a proven track record in leading teams and achieving business goals.
Over 10 years of management experience
Strong leadership and communication skills
Successful track record in meeting targets and KPIs
Ability to motivate and inspire team members
Experience in strategic planning and decision-making
Example: Led a team of 20 employees to exceed sales targets by 15% in the last quarter
Seeking new challenges and opportunities for growth.
Looking for opportunities to expand my skill set
Seeking a new challenge to keep me motivated
Interested in exploring different industries for career growth
I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
POSC (Point of Sale Cockpit) is a user interface in SAP EWM for managing and monitoring warehouse activities.
POSC provides a centralized view of warehouse operations such as inbound and outbound processes.
Users can monitor key performance indicators (KPIs) and make real-time decisions to optimize warehouse efficiency.
POSC integrates with other SAP modules like SAP ERP for seamless data flow and visibility.
Example: Usin...
I applied via Job Portal and was interviewed before Oct 2023. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in May 2023. There were 4 interview rounds.
I have over 5 years of experience in management roles, overseeing teams and projects to successful completion.
Managed a team of 15 employees in a retail setting
Developed and implemented strategies to increase sales by 20%
Responsible for training new hires and conducting performance evaluations
Collaborated with cross-functional teams to launch new product lines
I applied via Naukri.com and was interviewed in Mar 2023. There were 3 interview rounds.
Python twist program
First they asked basic questions and slightly move advance level.
Programming part it's easy for experience person.
First round they take technical questions like difference between list and tuple,
Monkey chunk
Memory management concept
OOPs concepts
Lastly scan CV to ask previous project works and roles responsibility
Some of the top questions asked at the Capgemini Manager interview -
The duration of Capgemini Manager interview process can vary, but typically it takes about 2-4 weeks to complete.
based on 58 interview experiences
Difficulty level
Duration
based on 1.1k reviews
Rating in categories
Consultant
58.6k
salaries
| ₹5.3 L/yr - ₹19 L/yr |
Associate Consultant
51.3k
salaries
| ₹2.9 L/yr - ₹12.5 L/yr |
Senior Consultant
50k
salaries
| ₹7.8 L/yr - ₹26 L/yr |
Senior Analyst
22.1k
salaries
| ₹1.6 L/yr - ₹9.1 L/yr |
Senior Software Engineer
21.5k
salaries
| ₹3.5 L/yr - ₹13.5 L/yr |
Wipro
Accenture
Cognizant
TCS