What methods do you use to validate data quality in a fast-paced environment?
Use SQL to apply practical validation checks to issuer filing records for the reporting period ending 2026-09-30. Identify issuers with missing filings, duplicate filings, missing dates, or invalid statuses.
issuer_id, issuer_name, filing_count, null_filing_date_count, invalid_status_count, and quality_status.quality_status to PASS only when exactly one filing exists, no required date is null, and no status is invalid. Order by issuer_id ascending.| Column | Type | Description |
|---|---|---|
| issuer_idPK | INT | Unique issuer identifier |
| issuer_name | VARCHAR(150) | Issuer name |
| Column | Type | Description |
|---|---|---|
| filing_idPK | INT | Unique filing identifier |
| issuer_id | INT | Issuer associated with the filing |
| filing_date | DATE | Date the filing was submitted |
| reporting_period | DATE | Period end date covered by the filing |
| status | VARCHAR(30) | Filing lifecycle status |
| source_reference | VARCHAR(100) | Reference supplied by the source system |