Testing (Liquidity)

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the  British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. 

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 / Good to have)

· Understanding of Liquidity metrics and reporting concepts, including Liquidity Matrix, LCR and NSFR.

· Knowledge of RRP, Funding in Resolution, and collateral management/loan collateral management (Good to have).

Technical skills (Manual UAT – data focus)

· Advanced SQL capability for reconciliation and validation across multiple sources/systems; able to produce audit-ready evidence from queries and extracts.

· Proven experience executing UAT where key attributes must be validated for accuracy, completeness, and consistency across upstream/downstream sources.

· Experience transitioning from spreadsheet-based UAT tracking to Jira-based test management; ability to structure test cycles, capture execution evidence, and run defect workflows in Jira.

· Strong defect triage and diagnostic capability (data vs mapping vs calculation vs timing/cut-off vs UI).

· UAT evidence packs and concise release readiness summaries for governance and sign-off.

Tools & technology

· SQL

· Jira

· Qlik Sense, Tableau

· Advanced Excel, MS Office Suite

· Big Query

· SharePoint