Key Responsibilities
Database & Data Validation
· Perform end-to-end database testing and data quality validation.
· Write and execute complex SQL queries involving:
- Joins
- Aggregations
- Window Functions
- CTEs and Temporary Tables
- Validate stored procedures, triggers, and business transformation logic
- Develop reconciliation queries and repeatable SQL validation scripts.
ETL / Batch Processing Validation
· Test batch processing, ETL/ELT workflows, and synchronization jobs.
· Validate incremental loads, delta processing, and reprocessing scenarios.
· Ensure data consistency and integrity across source and target systems.
Database Concepts
· Working knowledge of:
- Transactions
- Isolation levels
- Locking mechanisms
- Deadlocks
· Ability to identify and troubleshoot database-related issues (DBA-level expertise not required).
Quality Assurance & Defect Management
· Create detailed defect repor...