Software Engineer

12 hours ago

Bengaluru, Karnataka, India Virtusa Full-time
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: Strong 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.