Responsibilities
- Design develop and maintain automated testing frameworks for backend data validation.
- Develop test scripts using Python to validate large datasets across various sources.
- Perform data integrity and consistency checks.
- Leverage SQL to create optimize and execute queries for validating backend data pipelines.
- Download and validate data from APIs to ensure accuracy and consistency across datasets.
- Work closely with development teams to debug data inconsistencies and propose long-term solutions.
- Participate in designing and executing comprehensive test strategies including manual testing. This includes designing implementing and creating reports that are consumable by business stakeholders.
- Mentor QA team members on best practices for data validation automation and quality assurance.
- Collaborate with DevOps teams to integrate automated testing into the CI/CD pipeline.
Education Knowledge and Experience
- Bachelors degree in software engineering computer science or equivalent.
- 10 years of experience in quality assurance with a strong emphasis on data validation and backend testing.
- 4 years of experience in Python specifically for automation and data processing.
- Strong hands-on experience with SQL for querying and validating large datasets.
- Proficiency with Pandas for data manipulation and validation.
- Experience with JSON for structured data validation (XML is a plus).
- Experience testing software in Unix/Linux and Windows environments.
- Strong problem-solving analytical and debugging skills.
Ability to work independently while effectively collaborating with cross-functional teams.
Preferred Skills and Technologies:
- Databases: SQL Server PostgreSQL or equivalent.
- API Testing Tools: Postman SoapUI or similar.
- Bug Tracking Tools: JIRA
- Programming Languages: Python (mandatory) SQL (mandatory)
- CI/CD Tools: Jenkins GitLab CI/CD
- Web Technologies: HTML5 XML
- Source Code Repository Tools: GitHub
- Operating systems: Windows and UNIX/LINUX
- Pandas for data manipulation and validation.
- JSON for structured data validation.
- IDE Tools: PyCharm Visual Studio Code or any suitable IDE for Python.
- UI Testing: Experience with Playwright and JavaScript is good to have.
- Financial Markets Experience is nice to have.