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