What are the responsibilities and job description for the Python Automation Testing QA position at Technogen, Inc.?
Python Automation Testing QA (Python ETL PyTest)
Job Description:
About the Role:
We are seeking a skilled Automation Engineer with expertise in Varicent products, Python automation, and database testing. The ideal candidate will have a strong background in software testing and automation, with a focus on ensuring the quality and reliability of our software solutions. Additionally, the candidate should be well-versed in Agile methodologies and practices.
Key Responsibilities:
- Develop and maintain automated test scripts using Python to ensure the quality of Varicent products.
- Work closely with product and engineering teams to understand features develop and automate test cases improve product quality.
- Perform database testing to validate data integrity and accuracy.
- Collaborate with cross-functional teams to understand requirements and develop test plans.
- Execute automated test cases and analyze results to identify defects and ensure product quality.
- Integrate automated tests into the CI/CD pipeline to ensure continuous testing.
- Document test cases, test results, and defects in a clear and concise manner.
- Participate in code reviews and provide feedback to improve the quality of the codebase.
- Stay up to date with the latest industry trends and best practices in test automation and database testing.
- Hands-on knowledge in any of the cloud provider like AWS, Azure etc. Also exposure to services like EC2, S3, RDS, Lambda etc.
- Create and maintain test data and test environments.
- Write and execute complex SQL queries (Joins, Rank, Union etc.) to validate data integrity and accuracy.
- Perform data validation and data quality checks.
- Develop and maintain database testing scripts and tools.
- Collaborate with database administrators to resolve database-related issues.
Must Have skills:
- ETL process, Database Testing and SQL (Complex queries)
- Hands-on experience in any of the cloud provider (AWS, GCP, Azure etc.)
- Python programming skills – PyTest
- Strong proficiency in Python programming and automation frameworks - PyTest
- API Test automation - Postman, SoapUI
- Experience with database testing, including writing and executing SQL queries.
- Familiarity with CI/CD tools and processes (e.g., Jenkins, GitHub Actions).
- Experience with data warehousing and ETL processes.
