DescriptionThis role is for one of the Weekday's clients
Salary range: Rs 400000 - Rs 1200000 (ie INR 4 - 12 LPA)
Min Experience: 6 years
Location: Chennai
JobType: full-time
The ideal candidate will have strong expertise in Python-based automation, complex SQL querying, and validating large datasets in cloud environments (AWS/Azure/GCP). This role requires active participation across the sprint lifecycle, ensuring quality is embedded from requirement grooming to production release.
RequirementsKey Responsibilities:
- Create, develop, and implement both manual and automated tests for data pipelines and APIs
- Verify large datasets to ensure completeness, accuracy, timeliness, and consistency with schemas
- Construct complex SQL queries to compare and validate data from source to target
- Conduct database testing and validate ETL/ELT workflows using Airflow or similar orchestration tools
- Develop and sustain automation scripts using Python, with a preference for Pytest
- Carry out unit, integration, regression, smoke, and end-to-end testing cycles
- Integrate automated tests within CI/CD pipelines
- Convert JIRA user stories and acceptance criteria into comprehensive test cases and validation scripts
- Ensure traceability between requirements and test coverage
- Actively engage in Agile ceremonies including grooming, sprint planning, daily stand-ups, and retrospectives
- Provide support for UAT and production validation, including smoke testing after releases
- Document, track, and analyze defects and perform root cause analysis
- Maintain detailed test documentation for audit and compliance purposes
- Contribute to release governance activities such as QA gates and validation checkpoints
- Continuously enhance automation frameworks, testing procedures, and QA best practices
Required Skills:
- 6 to 8 years of experience in QA focusing on Data, API, and Database Testing
- Strong practical experience in Python for automation scripting is mandatory
- Expert in writing complex SQL queries for validating large datasets
- Demonstrated expertise in database testing and ETL/ELT validation
- Experience with automation testing frameworks, preferably Pytest
- Hands-on experience with CI/CD tools and version control systems such as Git
- Familiarity with JIRA or similar Agile project management tools
- Practical experience with at least one Cloud platform (AWS, Azure, or GCP) is required
- Experience validating data workflows in environments with high data volumes
- Strong analytical and problem-solving abilities
- Effective communication skills and the ability to collaborate within a shared sprint model
Skills
Automation testing
Python
Selenium
API Testing
Database Testing
SQL