Quality Assurance Analyst

Turnberry Solutions; Lower Providence Township (PA); Hybrid; USD 85,000 - 125,000; Full time

Benefits offered by this job

Healthcare package

Disability insurance

401(k) with match

Flexible time off

Parental leave

Flexible work arrangements

Job summary

Turnberry Solutions, Inc. is seeking a Quality Assurance Analyst to join the Digital Modernization practice in Pennsylvania.

You will lead testing efforts across component to acceptance levels, collaborating with developers, PMs, and business customers to ensure comprehensive test coverage and data-driven validation. You will design, implement, and execute tests, including database changes, data migration, and UAT support.

Qualifications

• 7+ years of QA analyst or tester experience.
• Strong customer and business focus.
• Experience with user-centered design and usability testing.
• Experience with Atlassian toolset (Jira and Confluence).
• Understanding of Oracle database and ability to write SQL queries.
• Experience with test driven or behavior driven development practices.
• Experience with Salesforce.
• Hands-on testing of complex technical applications.
• Experience in communicating with business leadership and stakeholders.

Responsibilities

• Define the overall strategic and tactical objectives for testing software changes at different test levels.
• Work with developers, PMs, and business customers to define the testing strategy (e.g., risk-based testing).
• Test levels include component, integration, system, and acceptance testing; test types include functional and non-functional testing, white-box testing, regression testing.
• Develop and execute test procedures, set up test environments and data, and test database components (views, procedures, functions, data migration).
• Support acceptance testing by identifying database model changes across environments.
• Assess test execution against objectives and define team-level deliverables.
• Extract production data subsets for test cases and data-driven testing.
• Script data setup and data files with timestamp-related variables for testing.
• Ensure compliance with client testing standards and policies.
• Provide tools to compare expected vs actual test results and ensure data integrity.

Skills

QA experience

Customer focus

Communication skills

User-centered design

Agile Scrum

SQL

TDD/BDD

Team collaboration

Scripting

Salesforce

Tools

Jira

Confluence

Oracle

SOAPUI

TOSCA

Scriptless Automation

Job description

Duration: 24+ Months

Location: PA-Audubon, Hybrid 1-2 days onsite

Overview: Every Turnberry consultant belongs to a practice, an internal group of consultants and leaders with shared experience and expertise. Each of these practices aligns to one of the core services Turnberry offers to clients. As a Quality Assurance Analyst, you will join Turnberry's Digital Modernization practice, where technology and strategy combine to deliver exceptional digital experiences, empowering organizations to thrive in today's digital market.

Responsibilities

• Test Planning:
  • Define the overall strategic and tactical objectives for testing software changes at different test levels
  • Work with developers, project managers, and business customers to define the strategy to be used, such as risk-based testing
  • Test levels include component testing, integration testing, system testing, and acceptance testing
  • Test types include functional testing, non-functional testing, structural ("white-box") testing, confirmation testing, and regression testing
• Test Monitoring and Control:
  • Continuously compare test progress with the plan, adjust the plan, test activities as necessary, and provide status reports
• Test Analysis and Design:
  • Transform testing objectives into test conditions and test cases
  • Test basis includes documented requirements, system architecture, behavior and structure of the software, existing data and data flows. Using structural ("white-box") test techniques, among others, design tests, or provide input into test design by identifying specific test conditions and high-level test cases
• Test Implementation and Test Execution:
  • Develop and prioritize test procedures, set up the test environment and test data, and execute tests
  • Test changes to the database components of the system under test
  • Testable components include views, procedures and functions, data conversion, and migration programs
  • Support business customers and others in acceptance testing, which includes identifying database model changes in higher environments (Production and Stage), and making those changes in the lower environments (Test and Development)
• Evaluating Exit Criteria and Reporting and Test Closure:
  • Assess test execution against the objectives defined in the test plan, specific tasks and deliverables are defined at the team or project level
• Subset Production Data:
  • Extract subsets of production data from multiple sources to meet test cases and/or to supply input values for data-driven testing
  • Create realistic test data sets small enough to support rapid test runs but large enough to accurately reflect the variety of production data
• Provide Test Data Management.
  • Script the setup of data in the application database to put it in a state that allows a specific set of test cases to be run against it
  • Script the creation of data files and message streams which require changing variables (usually date or timestamp related) in order to test applications which process them
  • Script database cleanups
• Ensure compliance with client Software Testing standards and policies
• Identify the necessary test data to support test conditions and test cases as they are defined which includes data to force error and boundary conditions
• Analyze input data, including electronic files, message traffic, and variations of user input
• Provide expected test results, and/or repeatable methods of generating expected test results, based on currently existing data which includes preparing database queries and guides for testers to use
• Provide tools and methods to compare expected and actual test result which inncludes bi-directional comparisons of database data with electronic files, message streams, and front-end displays
• Provide high-quality, realistic, fit for purpose and referentially intact test data
• Capture end-to-end business processes and the associated data for testing

Qualifications

• 7+ years of experience as a quality assurance analyst or tester
• Strong customer and business focus
• Strong communication skills
• Experience with user-centered design and usability testing
• Experience with (Atlassian toolset) and Confluence
• Understanding of Oracle database and and able to write SQL queries
• Experience with test driven or behavior driven development practices
• Energetic and passionate about work, extremely positive, and solution driven
• Previously worked on large teams, on projects that have different business owners
• Experience using iterative development methodologies, specifically Agile Scrum
• Scripting experience using applicable languages
• Salesforce experience required
• Experience using automated testing tools – SOAPUI, TOSCA, Scriptless Automation
• Experience hands-on testing complex technical applications
• Experience in communicating with Business Leadership and stakeholders

The salary range for this role is $85,000 to $125,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, a utilization bonus, 401(k) with match, flexible time off for salaried employees, parental leave for salaried employees, and flexible work arrangements (all benefits