Quality Assurance Analyst

National Cooperative Bank - Arlington, VA4.0

Full-time
Save

The QA Analyst will gather and analyze data in support of business cases, proposed projects and system requirements. The QA Analyst is responsible for working and engaging with PMs, Dev Team, OPS team and other key stakeholders in the use and delivery of data and applications. This includes writing test plans, tracking defects and fixes for product development, software application development, information systems and operations systems in Azure DevOps. They are responsible for testing EDW, EDWMart related extraction, transformation and load functions. They will apply proven analytical and problem-solving skills to help validate IT processes through testing in order to maximize the benefit of business investments in IT initiatives and assure integrity of systems operations and data delivery.

Documentation Management

  • Verify all related documents such as STTMs (Source to Target Mapping), Functional Requirement, Business Requirement, Technical Requirement, and Code Review document of the project to be tested are included and clearly defined.
  • Build Quality Assurance document for testing as needed or capture in Azure DevOps – Test Plan where applicable.
  • Specify project information and the environments where testing will be done in DevOps- Test Plan.
  • Build Test plan based on the requirements of the project in DevOps – Test Plan.
  • Prepare test script. List all the steps of the test executions in Test Script.
  • Catalogs test scripts for future reference
  • Deliver projects for user testing as scheduled; Implement projects according to the release schedule.
  • Verify and revise quality assurance standards as needed and required by applicable regulation.
  • Coordinate and work with other technical staff to develop coding standards and Quality Assurance policies and procedures. 30 %

Quality Management

  • Perform QA test following the test scripts, based on the requirements
  • Maintain change control and testing processes for modifications to all processes
  • Assures the overall viability, functionality and effectiveness of applications and IT infrastructures.
  • Ability to read, analyze and digest business requirements and review ETL routines to test their accuracy
  • Analyze test results in order to discover and report any defects, bugs, errors, configuration issues via email and logging it in Azure DevOps.
  • Help identify data quality issues and work with appropriate teams to address
  • Document test results and comments clearly.
  • Communicate test progress, test results, and other relevant information to QA manager and project manager.
  • Test any new modifications to allow applications to meet business requirements, systems goals, fulfill end-user requirements, and identify existing or potential issues.
  • Monitor user testing carefully and review UAT test results.
  • Emergency Request and Data Change Requests – Create QA document including required Environment, Test link, Functional Requirement, Test plan, Test scripts, Test Results, and Pass/Fail criteria. Test the Change request and document the test results and sign off for user testing. 55%

Process Management

  • Implements ongoing quality improvement processes working with interdepartmental teams.
  • Maintains product consistency throughout product cycle, to include the design, define and build phases through quality checkpoints and testing.
  • Manage Workload – Monitor progress of projects and change requests in daily basis. Prioritize each of them according to its requirement and handle them correspondingly. 15%

Qualifications Include:

  • Strong understanding of different software development life cycles and contemporary software quality assurance processes and automated tools.

2. Strong hands-on experience in SQL
3. Execute the technical testing strategy and tactical plan for perfoming Quality Assurance functions for the Enterprise Data Warehouse Platform.
4. Collaborate in the conceptualization, analysis, development, and deployment strategies for data storage, ETL, and reporting at the enterprise level with minimal supervision. Responsible for the accurate documentation of business terms, reporting needs, calculations, and any appropriate metadata; using available tools
5. Ensure that established standards, quality requirements & best practices are followed in all development efforts.
6. Identify, develop and document detailed business requirements and detailed specifications through the Data Warehouse life cycle integrating with existing data warehouse environment.
7. Strong understanding of relational database structures, theories, principles, and practices
8. Experience working with complex, large-scale relational databases, statistical programs and other tools to compile and interpret quantitative data
9. Knowledge of data integration and database data modeling tools, computer networks and operating systems including DataStage, ERwin,.MS Windows
10. Extensive experience with core software applications and DBMS, including MS SQL server, JAVA, MS Word, Excel, PowerPoint, Project and Access, .NET, Azure DevOps
11. Strong analytical skills and experience with implementation and administration of Quality Assurance metrics, such as defect profiles and performance criteria.
12. Excellent problem solving and organization skills.
13. Able to prioritize and execute tasks in a high-pressure environment.
14. Knowledge of applicable data privacy practices and laws.
15. Excellent written and oral communication skills, interpersonal communication, listening, presentation and project management skills.
16. Strong leadership skills that inspire team confidence and respect while motivating team members in a creative and effective manner.
17. Must have a desire for achieving excellence in customer satisfaction, process and product quality and reliability

Working knowledge and experience with testing within a SharePoint environment.

Load test cases, track, prioritize, assign and report on defects and resolution status in SharePoint.

Execute functional, regression and performance testing on SharePoint applications environment.

Perform knowledge transfer to Operational staff

  • Microsoft Windows 7 & 10 Operating Systems.

2. Microsoft Office Suite (5 years).
3. Azure DevOps (1 year).
4. IBM DataStage 8.1 or higher (2 years).
5. Data warehouse gathering, understanding, and documenting business reporting requirements for complex data warehouse solutions (3 years)
6. Highly skilled in SQL programming, stored procedures, and scripting. Experience with Oracle, DB2, Teradata, SQL Server databases.
7. Exposure or knowledge using InfoSphere products including: Information Data Architect, DataStage, QualityStage, Business Glossary, Information Analyzer, Metadata Workbench, Information Services Director
8. Ability to partner and build relationships with Senior Management, and communicate to multiple audiences
9. Proactive, great attention to detail, results-oriented problem solver
10. Ability to deal with long term goals along with immediate performance concerns
11. Strong communication skills and the ability to translate highly complex technical issues to non-technical audience
12. Experience with leading BI tools such as MicroStrategy, Cognos, Tableau, Business Objects, Crystal Reports, Power BI or others desired.
13. Hands on experience using and testing SharePoint Online or SharePoint 20xx, O365 as Record Management platform

EOE/AA

Job Type: Full-time

Experience:

  • Relevant: 1 year (Preferred)
  • Quality Assurance: 1 year (Preferred)