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.
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.
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
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'
What people are saying about Capgemini
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.
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...
Selenium is an open-source framework for automating web applications for testing purposes across different browsers and platforms.
Supports multiple programming languages like Java, C#, Python, and Ruby.
Allows for cross-browser testing, ensuring compatibility with Chrome, Firefox, Safari, etc.
Provides a suite of tools including Selenium WebDriver, Selenium IDE, and Selenium Grid.
WebDriver interacts directly with th...
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...
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 ...
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'.
Selenium is an open-source framework for automating web applications for testing purposes across different browsers and platforms.
Supports multiple programming languages like Java, C#, Python, and Ruby.
Allows for cross-browser testing, ensuring compatibility with Chrome, Firefox, Safari, etc.
Provides a suite of tools including Selenium WebDriver, Selenium IDE, and Selenium Grid.
WebDriver interacts directly with the bro...
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.
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 development...
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 Chrom...
I applied via Walk-in and was interviewed in Apr 2024. There was 1 interview round.
Java program to find frequency of characters in a string.
Create a HashMap to store characters and their frequencies.
Iterate through the string and update the frequencies in the HashMap.
Print the frequencies of each character in the string.
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 138 reviews
Rating in categories
Consultant
58.6k
salaries
| ₹8.9 L/yr - ₹16.5 L/yr |
Associate Consultant
51.2k
salaries
| ₹4.5 L/yr - ₹10 L/yr |
Senior Consultant
50k
salaries
| ₹12.4 L/yr - ₹21 L/yr |
Senior Analyst
22.1k
salaries
| ₹3.1 L/yr - ₹7.5 L/yr |
Senior Software Engineer
21.6k
salaries
| ₹4.7 L/yr - ₹12.9 L/yr |
Wipro
Accenture
Cognizant
TCS