Role purpose
Own and execute data-focused manual UAT, ensuring end-to-end processing integrity across UI, database layers, interfaces, and downstream operational reporting. Drive the transition of UAT management from Excel-based tracking to Jira, producing audit-ready evidence and clear release readiness recommendations.
Key responsibilities
- Perform strong SQL-driven data testing and reconciliation across multiple systems/sources, evidencing outcomes with repeatable queries and extracts.
- Validate end-to-end processing using database reconciliations, interface reports/extracts, and batch outputs to confirm completeness and accuracy.
- Reconcile critical attributes (e.g., facility/loan terms, collateral eligibility, valuation/haircut parameters, allocation/margin results) across application UI, database tables/views, and downstream operational reports to ensure consistency and effective control.
- Prepare UAT summary reports, including execution status, key risks/issues, and release readiness recommendations.
- Lead/assist the migration of UAT artefacts from Excel into Jira (test cases, cycles, evidence, defects), helping define templates, workflows, traceability, and reporting.
- Operate comfortably within standardized delivery workflows, dashboards, and metrics (execution progress, defect ageing, retest rate, pass/fail trends), maintaining transparent status and quality indicators.
- Triage and manage defects effectively, isolating whether issues relate to data quality, mapping, calculations, timing/cut-off, interface/batch processing, or UI presentation.
- Respond to ad hoc requests from senior stakeholders with clear, data-backed analysis and timely updates.
- Conduct root cause analysis (RCA) and gap analysis, translating findings into actionable fixes and control improvements.
Domain knowledge (preferred / Positive to have)
- Understanding of Liquidity metrics and reporting concepts, including Liquidity Matrix, LCR and NSFR.
- Knowledge of RRP, Funding in Res
📌 Collateral Tester (India)
🏢 CAPCO
📍 India