i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Campus Placement and was interviewed in Nov 2021. There were 2 interview rounds.
Give your best
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
Drop command deletes the table structure along with data, while truncate command deletes only the data.
Drop command removes the table structure and all its data, while truncate command only removes the data but keeps the table structure intact.
Drop command is a DDL (Data Definition Language) command, while truncate command is a DML (Data Manipulation Language) command.
Drop command is slower than truncate command as it ...
In my project, I perform validations such as data completeness, data accuracy, data transformation, and data integrity checks.
Data completeness checks to ensure all required fields are populated
Data accuracy checks to verify the correctness of data
Data transformation checks to validate the transformation rules are applied correctly
Data integrity checks to maintain data consistency and reliability
Star Schema is a type of database schema where a central fact table is connected to multiple dimension tables. Snowflake Schema is a normalized form of Star Schema where dimension tables are further normalized into sub-dimension tables.
Star Schema has a central fact table connected to multiple dimension tables
Snowflake Schema is a normalized form of Star Schema with sub-dimension tables
Star Schema is denormalized for b...
Fact tables contain quantitative data while dimension tables contain descriptive attributes.
Fact tables store measurable, quantitative data such as sales revenue or quantity sold
Dimension tables store descriptive attributes related to the data in the fact table, such as product name or customer details
Fact tables are typically normalized while dimension tables are denormalized for easier querying
Example: In a sales dat...
I have worked on various projects involving test automation for web applications using Selenium and API testing using Postman.
Developed automated test scripts using Selenium WebDriver for regression testing of web applications
Created test suites and executed test cases using TestNG framework
Performed API testing using Postman to validate response data and status codes
Integrated test automation scripts with CI/CD pipeli...
API testing is a type of software testing that involves testing APIs directly to ensure they meet functionality, reliability, performance, and security requirements.
API testing involves testing the functionality, reliability, performance, and security of APIs.
It focuses on verifying the communication and data exchange between different software systems.
API testing can be done at different levels such as unit testing, i...
Post is used to create a new resource, while patch is used to update an existing resource.
Post is used to create a new resource in the server.
Patch is used to update an existing resource in the server.
Post request typically includes all the data needed to create the resource, while patch request only includes the data that needs to be updated.
Post requests are idempotent, meaning multiple identical requests will have t...
Priority and severity are used to classify the impact and importance of a defect in software testing.
Priority determines the order in which defects should be fixed, based on business needs.
Severity indicates the impact of a defect on the system or users.
Priority is usually set by the product owner or business stakeholders.
Severity is typically determined by the testing team based on the impact on functionality.
Examples...
HashMap is non-synchronized and allows null values, while Hashtable is synchronized and does not allow null values.
HashMap is non-synchronized and not thread-safe, while Hashtable is synchronized and thread-safe.
HashMap allows null values for both key and value, while Hashtable does not allow null keys or values.
HashMap is faster than Hashtable as it is non-synchronized.
HashMap is part of the Java Collections Framework
Types of exceptions in Selenium include NoSuchElementException, ElementNotVisibleException, StaleElementReferenceException, TimeoutException, and WebDriverException.
NoSuchElementException: Thrown when an element could not be found in the DOM.
ElementNotVisibleException: Thrown when an element is present in the DOM but not visible.
StaleElementReferenceException: Thrown when an element is no longer attached to the DOM.
Tim...
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, fields, and non-abstract methods, while interface cannot.
A class can implement multiple interfaces but can only inherit from one abstract class.
Abstract classes are used to define a common behavior for subclasses, while interfaces are used to define a contract for classes ...
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Project architecture refers to the overall structure of a software project, including components, modules, and their interactions.
Project architecture defines how different components of a software project are organized and interact with each other.
It includes the high-level design of the system, such as the database structure, data flow, and integration points.
Project architecture also involves decisions on technologi...
Challenges in ETL testing include data quality issues, complex transformations, and handling large volumes of data.
Data quality issues such as missing or incorrect data can impact testing results
Complex transformations can be difficult to validate and may lead to errors in the ETL process
Handling large volumes of data can slow down testing processes and require efficient testing strategies
Roles and responsibilities refer to the tasks and duties assigned to an individual within a specific job or position.
Roles define the position or job title of an individual within an organization.
Responsibilities outline the specific tasks, duties, and expectations associated with that role.
Roles and responsibilities help clarify expectations, define boundaries, and ensure accountability.
Examples include testing data e...
Use a dictionary to find duplicate values in an array of strings in Python.
Create an empty dictionary to store the count of each string in the array.
Iterate through the array and for each string, check if it exists in the dictionary. If it does, increment the count. If not, add it to the dictionary with a count of 1.
After iterating through the array, check the dictionary for any strings with a count greater than 1. The
Oops concepts refer to Object-Oriented Programming principles such as Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation det
Manual testing involves human testers executing test cases without automation tools, while automation testing uses tools to execute test cases.
Manual testing requires human intervention to execute test cases and verify results
Automation testing involves using tools to automate test case execution and result verification
Manual testing is time-consuming and prone to human error
Automation testing is faster, more reliable,...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Performance testing is a type of testing to ensure software applications perform well under expected workload.
Performance testing evaluates the speed, responsiveness, and stability of an application under various load conditions.
It helps identify bottlenecks, performance issues, and areas for improvement in the application.
Types of performance testing include load testing, stress testing, and scalability testing.
Tools ...
Correlation is a statistical measure that describes the strength and direction of a relationship between two variables.
Correlation values range from -1 to 1, with 0 indicating no correlation, 1 indicating a perfect positive correlation, and -1 indicating a perfect negative correlation.
Positive correlation means that as one variable increases, the other variable also increases. Negative correlation means that as one var...
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Different types of waits include implicit, explicit, and fluent waits in automation testing.
Implicit wait: Waits for a certain amount of time before throwing a NoSuchElementException.
Explicit wait: Waits for a certain condition to occur before proceeding further in the code.
Fluent wait: Waits for a condition to be true with a specified frequency of checking.
Example: WebDriverWait in Selenium is an example of explicit w
Multiple window handles are used in automation testing to handle multiple browser windows or tabs simultaneously.
Use getWindowHandles() method to get all the window handles
Switch between window handles using switchTo().window(handle)
Close a specific window handle using driver.close()
Example: driver.getWindowHandles()
Example: driver.switchTo().window(handle)
I applied via Job Portal
Reasoning,numerical ,ratios
Basic coding questions
I applied via Company Website and was interviewed in Jan 2024. There were 2 interview rounds.
Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.
Inner join only includes rows with matching values in both tables
Outer join includes all rows from both tables, even if there are no matching values
Types of outer joins include left outer join, right outer join, and full outer join
To test an ATM machine, I would perform functional, security, and usability testing to ensure it operates correctly and securely.
Test the functionality of withdrawing cash, depositing cash, checking balance, transferring funds, etc.
Perform security testing to check for vulnerabilities such as card skimming, unauthorized access, etc.
Conduct usability testing to ensure the interface is user-friendly and intuitive for cus...
I have worked on a project testing a mobile banking application for a major financial institution.
Performed functional testing to ensure all features worked correctly
Conducted regression testing after each new release
Collaborated with developers to troubleshoot and resolve issues
Created and executed test cases based on user stories
I have previously used MySQL and MongoDB databases.
MySQL was used for relational database management system.
MongoDB was used for NoSQL database management system.
based on 2 reviews
Rating in categories
Consultant
55.4k
salaries
| ₹5.1 L/yr - ₹18 L/yr |
Associate Consultant
52.8k
salaries
| ₹2.9 L/yr - ₹11.6 L/yr |
Senior Consultant
45.9k
salaries
| ₹7.3 L/yr - ₹24 L/yr |
Senior Analyst
20.3k
salaries
| ₹2 L/yr - ₹9 L/yr |
Senior Software Engineer
19.8k
salaries
| ₹3.5 L/yr - ₹12.4 L/yr |
Wipro
Accenture
Cognizant
TCS