i
Capgemini
Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
A deferred bug is a bug that is not fixed immediately but is scheduled to be fixed in a future release.
Deferred bugs are usually lower priority bugs that do not impact the core functionality of the system.
These bugs are documented and tracked for resolution in a later release.
Examples of deferred bugs include cosmetic issues, minor usability problems, or non-critical functionality issues.
Use SQL query with ORDER BY and LIMIT to get 4th highest row based on a column
Use ORDER BY clause to sort the column in descending order
Use LIMIT 1 OFFSET 3 to get the 4th highest row
Example: SELECT * FROM table_name ORDER BY column_name DESC LIMIT 1 OFFSET 3
Self join is a SQL technique where a table is joined with itself to compare rows within the same table.
Self join is used when we need to compare rows within the same table.
It is useful for hierarchical data structures like employee-manager relationships.
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Agile methodologies are iterative approaches to software development that prioritize flexibility and collaboration.
Agile methodologies involve breaking down projects into smaller, manageable tasks called user stories.
They emphasize frequent communication and collaboration between team members.
Agile methodologies prioritize responding to change over following a strict plan.
Common components of Agile methodologies includ
Different stages in ETL include extraction, transformation, and loading of data.
Extraction: Retrieving data from various sources such as databases, files, APIs, etc.
Transformation: Cleaning, filtering, and converting the extracted data into a format suitable for analysis.
Loading: Loading the transformed data into a data warehouse or target database for further processing.
What people are saying about Capgemini
Capgemini interview questions for designations
I applied via Approached by Company and was interviewed in Oct 2017. There was 1 interview round.
To find the nth highest from a table, use the SQL query with the ORDER BY and LIMIT clauses.
Write a SQL query to select the column you want to find the nth highest from.
Use the ORDER BY clause to sort the column in descending order.
Use the LIMIT clause to specify the number of rows to return, where n-1 is the value for LIMIT.
The nth highest value will be the first row returned by the query.
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
I applied via Walk-in and was interviewed before May 2021. There were 3 interview rounds.
Yes, I am flexible with night shifts.
I have worked night shifts before and am comfortable with them.
I understand the importance of being available for work at all times.
I am willing to adjust my schedule to meet the needs of the company.
I am aware that night shifts may require a different sleep schedule and am prepared to make necessary adjustments.
I have the skills, experience, and passion to contribute to the growth and success of your company.
My extensive experience in the industry will allow me to bring new ideas and perspectives to the table.
I have a proven track record of achieving targets and exceeding expectations.
My strong communication and interpersonal skills will enable me to work effectively with colleagues and clients alike.
I am a quick learner and ...
I believe gaining practical experience is more valuable than pursuing further education at this point.
I want to focus on gaining practical experience in my field
I feel that further education may not necessarily enhance my skills or job prospects
I am satisfied with my current level of education and feel it is sufficient for my career goals
I wanted to explore new opportunities and gain exposure to different cultures.
I wanted to broaden my horizons and experience new things.
I believed that studying in a different city would provide me with more opportunities for personal and professional growth.
I wanted to meet new people and learn about different cultures.
I was excited to explore a new city and all that it had to offer.
I felt that studying in a different...
based on 4 interviews
1 Interview rounds
based on 25 reviews
Rating in categories
Consultant
55.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
50.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Consultant
46.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
20.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
20.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Wipro
Accenture
Cognizant
TCS