Data & Functional Validation
-
Validate end-to-end data flows from source systems (SAP/ODP, CTRM, pricing) into Aurora/PostgreSQL.
-
Perform data validation and reconciliation to ensure accuracy, completeness, and consistency.
-
Support validation of risk outputs (positions, exposures, pricing, P&L) against defined business logic
Pipeline & Ingestion Testing
-
Test ETL/ELT pipelines for correctness, data integrity, and consistency.
-
Validate snapshot and delta ingestion processes, including CDC scenarios.
-
Verify handling of edge cases such as data ordering, duplication (idempotency), and recovery.
Test Automation & Execution
-
Develop and maintain test cases and automated test scripts for data pipelines and SQL transformations.
-
Execute functional, regression, and integration testing across data and reporting layers.
-
Contribute to test automation frameworks using Python or similar tools.
Performance & EOD Validation
-
Support testing of high-volume data processing, especially end-of-day (EOD) workloads.
-
Identify data discrepancies and performance issues during peak processing.
Defect Management & Collaboration
-
Log, track, and support resolution of defects and data issues.
-
Work closely with engineers and analysts to analyze root causes and validate fixes.
-
Participate in test planning, sprint activities, and release validation.
