PwC Interview Questions, Process, and Tips for Experienced

Different types of joins in SQL are inner join, left join, right join, and full outer join.

• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in either table

The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.

• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROU...read more

findElements returns a list of web elements matching the locator, while findElement returns the first web element matching the locator.

• findElements returns a list of web elements, findElement returns the first element

• findElements returns an empty list if no elements are found, findElement throws NoSuchElementException

• findElements is useful for finding multiple elements, findElement is useful for finding a single elemen

The code takes a name as input, prints each letter, and checks if any vowels repeat in the name.

• Create a function that takes a string input for the name

• Iterate through each letter in the name and print them individually

• Check for vowel repetition by keeping track of vowels encountered

Fluent wait is a dynamic wait mechanism in Selenium WebDriver that waits for a condition to be true before proceeding.

• Fluent wait is used to handle dynamic web elements that may load at different times.

• It can define the maximum amount of time to wait for a condition, as well as the frequency of checking.

• Example: WebDriverWait wait = new WebDriverWait(driver, 10); wait.until(ExpectedConditions.visibilityOfElementLocated

I am an Automation Engineer with experience in designing and implementing automated test scripts for web applications.

• Designed and implemented automated test scripts using Selenium WebDriver for regression testing

• Collaborated with developers to integrate automated tests into continuous integration pipeline

• Performed manual testing to identify bugs and validate automated test results

Capacity planning involves analyzing current and future resource needs to ensure optimal performance and efficiency.

• Assess current resource utilization and performance levels

• Forecast future demand based on historical data and growth projections

• Identify potential bottlenecks or areas of inefficiency

• Allocate resources accordingly to meet demand without over-provisioning

• Regularly review and adjust capacity plans as needed

Sprint planning involves setting goals, prioritizing tasks, estimating effort, and assigning work for the upcoming sprint.

• Discuss goals and objectives for the sprint with the team

• Prioritize the backlog items based on importance and dependencies

• Estimate the effort required for each task using story points or other metrics

• Assign tasks to team members based on their skills and availability

• Create a sprint backlog detailing

As a Scrum Master, my roles in Sprint Ceremonies include facilitating Daily Standups, Sprint Planning, Sprint Review, and Sprint Retrospective.

• Facilitate Daily Standups to ensure team members are aligned on goals and tasks for the day.

• Lead Sprint Planning meetings to help the team prioritize and commit to work for the upcoming sprint.

• Organize Sprint Review sessions to showcase completed work to stakeholders and gather ...read more

The team strength for the teams I facilitated Scrum ranged from 5 to 10 members.

• Team sizes varied based on the project requirements and complexity

• Smaller teams of 5 members were more efficient for quick decision-making

• Larger teams of 10 members were beneficial for complex projects requiring diverse skill sets

Kanban is another popular framework apart from Scrum.

• Kanban focuses on visualizing work, limiting work in progress, and maximizing flow.

• It is more flexible than Scrum as it does not have fixed time boxes like sprints.

• Kanban is often used in continuous delivery environments where work items have varying priorities and deadlines.

I am a detail-oriented individual with a strong background in accounting and auditing.

• Graduated with a degree in Accounting

• Completed internships at accounting firms

• Strong knowledge of auditing standards and procedures

• Excellent analytical and problem-solving skills

• Effective communication and teamwork abilities

I have been engaged in auditing various industries including manufacturing, retail, technology, and financial services.

• Manufacturing industry audits involved reviewing inventory management and cost control processes.

• Retail industry audits focused on sales and revenue recognition practices.

• Technology industry audits included assessing internal controls over software development and intellectual property.

• Financial servic...read more