Capgemini Interview Questions, Process, and Tips for Experienced

Q1. Etl architecture design
Add your answer
Q2. Priority and severity
Add your answer
Q3. Different stages in etl
Ans. 
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.
Answered by AI
Add your answer

Q1. How to pass authorisation dynamically
Ans. 
Passing authorization dynamically involves generating and sending tokens or credentials at runtime.
• Use token-based authentication to generate and pass tokens dynamically

• Implement OAuth for secure authorization handling

• Utilize JWT (JSON Web Tokens) for passing authorization dynamically
Answered by AI
Add your answer
Q2. Write a java program to remove the character which repeats in a string
Ans. 
Java program to remove repeating characters in a string
• Create a new string to store the result

• Iterate through each character in the input string

• Check if the character is already present in the result string before adding it

• Return the final result string
Answered by AI
Add your answer

Q1. Related to my previous work profile. Related to pricing
Add your answer

Q1. Related to my previous job Related to the pricing
Add your answer

Excel, aptitude, English

Q1. Salary Expectations
Add your answer
Q2. Current Location
Ans. 
I am currently located in New York City.
• I am living in Manhattan, specifically in the Upper East Side neighborhood.

• I work remotely from my apartment due to the COVID-19 pandemic.

• I enjoy the cultural diversity and vibrant atmosphere of the city.
Answered by AI
Add your answer

Q1. How to handle multiple windows
Ans. 
To handle multiple windows, use window handles to switch between them.
• Use getWindowHandles() method to get all window handles

• Use switchTo().window(handle) method to switch to a specific window

• Close windows using close() method or quit() method for entire browser
Answered by AI
Add your answer
Q2. Code to identify a palindrome
Ans. 
Code to identify a palindrome in an array of strings
• Iterate through each string in the array

• For each string, check if it is equal to its reverse

• If it is equal, then it is a palindrome
Answered by AI
Add your answer

Q1. Testing process followed in the project
Ans. 
The testing process in the project involved thorough unit testing, integration testing, and system testing.
• Unit testing was conducted by individual developers to test small units of code.

• Integration testing was performed to test the interaction between different modules.

• System testing was carried out to validate the entire system's functionality.

• Regression testing was also done to ensure that new changes did not affect
Answered by AI
Add your answer