What are the responsibilities and job description for the QA Automation/ ETL Tester-(Exp Level- 8+ Years )-Full time-Hybrid position at Visionary Innovative Technology Solutions?
We are seeking an experienced Senior QA Automation Engineer with strong expertise in ETL Testing, Data Warehouse Testing, SQL, Database Validation, and Test Automation. The ideal candidate should have hands-on experience validating complex data extraction, transformation, and loading processes, along with strong automation experience using Selenium WebDriver or Playwright.
Experience in the Banking and Financial Services domain is highly preferred.
Key Responsibilities
ETL & Data Warehouse Testing
- Design and execute comprehensive test strategies for ETL and data warehouse applications.
- Validate end-to-end Extract, Transform, and Load (ETL) processes.
- Verify data accuracy, completeness, consistency, and integrity across source and target systems.
- Perform data reconciliation between source systems, staging areas, and target data warehouses.
- Validate data transformation rules and business logic.
- Identify data quality issues and work with development and data engineering teams to resolve defects.
SQL & Database Testing
- Write and execute complex SQL queries for data validation and reconciliation.
- Perform database testing using Oracle and SQL Server.
- Validate stored procedures, views, tables, and data transformations.
- Perform backend validation and data integrity testing.
- Support database test automation initiatives.
- Analyze query results and identify data mismatches or inconsistencies.
Test Automation
- Design, develop, and maintain automated test scripts using:
- Selenium WebDriver
- Playwright
- Automate functional, regression, integration, and data validation test cases.
- Develop reusable automation frameworks and utilities.
- Integrate automation testing into CI/CD pipelines where applicable.
- Improve automation coverage and reduce manual testing efforts.