QA Analyst

Total Experience: 3 – 6 Years

Mandatory Skills: ETL Testing, DWS testing, SQL server

Job Description:

Key Tasks and Responsibilities

  • Understand the daily, monthly, and routine operations of various business units in order to identify areas of potential improvement and increased efficiency
  • Work with Business Units, Business Analysts, and Developers to define, document, and integrate business requirements
  • Provide Documentation to see that all enhancements, fixes, and new business requirements are fully documented
  • Identify and articulate inconsistencies between stated business requirements and the technical delivery of business requirements using test cases and test plans established by the Quality Analyst
  • Execute established test cases and plans
  • Accurately record and clearly document all actual results compared to expected results
  • Maintain well organized record of test results and generate historical analysis of test results
  • Fully document any unexpected anomalies identified in testing with instruction of how to recreate the anomaly
  • Work with Development team to ensure that n ew initiatives are fully tested.
  • Routinely report on the status of initiatives within the Quality Analyst’s assigned business unit
  • Create and update validation SQL queries
  • Validate dashboard metrics and reports using Microstrategy

Minimum Requirements

  • 3+ years of quality assurance experience
  • Proficient in Microsoft SQL
  • Microsoft Office Suite (Word, Excel, Outlook, PowerPoint)
  • Exposure to the mortgage industry
  • Excellent written and oral communication skills
  • Ability to manage multiple projects at once
  • Extreme attention to detail and ability to adhere to strict guidelines and procedures
  • Must be able to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary internal and external customer service
  • Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices

Desired Skills

  • Understanding of data warehouse structure
  • Experience working with ETL tools
  • Experience working with Microstrategy (or similar BI tool)
  • Experience working in JIRA (or similar Agile Management tool)