This 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.

Key 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