i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.
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
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.
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
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...
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
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
Some of the top questions asked at the Capgemini SQL and MSBI Developer interview -
based on 1 interview
Interview experience
Consultant
55.3k
salaries
| ₹5.2 L/yr - ₹18 L/yr |
Associate Consultant
50.6k
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Consultant
46.5k
salaries
| ₹7.5 L/yr - ₹24.7 L/yr |
Senior Analyst
21k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS