Role Summary

Reliance Matrix (RSL) is seeking an experienced Senior ETL QA Engineer with a background in ETL development to establish an end-to-end QA governance model. The ideal candidate possesses a deep understanding of data architecture, end-to-end data flows (from ETL pipelines to BI reports), and large-scale enterprise data validation. In this role, you will collaborate closely with developers and business analysts to reverse-engineer system architectures and create essential baseline QA documentation, including data mapping sheets and data lineage diagrams.

Key Responsibilities

- Test Strategy &
- Execution: Design and execute comprehensive test strategies for ETL pipelines, Data Warehouses (EDW/ADW), Data Lakes, and reporting systems.
- Data Validation: Validate batch processing, incremental loads, Change Data Capture (CDC), and historical data conversions.
- Database &
- Layer Testing: Perform backend database testing using complex SQL queries and stored procedures to validate staging tables, dimensions, facts, aggregate tables, and reporting layers.
- Transformation &
- Analytics Logic: Validate complex transformation logic, business rules,



and reporting accuracy between the data warehouse and business intelligence systems.
- Cross-Functional Collaboration: Partner with ETL developers, data engineers, business analysts, and product owners to ensure data integrity.
- Lifecycle Support: Drive System Integration Testing (SIT), User Acceptance Testing (UAT), regression testing, release validation, and post-deployment verification.

Required Qualifications

- Testing Experience: Minimum 7+ years of experience in ETL / Data Warehouse testing.
- Development Experience: Minimum 3 years of experience as an ETL / DW developer.
- BI Validation: Minimum 2+ years of experience in Business Intelligence (BI) and reporting validation or development.
- Database Expertise: Robust SQL expertise with large-scale enterprise databases, including hands-on experience with Oracle Autonomous Data Warehouse (ADW).
- Technical Skills: Proficiency with SQL Developer, CloudBerry, Python, and PySpark.
- Operations &
- Scripting: Practical experience with Shell Scripting, server log analysis, batch monitoring, and troubleshooting.
- Methodology: Proven experience working in Agile/Scrum environments.

📌 Software Engineer (Hyderabad)
🏢 Virtusa
📍 Hyderabad