Virtusa actively looking For DB Tester

Job description

Role: DB Tester Exp:3-10 yrs Location: Noida Work Mode: 5 days WFO Job Summary We are looking for a Database Tester with strong expertise in SQL, ETL testing, and Data Warehouse concepts. The ideal candidate should be experienced in validating data integrity, testing ETL workflows, and ensuring accurate data movement across source and target systems. Key Responsibilities - Design, develop, and execute database test cases and test scenarios. - Validate ETL processes to ensure accurate extraction, transformation, and loading of data. - Perform source-to-target data validation. - Write complex SQL queries for data verification and reconciliation. - Test data quality, completeness, consistency, and accuracy. - Validate database objects such as tables, views, stored procedures, functions, and triggers. - Analyze ETL mappings, transformation logic, and business rules. - Perform Data Warehouse testing, including fact and dimension table validation. Required Skills - Strong hands-on experience with SQL (joins, subqueries, CTEs, aggregate functions, window functions, stored procedures). - Experience in ETL testing and source-to-target validation. - Good understanding of Data Warehouse concepts: - Star Schema - Snowflake Schema - Fact & Dimension Tables - Slowly Changing Dimensions (SCD) - Data Marts - OLTP vs. OLAP **Interested candidates can send their updated CV to ishwaryan@virtusa.com**