Quality Assurance Analyst (SQL)

POSITION DESCRIPTION:

- Develop test strategies, test plans, and test cases for web site verification.
- Develop test scripts and test software, for iterative and incremental software development efforts.
- Document test results and provide test progress/reports that will be used in assessing the completeness of the development effort.
- Work closely with the development team to ensure all relevant and agreed upon aspects of the application are tested.
- Provide scope, resource and time estimates for projects presented for testing and analysis.
- Identify and manage issues/defects for each development project.
- Make available test status and progress reports to the project team.

QUALIFICATIONS:

- SQL SKILLS. ABILITY TO WRITE COMPLEX SQL SELECT AND UPDATE STATEMENTS, involving multiple related tables.
- This includes comfort with grouping, CTEs, parameters, Except clause, Union clause, as examples.
- NON-UI TEST AUTOMATION SKILLS.
- Ability to conceive and design API-LAYER AUTOMATED TESTS (ie, below the presentation layer).
- This would include fundamental programming or Scripting skills.
- Preferably C#. Business domain knowledge.
- Capable of asking good questions and quickly learning the research side of the linear broadcast business.
- Database knowledge, preferably Microsoft. Understands the difference between data warehouses and transactional data bases. Understands how stored procedures, views, and ETLs work.
- Data analysis skills.
- Ability to inspect data with the goal of data cleaning and quality checking.
- Scrum development methodology experience. Examples: Understands velocity, sprint planning, story point estimation, and the Agile manifesto.
- Excellent verbal and written communication skills.
- Critical thinking skills.