ETL Testing ETL Testing Tools and Automation 3

Question 1

Which Informatica feature is primarily used by ETL testers to validate data flows and transformation logic in Informatica PowerCenter?

Accepted Answer

Informatica Data Quality (IDQ) rules and mapplets

Answer

Informatica Cloud storage browser

Answer

Informatica MDM hub only

Answer

Informatica B2B data exchange

Question 2

What is 'test data management' (TDM) in the context of ETL testing?

Accepted Answer

The discipline of creating, masking, provisioning, and maintaining test datasets that accurately represent production data without exposing PII

Answer

Managing ETL job execution schedules

Answer

Tracking ETL software licenses

Answer

Managing database backup schedules

Question 3

In ETL testing automation, what is the benefit of using version-controlled ETL test scripts stored in Git?

Accepted Answer

It provides change history, enables team collaboration, and allows rollback of test logic changes

Answer

It makes test scripts run faster

Answer

It automatically fixes failed test assertions

Answer

It reduces cloud storage costs

Question 4

Which Python library is widely used in US data engineering teams to write unit tests for PySpark ETL transformations?

Accepted Answer

PyTest with PySpark's local mode or Chispa for DataFrame assertions

Answer

Selenium

Answer

Requests

Answer

BeautifulSoup

Question 5

What is 'observability' in the context of ETL pipeline testing and monitoring?

Accepted Answer

The ability to infer the internal state and health of an ETL pipeline from its external outputs, logs, and metrics

Answer

The ability to watch ETL jobs run in real time via a GUI

Answer

A database compliance audit feature

Answer

A UI testing technique

Question 6

Why is 'idempotency testing' particularly important for automated ETL pipelines that may be retried on failure?

Accepted Answer

To confirm that re-running a failed ETL job produces the same correct result without duplicating or corrupting data

Answer

To verify that the ETL job runs faster on the second attempt

Answer

To test that ETL jobs can run on different operating systems

Answer

To validate that retry logic notifies stakeholders by email