QA Analyst
1251 Avenue of the Americas New York, NY 10017 US
Job Description
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 May 2025.
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.
This is a hybrid role that requires being onsite 2 days per week in New York City.
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
- 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, Angular, SQL Server, Javascript, HTML, XML, database design, SQL Server stored procedures, view and trigger development
- Experienced in SQL Server Management Studio, hands-on experience in Testing SQL Tables, Views, Stored Procedures and Functions
- 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