Add office photos
i
Capgemini
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini SQL and MSBI Developer Interview Questions and Answers
Capgemini SQL and MSBI Developer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.
(3 Questions)
- Q1. How can you segregate data from one file to many file based on data value of a particular column.
- Ans.
Use SQL queries to filter data based on a particular column value and export to separate files.
Use SELECT statement with WHERE clause to filter data based on the particular column value
Use INSERT INTO statement to insert the filtered data into separate tables or files
Consider using a loop or cursor to iterate through the data and export to multiple files
- Q2. How to access multiple data file place in same directory.
- Ans.
To access multiple data files in the same directory, use a wildcard character (*) in the file path.
Use a wildcard character (*) in the file path to access all files in the directory.
For example, to access all CSV files in a directory, use 'SELECT * FROM folder_path/*.csv'.
Make sure the SQL query or MSBI package is configured to handle multiple files.
- Q3. How to delete data if there is no primary key while there are repeated data sets
- Ans.
You can delete data without a primary key by using a combination of columns to identify and remove duplicate records.
Identify unique combination of columns to differentiate between duplicate records
Use the identified columns in a DELETE statement to remove duplicate records
Consider using temporary tables or CTEs to handle the deletion process efficiently
Scenario based questions
(2 Questions)
- Q1. Why you want to join Capgemini?
- Q2. What makes you confident that Capgemini will offer you?
Interview Preparation Tips
Interview questions from similar companies
I applied via Newspaper Ad and was interviewed in Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. What is your biggest achievement so for?
- Q2. Why do u want to work for our company
Interview Preparation Tips
(2 Questions)
- Q1. Explain sql commands
- Q2. Explain normalization in sql
Selected
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Sql
ddl
dml
tcl
dql
joins
view
date commit
Date commit
joins
view
sum
max
avg
count
min
(1 Question)
- Q1. What is sql , index , stored proc , triggers
(2 Questions)
- Q1. Difference bw table and matrix
- Ans.
A table is a two-dimensional representation of data, while a matrix is a multi-dimensional representation of data.
Tables have rows and columns, while matrices can have multiple dimensions.
Tables are typically used for simple data structures, while matrices are used for more complex data analysis.
In Power BI, tables are used for displaying data in a tabular format, while matrices are used for creating pivot tables and c
- Q2. Syntax for Calculate function
- Ans.
Calculate function in DAX is used to evaluate an expression for a specific filter context.
Syntax: CALCULATE(
, , , ...) Can be used to apply filters to an expression
Can override existing filters in the current context
Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How to insert multiple values in one go
- Ans.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
- Q2. Update query using joins
- Ans.
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Test your algorithmic thinking and problem solving skills
(1 Question)
- Q1. Communications,clearity of answers
(1 Question)
- Q1. Discussion about packages,joining date
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
Sql queries on top clause
(2 Questions)
- Q1. Why u want to join
- Ans.
I am passionate about database management and eager to contribute my skills to your team.
I have a strong background in database administration
I am excited about the opportunity to work with a reputable company like yours
I am eager to learn and grow in my career as a SQL DBA
- Q2. What is the salary expectation
- Ans.
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
Research the average salary range for MS SQL DBAs in your location and industry
Consider your years of experience and any specialized skills or certifications you have
Be prepared to negotiate based on the specific responsibilities and requirements of the role
Capgemini Interview FAQs
Some of the top questions asked at the Capgemini SQL and MSBI Developer interview -
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
- MS SQL DBA Interview Questions
- Msbi Developer Interview Questions
- MSBI and Power BI Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- SQL and PL SQL Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- SQL Server Developer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Consultant
55.3k
salaries
|  ₹5.2 L/yr - ₹18 L/yr |
|
Associate Consultant
52.1k
salaries
| ₹2.9 L/yr - ₹11.8 L/yr |
|
Senior Consultant
46k
salaries
| ₹7.4 L/yr - ₹24 L/yr |
|
Senior Analyst
20.5k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
19.9k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini SQL and MSBI Developer Interview Questions
