Capgemini ETL Tester Interview Questions, Process, and Tips

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

Self join is a SQL technique where a table is joined with itself to compare rows within the same table.

• Self join is used when we need to compare rows within the same table.

• It is useful for hierarchical data structures like employee-manager relationships.

• Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id

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 includ

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.