Sr. QA Automation / ETL Testing Engineer

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