Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Capgemini Team. If you also belong to the team, you can get access from here

Capgemini Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Capgemini SQL and MSBI Developer Interview Questions and Answers

Updated 5 Mar 2024

Capgemini SQL and MSBI Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Technical 

(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

  • Answered by AI
  • 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.

  • Answered by AI
  • 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

  • Answered by AI
Round 2 - Case Study 

Scenario based questions

Round 3 - HR 

(2 Questions)

  • Q1. Why you want to join Capgemini?
  • Q2. What makes you confident that Capgemini will offer you?

Interview Preparation Tips

Interview preparation tips for other job seekers - be through with your answers, do not beat around

Interview questions from similar companies

Interview Preparation Tips

Round: Resume Shortlist
Experience: This round they want to know about why do you want to leave your job?
current ctc
expected ctc
how many experience do you have on particular technology?
Tips: this round is simple you have to tell all the details of your profile and if they want this profile candidate they shortlisted you..
they want positive response, so be positive.

Interview Questionnaire 

2 Questions

  • Q1. Why should we choose you?
  • Ans. 

    I have the skills, experience, and passion to excel in this role.

    • I have a strong background in software development, with experience in multiple programming languages and frameworks.

    • I am a quick learner and enjoy tackling new challenges.

    • I am a team player and enjoy collaborating with others to achieve common goals.

    • I am passionate about software engineering and am always looking for ways to improve my skills and knowled...

  • Answered by AI
  • Q2. Why did you choose our company?
  • Ans. 

    I chose your company because of its reputation for innovation and its commitment to employee growth.

    • Your company has a strong reputation for innovation in the industry.

    • I was impressed by the emphasis on employee growth and development.

    • I believe that your company's values align with my own personal values.

    • I was excited about the opportunity to work with a talented team of engineers.

    • Your company's mission and vision reso

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: There were 2 technical rounds. Technical (software): These were tested-How a person approaches a problem,how he thinks.Solutions weren’t needed. Basic understanding, knowledge of Algorithms was tested.

Round: HR Interview
Experience: Knowledge in Machine learning, Artificial Intelligence (electives of the person)
Tips: Basic math would help. Speed doesn’t matter.

Skill Tips: For applying to Software profile, one needs to practice much.
College Name: IIT MADRAS

I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1.  overloading ,inheritance concepts,structures,pointers

Interview Preparation Tips

Interview preparation tips for other job seekers - have good understanding of basics and have expertise on any specific area.

Interview Questionnaire 

2 Questions

  • Q1. Basic Programming Questions, Data structures, SQL queries
  • Q2. This was the most simple one, they simply asked introduce yourself and fine with night shifts.

Interview Preparation Tips

General Tips: I joined HCL as a fresher and got Intervie

Interview Questionnaire 

1 Question

  • Q1. What I know and what I don't know

Interview Preparation Tips

Round: Test
Experience: Aptitude, reasoning, logical, etc. 2 hours

Interview Questionnaire 

2 Questions

  • Q1. C and C++ - technically related stuffs
  • Q2. Communicate and fluency

Interview Preparation Tips

Round: Resume Shortlist
Experience: I had sent my resume to the hiring group, Selection through telephonic interviews. I was interviewed by three different research groups  (once by each).
Tips: Factors in decreasing order of importance: CGPA each stage. Ability to explain your projects precisely. Ability to solve ''standard" logarithmic problems.  The way you think and put down your Answer is the most important. The final answer .s not so I important, and they prod you when you think out aloud anyway.

Round: Technical Interview
Experience: Almost- by default they ask about your previous projects/internships if they are relevant to the group. Ofher questions depend on the group you are interviewed by and your own profile, In my case it was machine learning, text mining etc. I was told about the research problem they were dealing with then and asked f or comments/suggestions/.inputs and a discussion followed.
Tips: Basically these are specialized Interviews so it's good to have sound knowledge of your domain (analytical and application skills are very much required).

Skill Tips: CGPA>9.0, 1f not (like me) relevant work done in the domain and in past internship.A recommendation from the professor is also a good add on.
College Name: IIT Madras

Interview Preparation Tips

Round: Test
Experience: There was an apititude test basically in line with CAT pattern. It was conducted online for about 45 min duration. The questions were rather simple but each question was time bound (around 45 sec or so).
Tips: As such I did not have any structured study plan. I did refresh some of my basics in mechanics and analysis. I was more inclined to get a job in aerospace division. Read as per your interest.
Duration: 45 minutes

Round: Group Discussion
Experience: Initially, we are seated randomly in a circular manner and each one was given two minutes to describe the topic. It was followed by an tense debate where participants converged and diverged on different sets of issue. They were particularly looking for interpersonal skills and out of the box thinking.

Round: Interview
Experience: The interview was purely management type.More questions were thrown at team building, bio-data, why this company? , project, what you Can contribute for the firm?, where you see yourself in next 5 -10 years, ambitions, some amount of optimization tools and techniques, concluding remarks....Interpersonal skills and clarity in answering where mainly
IBM was a more relaxed interview, which basically dealt with management and interpersonal skills. Questions like “if one of our team mate is very stubborn, lazy, adamant, how will you tackle the situation” were asked.
Tips: College (B Tech) curricular activities, NTSC certificate, Math Olympiad certificate, all India quiz competition awards were noted and appreciated. That really was a booster. That helps in implanting an idea that you are not just blah blah blah.

Skill Tips: Be very sure about your mechanics, analysis and design. These three are the fundamentals.
I haven prepared for placements exclusively. Here were combined discussions. However, it really helps if you can revise and make your fundamentals were clear. The basic understanding should be there. An hour every day for two months will do the trick.
Be really choosy of the company you want to be in. Learn a lot more of the company and get an idea of what they are actually looking for. But still don’t freeze your mind to those realms alone.. Be open minded and cheerful. The first few questions will set the mood of the interview. If you are bale to crack that, then things will be really smooth. Really concentrate on your fundamentals, especially analysis and design.
Skills: Mechanics, Analysis , Design
College Name: IIT-Madras

Interview Preparation Tips

Round: Resume Shortlist
Experience: CGPA above 8

Round: Test
Experience: These involve questions from aptitude.
Tips: R S Agarwal's book on aptitude is enough for preparation.
Duration: 80 minutes

Round: Group Discussion
Experience: 11 members were part of the GD. The GD was not a rejection round.
Duration: 20 minutes

Round: HR Interview
Experience: Basic Questions.
Tips: Just prepare normal questions for HR.

General Tips: Prepare from placement material from LAN.
Prepare basic fundaes.
College Name: IIT MADRAS

Capgemini Interview FAQs

How many rounds are there in Capgemini SQL and MSBI Developer interview?
Capgemini interview process usually has 3 rounds. The most common rounds in the Capgemini interview process are Technical, Case Study and HR.
What are the top questions asked in Capgemini SQL and MSBI Developer interview?

Some of the top questions asked at the Capgemini SQL and MSBI Developer interview -

  1. How to delete data if there is no primary key while there are repeated data s...read more
  2. how can you segregate data from one file to many file based on data value of a ...read more
  3. how to access multiple data file place in same directo...read more

Tell us how to improve this page.

Capgemini SQL and MSBI Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Capgemini SQL and MSBI Developer Salary
based on 5 salaries
₹4.8 L/yr - ₹15.5 L/yr
54% more than the average SQL and MSBI Developer Salary in India
View more details
Consultant
55.3k salaries
unlock blur

₹5.2 L/yr - ₹18 L/yr

Associate Consultant
50.6k salaries
unlock blur

₹3 L/yr - ₹11.8 L/yr

Senior Consultant
46.5k salaries
unlock blur

₹7.5 L/yr - ₹24.7 L/yr

Senior Analyst
21k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Senior Software Engineer
20.4k salaries
unlock blur

₹3.5 L/yr - ₹12.5 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview