Sr. QA Automation / ETL Testing Engineer (Combination of QA Automation + Selenium + ETL Testing)
New York City, NY (Need Only local profiles from NJ/NY)
Exp: 10+ Years
Domain: Banking Required
Onsite: 3 Days a week from office from Day 1, No initial remote will be provided.
Job Description:
We are seeking a highly skilled Automation and Functional Testing Engineer to join our dynamic Quality Assurance team.
The ideal candidate will have substantial experience in automation testing using Playwright or Selenium with a strong background in ETL/database testing and a solid understanding of API testing.
The candidate will be responsible for building and maintaining test suites, executing end-to-end functional testing, performing data validation, and managing codebases and test scripts.
Key Responsibilities:
Automation Testing:
- Design, develop, and maintain robust test suites using Playwright/Selenium with Typescript/Java.
- Implement automation frameworks for testing applications and ensure high-quality deliverables.
- Collaborate with developers to integrate automated tests into the software development lifecycle.
Functional Testing:
- Execute end-to-end functional testing across multiple environments and platforms.
- Track and report test coverage, ensuring comprehensive validation from ETL processes to UI.
- Identify, document, and follow up on defects, ensuring timely resolution.
ETL/Database Testing:
- Conduct data validation and backend testing on SQL Server, MySQL, and NoSQL databases such as MongoDB and Cassandra.
- Perform automation on data pipeline testing to ensure the integrity of data moving from SQL to NoSQL databases.
- Collaborate with data engineers to validate ETL processes and data transformations.
Version Control:
- Manage the codebase and test scripts using Git, ensuring proper version control practices are followed.
- Collaborate with team members to maintain a clean and organized repository.
Test Management:
- Organize and manage test cases in QTest, ensuring alignment with project requirements.
- Integrate testing activities with CI/CD pipelines using Bitbucket and Bamboo.
API Testing:
- Conduct API testing using Postman and implement automation testing for APIs.
- Validate API responses and ensure functionality meets specifications.
Scrum and Agile Practices:
- Participate in Agile ceremonies, contributing to sprint planning, daily stand-ups, and retrospectives.
- Utilize JIRA for bug tracking and task management, ensuring timely delivery of quality products.
Tools:
- Utilize Confluence for documentation and knowledge sharing.
- Maintain and enhance test management processes using QTest.
Qualifications:
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Proven experience in automation testing with Playwright/Selenium (Typescript/Java).
- Strong programming skills in Python, Java, or similar languages.
- Experience in ETL/database testing and data validation across various database technologies.
- Familiarity with API testing tools and practices.
- Proficiency in version control systems, especially Git.
- Experience with test management tools such as QTest.
- Knowledge of Agile methodologies and experience using JIRA.
- Strong analytical skills and attention to detail.
- Excellent communication and teamwork skills.
Preferred Qualifications:
- Experience with cloud data storage solutions (e.g., cloud buckets).
- Familiarity with CI/CD tools like Bitbucket and Bamboo.
- Relevant certifications in testing or quality assurance (e.g., ISTQB).