NTT Data ETL Tester Interview Questions and Answers

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...read more

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...read more

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

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

Referential integrity ensures that relationships between tables are maintained in a database.

• It ensures that foreign key values in one table match primary key values in another table.

• It helps maintain consistency and accuracy of data in the database.

• If a foreign key value is deleted or updated, the corresponding primary key value should also be updated or deleted to maintain integrity.

Types of schema include star schema, snowflake schema, and fact constellation schema.

• Star schema: central fact table connected to dimension tables in a star-like structure.

• Snowflake schema: normalized form of star schema with dimension tables further normalized.

• Fact constellation schema: multiple fact tables share dimension tables.

Slowly Changing Dimensions (SCD) include Type 1, Type 2, and Type 3 dimensions.

• Type 1: Overwrite existing data with new data, no history is kept.

• Type 2: Create a new record for each change, maintaining history.

• Type 3: Create a new attribute to store changes, keeping limited history.

Snowflake schema is a normalized form of star schema with additional dimension tables.

• Snowflake schema is a data modeling technique used in data warehousing.

• In snowflake schema, dimensions are normalized into multiple related tables.

• Snowflake schema reduces redundancy and improves data integrity.

• Star schema is a denormalized form of snowflake schema with a single dimension table.

• In star schema, dimensions are not norma...read more