QA Analyst

We are hiring for Senior QA Analyst role.

You will perform manual Quality Assurance Testing activities to ensure software quality and data integrity on in-house as well as third-party applications on a long term consulting bases starting in September 2025.

Extensive manual testing experience in the financial services/banking; strong in SQL Server; data migration testing experience with data in JSON format and XML format; and Python/Pandas test automation experience.

This is a hybrid role that requires being onsite 4 days per week in New York City so you should be a local NYC candidate able to commute into midtown.

Working in a small, tight knit IT Applications Development Team, you will participate in SDLC, implementing QA methodologies within a small testing team to achieve efficient software development.

In Summary, You will:

• Analyze requirement documents such as BRD, FSD, TDD and Data Mapping for completeness, consistency and testability
• Plan the Testing Approach and design Test Cases, Test Steps; identifying the Testing Scope and designing Functional (GUI), Non-functional (SQL, ETL) and Roles/Permissions Security test cases, Prepare the QA Test Environment, including but not limited to activities such as database restore/backup and deployment of application builds such as executable files, database objects and configurations files.
• Execute the Test Cases, Retesting and Regression Testing
• Documenting and maintaining QA artifacts such as Test Cases, Test Queries, Test Data and Test Evidence.
• Ensuring Requirement Coverage by creating linkages between test cases and requirements.
• Convert Business and Functional Requirements into Test Scenarios and Test Cases, designing test plans, scenarios, scripts and procedures based on business requirement and functional specifications
• Convert Roles/Permissions Matrix and Business Process Workflows into Test Cases
• Create and execute test cases manually
• Document software defects and report defects to developers and project managers
• Identify, analyze and document problems with program function, output, screen, or content
• Create effective Bug Reports, communicate and ensure bugs get fixed in a timely manner
• Plan test schedules or strategies in accordance with project scope or delivery dates
• Participate in product design reviews providing input on functional requirements, production design schedules or potential problems
• Review software documentation to ensure technically accuracy, compliance, or completeness and to mitigate risks
• Analyze extensive data, identify discrepancies and inconsistencies and recommend a course of corrective action
• Convert Data Mapping Document into SQL Queries to validate data transformations from source to target during ETL (Extract Transform Load) process
• Collaborate with Developers, participate in defect triage calls and system integration testing

Requirements Include

• 5 years of experience performing both functional and non-functional testing tasks.
• Financial Services / Banking industry QA experience
• Good experience with SQL Server and AWS
• Working knowledge in ALM/QC Team Collaboration Tool
• Strong knowledge of Software Development and Testing Life Cycles (SDLC, STLC).
• Knowledge and experience with Application development QA for: Python/Pandas Test Automation, Angular, SQL Server, JavaScript, JSON, XML
• Experienced in SQL Server Management Studio, hands-on experience in Testing SQL Tables, Views, Stored Procedures view and trigger development
• Experience in testing File Processing, FTP, SFTP
• Experience in testing scheduled jobs, batch files
• Experience converting Business and Functional Requirements into Test Scenarios and Test Cases; converting Roles/Permissions Matrix and Business Process Workflows into Test Cases; converting Data Mapping Document into SQL Queries to validate data transformations from source to target during ETL (Extract Transform Load) process.
• Ability to convert Data Mapping document into ETL/SQL Test Queries to validate data integrity
• Experience in both sequential (Waterfall) and iterative (Agile) project management methodologies.
• Completed Bachelor's degree in with Computer Science or related course of study