Test Engineer

• Develop and execute comprehensive test strategies and plans for Bank Data Warehouse solutions covering Bronze, Silver, Gold, OBT, and reporting layers, including risk-based priorities and coverage
• Execute ETL and data warehouse testing to validate data completeness, accuracy, timeliness, schema integrity, transformations, deduplication, null handling, and referential integrity.
• Develop complex Big Query SQL validation scripts using joins, CTEs, window functions, date functions, and aggregations to independently validate expected results and business rules.
• Perform source-to-target data reconciliation across Bronze, Silver, Gold, and OBT layers by validating row counts, financial amounts, key counts, balances, transactions, and customer/account data.
• Validate Gold-layer transformations and data models, including SCD Type 2 dimensions, effective dates, surrogate keys, bitemporal facts, referential integrity, transaction classifications, and historical data.
• Test OBT and downstream banking reports to validate join accuracy, derived fields, data completeness, reconciliation, report traceability, refresh accuracy, and query performance.
• Execute functional, integration, regression, and end-to-end business scenario testing covering customer onboarding, deposits, money movement, CD maturity, wire transfers, fraud, AML, and account lifecycle processes.
• Perform data quality and governance testing covering completeness, accuracy, consistency, timeliness, uniqueness, validity, PII handling, data lineage, and data-volume/drift validation.
• Develop and implement AI-assisted testing agents to analyze requirements, generate test scenarios and test cases, orchestrate automated test execution, and support SQL/data validation and regression testing.
• Manage defects and testing documentation by creating JIRA defects with SQL evidence, expected versus actual results, affected tables/reports, severity, test cases, traceability, and test reports.

Education :
Bachelor’s degree in Information Systems or Computer Science with 2-3 years of experience.

Skills Required :
Agil, Jira, Azure Dev Ops, PMP, CSM