Job Description:
Responsibilities:
Test Automation Development:
- Design and implement automated test scripts for database validation.
- Use tools like SQL, Python, Webdriver(with DB connectors), or specialized DB testing tools.
Data Validation:
- Verify data accuracy, consistency, and completeness across systems.
- Validate ETL processes and data transformations.
Performance Testing:
- Test database performance under load.
- Identify slow queries and optimize them.
Schema Validation:
- Ensure database schema changes are correctly implemented.
- Validate constraints, indexes, triggers, and stored procedures.
Integration Testing:
- Validate DB interactions with APIs, and mainframe app.
CI/CD Integration:
- Integrate DB tests into CI/CD pipelines for continuous validation.
Defect Reporting And Tracking:
- Log issues found during DB testing and work with developers to resolve them.