Filter interviews by
Power BI offers various chart types for data visualization, enhancing insights and decision-making.
Bar Chart: Displays categorical data with rectangular bars (e.g., sales by region).
Column Chart: Similar to bar charts but vertical (e.g., monthly revenue).
Line Chart: Shows trends over time (e.g., stock prices over a year).
Pie Chart: Represents proportions of a whole (e.g., market share by company).
Area Chart: Simil...
User access testing ensures that users have appropriate permissions and access levels to systems and data.
Verification of user roles: Ensuring users have the correct role-based access, e.g., admin vs. regular user.
Access control checks: Testing if unauthorized users can access restricted areas, e.g., sensitive patient records.
Audit trails: Reviewing logs to confirm that access attempts are recorded and monitored.
U...
Identify top 3 accounts with highest transaction volume each month using SQL or data analysis techniques.
Use SQL query to group transactions by account and month.
Calculate total transaction volume for each account per month.
Sort results by transaction volume and limit to top 3 accounts.
Example SQL: SELECT account_id, SUM(amount) as total_volume FROM transactions GROUP BY account_id, MONTH(date) ORDER BY total_volu...
Remove duplicates from a sorted array by modifying the array in place and returning the new length.
Iterate through the array using a pointer to track unique elements.
If the current element is different from the last unique element, add it to the unique position.
Return the length of the modified array as the result.
Example: For input ['a', 'a', 'b', 'b', 'c'], the output will be ['a', 'b', 'c'] with length 3.
What people are saying about KPMG India
Find the length of the longest substring without repeating characters using a sliding window approach.
Use a sliding window technique with two pointers to track the current substring.
Maintain a set to store characters in the current substring.
Expand the right pointer to include new characters until a repeat is found.
When a repeat is found, move the left pointer to shrink the window until the repeat is removed.
Examp...
List comprehension is a concise way to create lists in Python using a single line of code.
Creates a new list by applying an expression to each item in an iterable.
Syntax: [expression for item in iterable if condition]
Example: squares = [x**2 for x in range(10)] results in [0, 1, 4, 9, 16, 25, 36, 49, 64, 81]
Can include conditions: evens = [x for x in range(10) if x % 2 == 0] results in [0, 2, 4, 6, 8]
Gamma Testing is a type of software testing that focuses on evaluating the system's performance and functionality under various conditions.
Performance Evaluation: Gamma Testing assesses how well the software performs under different loads, ensuring it can handle expected user traffic.
Functionality Testing: It verifies that all features work as intended, identifying any bugs or issues before the software goes live.
...
SDET stands for Software Development Engineer in Test, focusing on both development and testing to ensure software quality.
Dual Role: SDETs combine skills from both software development and testing, allowing them to write automated tests and develop testing frameworks.
Automation Expertise: They are proficient in automation tools and frameworks, such as Selenium, JUnit, or TestNG, to streamline testing processes.
Co...
Reversing a string involves rearranging its characters in the opposite order, which can be done using various programming techniques.
Using Built-in Functions: Many programming languages have built-in functions to reverse strings. For example, in Python: `reversed_string = original_string[::-1]`.
Using Loops: You can manually reverse a string by iterating through it in reverse order. Example in Java: `for (int i = s...
A program to identify and group anagrams from a list of strings.
An anagram is a word formed by rearranging the letters of another word, e.g., 'listen' and 'silent'.
To find anagrams, sort the characters of each string and group them by the sorted result.
Example input: ['eat', 'tea', 'tan', 'ate', 'nat', 'bat']
Example output: [['eat', 'tea', 'ate'], ['tan', 'nat'], ['bat']]
Use a dictionary to map sorted strings to t...
I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 3 interview rounds.
Business owners and banks/lenders have varying reactions to loan defaults and business rehabilitations depending on the circumstances.
Banks/lenders may initiate legal action to recover their funds
Business owners may face challenges in obtaining future loans
Rehabilitation efforts may be viewed positively if the business has a solid plan for recovery
The severity of the default/crisis and the business's financial history ...
A new Business and Corporate restructuring division should focus on strategic growth, operational efficiency, and market adaptability.
Market Analysis: Conduct thorough market research to identify trends and opportunities for restructuring, such as the rise of digital transformation in industries.
Client-Centric Approach: Develop tailored solutions for clients, like creating customized restructuring plans for companies f...
The pandemic has caused significant disruptions in global, regional, and local markets, creating consulting opportunities for the Firm.
The pandemic has accelerated the shift towards digitalization and remote work, creating opportunities for consulting in areas such as cybersecurity and virtual collaboration tools.
The pandemic has also highlighted the importance of supply chain resilience, creating opportunities for con...
Cross selling and leveraging on firm's capabilities is crucial for building business and client relationships.
Cross selling helps to increase revenue and deepen client relationships.
Leveraging on firm's capabilities in other service areas can provide a competitive advantage.
It is important to understand the client's needs and offer relevant services.
Effective communication and collaboration between service areas is nec...
I appeared for an interview in Jan 2025.
Selenium architecture allows for automation testing of web applications using C# bindings.
Selenium WebDriver interacts with web browsers to automate testing
C# bindings provide a way to write test scripts in C# language
Selenium Grid allows for parallel testing on multiple machines
Selenium IDE for recording and playback of test scripts
OOP concepts in my project include encapsulation, inheritance, and polymorphism.
Encapsulation: Data hiding and bundling of data with methods to operate on that data.
Inheritance: Ability to create new classes based on existing classes, promoting code reusability.
Polymorphism: Ability for objects of different classes to respond to the same method call.
Example: Using inheritance to create a base class 'Shape' with subclas...
Locators are used to identify web elements in automated testing. XPath is a language used to navigate XML documents.
Locators are used to find and interact with elements on a web page in automated testing.
XPath is a language for navigating XML documents and is commonly used to locate elements on a web page.
Types of XPath include Absolute XPath, Relative XPath, Contains XPath, and more.
Absolute XPath starts from the root...
Yes, I have experience managing cookies and caches in automation.
Yes, I have written automation scripts to handle cookies by setting, getting, and deleting them.
I have also managed browser caches in automation to ensure accurate testing results.
Utilized tools like Selenium WebDriver to interact with cookies and caches during test execution.
I have managed team members by setting clear expectations, providing support and guidance, and fostering a collaborative environment.
Set clear expectations for team members regarding goals, deadlines, and responsibilities.
Provide support and guidance to team members to help them succeed in their roles.
Foster a collaborative environment where team members can communicate openly and work together effectively.
Recognize an...
I prioritize testing based on critical functionalities, automate repetitive tasks, and collaborate with stakeholders to adjust scope if necessary.
Prioritize testing based on critical functionalities
Automate repetitive tasks to save time
Collaborate with stakeholders to adjust scope if necessary
Defect life cycle is the process of identifying, reporting, fixing, retesting, and closing defects in software development.
Defect identification: Defects are identified through testing or user feedback.
Defect reporting: Defects are reported in a defect tracking system with details like severity and priority.
Defect fixing: Developers fix the reported defects based on the information provided.
Defect retesting: Testers ve...
A test scenario is a detailed description of a specific test case or situation to be tested.
Test scenario outlines the steps to be taken, data inputs, and expected outcomes.
It helps in ensuring complete test coverage and identifying potential issues.
Example: Test scenario for login functionality - enter valid username and password, click login button, verify successful login.
Test coverage is the measure of how much of the code is tested, while a test matrix is a document that maps test cases to requirements.
Test coverage measures the extent to which the source code of a program is executed during testing.
A test matrix is a document that maps test cases to requirements, helping to ensure that all requirements are covered by test cases.
Test coverage can be used to determine the effectiveness...
I prioritize tasks based on impact and urgency, communicate with stakeholders, and seek consensus to resolve conflicts.
Prioritize tasks based on impact and urgency
Communicate with stakeholders to understand their perspectives
Seek consensus by discussing conflicting priorities with team members
Use data and metrics to support decision-making
Stay flexible and adapt to changing priorities
In Gherkin language, 'Given' sets up the initial context, 'When' describes the action taken, and 'Then' specifies the expected outcome.
Given: Describes the initial state or precondition of the scenario
When: Represents the action or event that occurs
Then: Defines the expected outcome or result after the action is taken
Example: Given a user is logged in, When they click on the 'Logout' button, Then they should be logged ...
A scenario is a single test case while a scenario outline is a template for multiple similar test cases with different inputs.
Scenario is a single test case with specific inputs and expected outcomes
Scenario outline is a template for multiple test cases with placeholders for inputs
In scenario outline, examples table is used to provide different input values for each test case
I have contributed to the framework by designing and implementing new test cases, improving existing test scripts, and enhancing automation capabilities.
Designed and implemented new test cases to cover additional functionalities
Improved existing test scripts for better efficiency and coverage
Enhanced automation capabilities by integrating new tools and technologies
Collaborated with developers to identify and resolve is...
POM file includes information about project dependencies, build settings, and plugins in Maven projects.
Project dependencies
Build settings
Plugins
WebDriver is a tool for automating web application testing, while ChromeDriver is a specific implementation for controlling Chrome browser.
WebDriver is a generic tool that supports multiple browsers, while ChromeDriver is specifically for Chrome browser.
WebDriver provides a common API for interacting with different browsers, while ChromeDriver is used to control Chrome browser instances.
WebDriver can be used with diffe...
XPath is a query language for selecting nodes from an XML document.
XPath uses path expressions to navigate through elements and attributes in an XML document
Syntax includes using slashes to separate elements, square brackets for conditions, and @ symbol for attributes
Examples: //bookstore/book[1] selects the first book element under the bookstore element
Dynamic elements on a webpage are managed using various techniques like waiting for element visibility, using explicit waits, and handling AJAX calls.
Use explicit waits to wait for the element to be present, visible, clickable, etc.
Use dynamic locators like XPath, CSS selectors, or relative locators to locate elements that change dynamically.
Handle AJAX calls by waiting for the call to complete before interacting with ...
To inspect a drop-down element in Selenium, use the 'Select' class to interact with it.
Use the 'Select' class from Selenium's WebDriver library to interact with drop-down elements
Identify the drop-down element using its locator (id, name, class, etc.)
Instantiate a new Select object by passing the drop-down element as a parameter
Use Select object methods like selectByVisibleText(), selectByValue(), selectByIndex() to in...
A framework is a structured set of guidelines, libraries, and tools used to develop and test software applications.
A framework provides a foundation for building software applications by defining the overall structure and design patterns.
It includes reusable components, libraries, and utilities that help in automating tasks and improving efficiency.
Frameworks can be categorized into different types such as testing fram...
Feature file linking is the process of connecting feature files with step definition files in BDD testing.
Feature files contain scenarios written in Gherkin language
Step definition files contain the actual code implementation for the steps in feature files
Linking is done by specifying the path to the step definition file in the feature file
This allows the automation tool to execute the steps defined in the feature file
LINQ is used to query data from different data sources in C#, purpose is to simplify data querying, validate database data against UI using LINQ queries.
LINQ is used in C# to query data from different data sources like collections, databases, XML, etc.
Purpose of LINQ is to simplify data querying by providing a uniform way to query different types of data sources.
To validate database data against the user interface, LIN...
I appeared for an interview in Jan 2025.
Programming questions related to Python and React.
Programmatical problem related to Python and React
Programming Problems related to react and python.
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Sales data from a leading manufacturer
I appeared for an interview in Feb 2025, where I was asked the following questions.
I am a passionate software developer with a strong background in full-stack development and a love for problem-solving.
Experience in JavaScript frameworks like React and Angular, building dynamic web applications.
Proficient in backend technologies such as Node.js and Express, creating RESTful APIs.
Strong understanding of databases, both SQL (PostgreSQL) and NoSQL (MongoDB), for efficient data management.
Worked on a tea...
I bring a unique blend of technical skills, problem-solving abilities, and a passion for collaboration that drives project success.
Strong Technical Skills: Proficient in Java, Spring Boot, and React, demonstrated by developing a full-stack application that improved user engagement by 30%.
Problem-Solving Mindset: Successfully resolved a critical performance issue in a legacy system, reducing load time by 50% through cod...
I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.
I appeared for an interview in Jan 2025.
Yes, I am open to relocating for the right opportunity.
I am open to relocating for the right opportunity
I have experience moving for previous jobs
I am willing to consider relocation for the right position
Briefly 2 topic write depend upon 2 questions given
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
GD TOPIC - AI is Bane or Boon
Internal Audit is a systematic and independent evaluation of an organization's operations to ensure effectiveness, efficiency, and compliance.
Planning: Define scope, objectives, and methodology of the audit.
Fieldwork: Collect and analyze data, identify risks and controls.
Reporting: Communicate findings, recommendations, and action plans.
Follow-up: Monitor implementation of recommendations and track progress.
Examples: P...
Change Management involves controlling changes to IT systems, while Access Control Management focuses on managing user access to these systems.
Change Management is the process of managing changes to IT systems in a controlled and systematic manner.
Access Control Management involves managing user access to IT systems, ensuring only authorized users have access to specific resources.
Change Management includes steps like ...
A Quality Analyst ensures that products meet specified standards and requirements through testing and evaluation processes.
Testing Methodologies: Quality Analysts use various testing methods such as manual testing, automated testing, and regression testing to ensure software quality.
Defect Tracking: They identify, document, and track defects using tools like JIRA or Bugzilla, ensuring that issues are resolved before pr...
In five years, I envision myself as a seasoned Quality Analyst, leading projects and mentoring new team members to ensure quality excellence.
Career Advancement: I aim to progress to a Senior Quality Analyst role, where I can take on more responsibilities and lead quality initiatives.
Skill Development: I plan to enhance my skills in automation testing tools like Selenium and performance testing tools like JMeter to impr...
posted on 8 Oct 2024
I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.
Use LOD calculations to display top and bottom values in one sheet in Tableau.
Use Level of Detail (LOD) calculations to create separate calculated fields for top and bottom values.
Use these calculated fields in the same sheet to display both top and bottom values.
For example, create a calculated field for top values using {FIXED [Dimension]: MAX([Measure])} and another for bottom values using {FIXED [Dimension]: MIN([M...
Parameters and filters are key features in Tableau for dynamic data analysis and visualization.
Parameters allow users to input values that can be used in calculations, filters, and reference lines.
Filters are used to limit the data displayed in a visualization based on specified criteria.
Parameters can be used to create dynamic filters that allow users to interact with the data in real-time.
Combining parameters and fil...
Types of LOD include Fixed, Include, and Exclude LOD calculations for different use cases.
Fixed LOD: Used to ignore the level of detail in the view and compute an aggregate value.
Include LOD: Used to compute an aggregate value at a higher level of detail than the view.
Exclude LOD: Used to compute an aggregate value at a lower level of detail than the view.
Tableau Prep is a data preparation tool that allows users to clean, combine, and shape data for analysis in Tableau.
Tableau Prep helps in cleaning and transforming data before visualizing it in Tableau Desktop.
It allows users to easily combine multiple data sources and perform data cleaning tasks like removing duplicates, splitting columns, and aggregating data.
Tableau Prep also provides a visual interface for creating...
Snowflake schema is a normalized form of Star schema with multiple levels of dimension tables.
Snowflake schema has normalized dimension tables, while Star schema has denormalized dimension tables.
Snowflake schema is more complex and requires more joins compared to Star schema.
Star schema is easier to understand and query, making it more suitable for smaller datasets.
Snowflake schema is more suitable for larger datasets...
Some of the top questions asked at the KPMG India interview -
The duration of KPMG India interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 689 interview experiences
Difficulty level
Duration
based on 6.2k reviews
Rating in categories
3-8 Yrs
Not Disclosed
6-12 Yrs
Not Disclosed
Consultant
8.6k
salaries
| ₹6.8 L/yr - ₹27 L/yr |
Assistant Manager
7.8k
salaries
| ₹11 L/yr - ₹33 L/yr |
Associate Consultant
5.1k
salaries
| ₹4.6 L/yr - ₹18 L/yr |
Analyst
3.7k
salaries
| ₹1 L/yr - ₹9.4 L/yr |
Manager
3.5k
salaries
| ₹15.5 L/yr - ₹47.5 L/yr |
Cognizant
PwC
Capgemini