i
Capgemini
Filter interviews by
To find the 2nd highest salary, use SQL queries to retrieve distinct salaries and order them.
Use the SQL query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
This query selects distinct salaries, orders them in descending order, and skips the highest salary.
Ensure the table has at least two distinct salary values to get a valid result.
Program to generate Fibonacci series using iterative approach.
Initialize variables for first two numbers in the series (0 and 1)
Use a loop to generate subsequent numbers by adding the previous two numbers
Store the generated numbers in an array
Repeat the process until desired number of Fibonacci numbers are generated
Decorators in Python are a design pattern that allows behavior to be added to individual objects.
Decorators are functions that modify the behavior of other functions.
They are used to add functionality to existing functions without changing their code.
Decorators are commonly used in Python with the @ symbol before the function definition.
Example: Creating a decorator to log the execution time of a function.
API to fetch employee details
Create a GET endpoint /employees to fetch all employee details
Include parameters like employee ID or department to filter results
Return employee details in JSON format with fields like name, age, position, etc.
What people are saying about Capgemini
A string is a sequence of characters. It is immutable because once created, its value cannot be changed.
Strings are used to represent text data in programming languages.
Immutable means that the value of a string cannot be altered once it is created.
Any operation that appears to modify a string actually creates a new string with the modified value.
Example: 'hello' -> 'hello world'
The git command to push code to a remote repository is 'git push', which uploads local changes to the remote server.
Use 'git push origin main' to push changes to the main branch of the remote repository.
If you're working on a feature branch, use 'git push origin feature-branch-name'.
To push all branches, use 'git push --all origin'.
To set the upstream branch for the current branch, use 'git push -u origin branch-n...
WebDriver is a general interface for web automation, while ChromeDriver is a specific implementation for Chrome browser.
WebDriver is a generic interface that allows interaction with different web browsers, while ChromeDriver is a specific implementation for Chrome browser.
WebDriver can be used to automate tests on various browsers like Chrome, Firefox, Safari, etc., while ChromeDriver is specifically designed for ...
STLC (Software Testing Life Cycle) is a systematic process for testing software applications.
STLC involves planning, designing, executing, and reporting on tests.
It includes phases like requirement analysis, test planning, test design, test execution, and test closure.
Each phase has specific activities and deliverables to ensure thorough testing of the software.
STLC helps in identifying defects early in the develo...
Handling dropdowns in Selenium involves selecting options from HTML select elements using various methods.
Use Select class: Import org.openqa.selenium.support.ui.Select to handle dropdowns.
Example: Select dropdown = new Select(driver.findElement(By.id('dropdownId')));
Select by visible text: dropdown.selectByVisibleText('Option 1');
Select by value: dropdown.selectByValue('option1');
Select by index: dropdown.selectB...
To scroll a page, use JavaScript to execute a scroll function.
Use window.scrollTo(x-coord, y-coord) to scroll to a specific position on the page.
Use window.scrollBy(x-pixels, y-pixels) to scroll by a certain amount of pixels.
Use document.getElementById('elementId').scrollIntoView() to scroll to a specific element on the page.
I applied via Naukri.com and was interviewed in Nov 2024. There were 3 interview rounds.
Java related coding and questions related to selenium
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
Write a java code to find the vowels from given string
A string is a sequence of characters. It is immutable because once created, its value cannot be changed.
Strings are used to represent text data in programming languages.
Immutable means that the value of a string cannot be altered once it is created.
Any operation that appears to modify a string actually creates a new string with the modified value.
Example: 'hello' -> 'hello world'
API to fetch employee details
Create a GET endpoint /employees to fetch all employee details
Include parameters like employee ID or department to filter results
Return employee details in JSON format with fields like name, age, position, etc.
Program to generate Fibonacci series using iterative approach.
Initialize variables for first two numbers in the series (0 and 1)
Use a loop to generate subsequent numbers by adding the previous two numbers
Store the generated numbers in an array
Repeat the process until desired number of Fibonacci numbers are generated
Decorators in Python are a design pattern that allows behavior to be added to individual objects.
Decorators are functions that modify the behavior of other functions.
They are used to add functionality to existing functions without changing their code.
Decorators are commonly used in Python with the @ symbol before the function definition.
Example: Creating a decorator to log the execution time of a function.
The git command to push code to a remote repository is 'git push', which uploads local changes to the remote server.
Use 'git push origin main' to push changes to the main branch of the remote repository.
If you're working on a feature branch, use 'git push origin feature-branch-name'.
To push all branches, use 'git push --all origin'.
To set the upstream branch for the current branch, use 'git push -u origin branch-name'.
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There was 1 interview round.
Code to check current webpage URL, types of functional testing, authentication and authorization, HTTP methods, status codes, selecting dropdown value, and SQL queries.
To check current webpage URL, use driver.getCurrentUrl() in Selenium WebDriver.
Types of functional testing include smoke testing, regression testing, integration testing, etc.
Authentication ensures the user is who they claim to be, while authorization de...
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
I applied via Walk-in and was interviewed in Apr 2024. There was 1 interview round.
The fastest locator in Selenium is By ID.
By ID is the fastest locator in Selenium as it directly targets the unique ID attribute of an element.
Using By ID reduces the time taken to locate an element compared to other locators like By XPath or By CSS Selector.
Example: driver.findElement(By.id("elementID"));
Scenario is a single test case in BDD framework, while scenario outline is a template for multiple similar test cases.
Scenario is a single test case with specific inputs and expected outcomes.
Scenario outline is a template for multiple similar test cases, with placeholders for different inputs.
Scenario outline uses Examples section to provide different sets of inputs for each test case.
Scenario outline helps in reducin...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
I applied via Job Portal and was interviewed in Mar 2024. There was 1 interview round.
To find the 2nd highest salary, use SQL queries to retrieve distinct salaries and order them.
Use the SQL query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
This query selects distinct salaries, orders them in descending order, and skips the highest salary.
Ensure the table has at least two distinct salary values to get a valid result.
Some of the top questions asked at the Capgemini Automation Test Engineer interview -
The duration of Capgemini Automation Test Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 38 interview experiences
Difficulty level
Duration
based on 141 reviews
Rating in categories
Consultant
59k
salaries
| ₹8.9 L/yr - ₹16.5 L/yr |
Associate Consultant
51.2k
salaries
| ₹4.5 L/yr - ₹10 L/yr |
Senior Consultant
50.5k
salaries
| ₹12.1 L/yr - ₹21 L/yr |
Senior Analyst
22k
salaries
| ₹3.1 L/yr - ₹7.6 L/yr |
Senior Software Engineer
21.7k
salaries
| ₹4.7 L/yr - ₹13.1 L/yr |
Wipro
Accenture
Cognizant
TCS