Capgemini Interview Questions, Process, and Tips

Q1. How would you create a pipeline for ADLS to SQL data movement?
Add your answer
Q2. How would you create a pipeline from REST API to ADLS? What is there are 8 million rows of records?
Add your answer
Q3. IF data needs filtering, joining and aggregation, how would you do it with ADF?
Add your answer
Q4. Explain medallion architecture.
Add your answer
Q5. Explain medallion with databricks
Add your answer

Q1. Basic questions and salary expectation.
Add your answer

Q1. About interface and abstract class with C# coding
Add your answer
Q2. Output prediction for interface program in C#
Ans. 
To predict output for an interface program in C#
• Understand the input parameters and expected output of the interface program

• Analyze the logic and algorithms used in the program

• Consider edge cases and potential errors in the program

• Use debugging tools and test cases to validate the output prediction
Answered by AI
Add your answer
Q3. Sql queries like finding the 2nd largest salary, few joins,cte.
Add your answer
Q4. C# Program for reversing a string of text.
Ans. 
C# program to reverse a string of text
• Use the ToCharArray method to convert the string to a char array

• Use a for loop to iterate through the array and reverse the characters

• Use the String constructor to create a new string from the reversed char array
Answered by AI
Add your answer
Q5. And oops concepts, dependency injection, Solid principles with examples and design patterns you in your projects and how.
Add your answer

Q1. Few sql queries like window functions
Add your answer
Q2. About indexing and stored procedures and triggers.
Add your answer
Q3. How do you manage the team
Add your answer
Q4. String programs using linq
Ans. 
Using LINQ to manipulate string arrays in C#
• Use LINQ methods like Where, Select, OrderBy, etc. to filter, transform, or sort string arrays

• Example: string[] names = {"Alice", "Bob", "Charlie"}; var result = names.Where(name => name.Length > 4);

• Example: string[] fruits = {"apple", "banana", "cherry"}; var sortedFruits = fruits.OrderBy(fruit => fruit);
Answered by AI
Add your answer

Q1. Just a salary and location discussion
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Describe AP cycle and principles of accounting
Add your answer

About basic test of knowledge on english & general knowledge

Q1. Questions based on arrays
Add your answer
Q2. Questions based on strings
Add your answer
Q3. OOPS concept and threading
Add your answer
Q4. Multithreading and some coding on array and strings
Add your answer

Q1. About company policies etc
Add your answer
Q2. About CTC
Add your answer

Q1. How to invoke flows - using other flows and Apex. How do we invoke an apex class from a flow and pass variables?
Ans. 
Flows can be invoked using other flows and Apex. Apex classes can be invoked from a flow by using invocable methods and passing variables as input parameters.
• To invoke a flow from another flow, use the 'Launch Flow' element in the Flow Designer.

• To invoke an Apex class from a flow, create an invocable method in the Apex class and annotate it with @InvocableMethod.

• Pass variables from a flow to an Apex class by defining i...read more
Answered by AI
Add your answer
Q2. Why can't we create a master detail on contact as the child object
Ans. 
Master-detail relationship on Contact as child object is not allowed due to data integrity concerns.
• Contact is a standard object and cannot be a child object in a master-detail relationship

• Master-detail relationships require the child object to have a lookup to the parent object

• Contacts are often used as the primary object in many relationships, making it unsuitable as a child object
Answered by AI
Add your answer
Q3. What is child to parent communication in LWC?
Ans. 
Child to parent communication in LWC allows a child component to communicate with its parent component.
• Child components can dispatch custom events to communicate with parent components.

• Parent components can listen for these custom events and handle them accordingly.

• This communication pattern helps in passing data and triggering actions between components.
Answered by AI
Add your answer

Q1. Write triggers for updating user email from contact emails.
Ans. 
Write triggers to update user email from contact emails
• Create a trigger on the User object

• Query for related Contact records

• Update User email field with Contact email
Answered by AI
Add your answer
Q2. How does LWC ensure data refresh
Ans. 
LWC ensures data refresh by using Lightning Data Service and @wire decorator.
• LWC uses Lightning Data Service to ensure data refresh without needing to write Apex code.

• The @wire decorator in LWC allows for declarative data binding and automatic refresh when data changes.

• LWC components can also manually refresh data using imperative Apex calls or by calling the refreshApex() method.
Answered by AI
Add your answer