Capgemini ETL Tester Interview Questions and Answers

A deferred bug is a bug that is not fixed immediately but is scheduled to be fixed in a future release.

• Deferred bugs are usually lower priority bugs that do not impact the core functionality of the system.

• These bugs are documented and tracked for resolution in a later release.

• Examples of deferred bugs include cosmetic issues, minor usability problems, or non-critical functionality issues.

Use SQL query with ORDER BY and LIMIT to get 4th highest row based on a column

• Use ORDER BY clause to sort the column in descending order

• Use LIMIT 1 OFFSET 3 to get the 4th highest row

• Example: SELECT * FROM table_name ORDER BY column_name DESC LIMIT 1 OFFSET 3

To find the nth highest value, use SQL queries with ranking functions or subqueries to filter results.

• Use the SQL query: SELECT DISTINCT column_name FROM table_name ORDER BY column_name DESC LIMIT 1 OFFSET n-1;

• Alternatively, use ROW_NUMBER() or RANK() functions in a Common Table Expression (CTE).

• Example: WITH RankedValues AS (SELECT column_name, ROW_NUMBER() OVER (ORDER BY column_name DESC) AS rank FROM table_name...read more

Agile methodologies are iterative approaches to software development that prioritize flexibility and collaboration.

• Agile methodologies involve breaking down projects into smaller, manageable tasks called user stories.

• They emphasize frequent communication and collaboration between team members.

• Agile methodologies prioritize responding to change over following a strict plan.

• Common components of Agile methodologies i...read more

Different stages in ETL include extraction, transformation, and loading of data.

• Extraction: Retrieving data from various sources such as databases, files, APIs, etc.

• Transformation: Cleaning, filtering, and converting the extracted data into a format suitable for analysis.

• Loading: Loading the transformed data into a data warehouse or target database for further processing.