Software Tester (SQL) (R1102662) in Orchard Park, NY at IQVIA™

Date Posted: 3/15/2020

Job Snapshot

Job Description

IQVIA™ is the leading human data science company focused on helping healthcare clients find unparalleled insights and better solutions for patients. Formed through the merger of IMS Health and Quintiles, IQVIA offers a broad range of solutions that harness the power of healthcare data, domain expertise, transformative technology, and advanced analytics to drive healthcare forward.


This is a data-focused Software Tester working in a fast paced Agile, team-based environment. Self-starter personality to learn our Product offerings, seek out answers to questions, and resolve problems. Team members are expected to collaborate and work closely together to deliver solutions that meet or exceed customer expectations, within set deadlines, while maintaining Quality standards. Testing strategies and methods will be based upon the team’s approach to development and may change based upon the assignment.

Understands how business work-flow will impact the testing of the underlying back-end data while ensuring that front-end results are correct. Possesses knowledge of different test techniques and practical experience in their proper application.

Understands database principles with experience in working with data for purposes of analysis, troubleshooting, and testing validation. Writes SQL statements to extract test data to perform validation on complex report calculations and that back-end data is correctly represented.

Essential duties and responsibilities:

Agile and Software Testing Teams Responsibilities:

  • Works in a team environment that includes collaborating with Product Managers, Stakeholders, Software Developers, and Software QA Engineers.
  • Participates in the team’s events and helps improve the Quality of the customer’s deliverables by identifying how the team can exceed customer’s expectations. This can include writing acceptance criteria, identifying questions on the requirements, and using estimation techniques. Understands customer impact and key Quality standards and business use cases.
  • Performs testing independently or in a team fashion with sharing of testing tasks across Testers as deemed necessary.
  • Identifies and performs system, regression, and integration testing required across user stories and requirements that can include code changes from other Agile teams. Communication across Agile teams is important in identifying potential external testing risks.
  • Produces appropriate testing artifacts for user stories, regression testing, and integration testing (i.e., test plans, Gherkin, diagrams and matrices).

Technical Testing Responsibilities:

  • Understands database relationships and writes basic SQL Queries. Ability to create or manipulate data to trigger desired test conditions.
  • Ability to analyze data to create test cases by identifying the correct testing techniques and sampling strategies to execute testing.
  • Understands how the business work-flow impacts the testing of the underlying back-end data while ensuring results are correctly represented.
  • Identifies and resolves different types of problems to efficiently target test strategies and testing scope. Works with team members on problems to identify risks and solutions.
  • Proactive in managing work tasks in relation to timelines and release deadlines. This can include alternative approaches to optimize testing time.
  • Follows all relevant Quality Management System (QMS) documents. Writes, updates, and trains on appropriate QMS documents.

Qualifications / Training:


  • Good communication, relationship-building, time-management and multitasking skills.
  • Good problem-solving skills in working through business work-flow and processes.
  • Ability to learn new software features to perform testing tasks within time constraints.
  • Basic understanding of relational databases.
  • Ability to work closely with co-workers including researching of problems and testing.
  • Job may occasionally require working outside of normal business hours including weekends to meet customer deliverables.


  • Experience working with different types of data sources and associated tools.
  • Experience using Oracle SQL Developer or similar tool to write SQL statements.
  • Acquainted with producing or altering sample data to trigger specific test conditions.
  • Working in an Agile framework or team-based environment (e.g. SCRUM, Kanban).



  • Associate Degree in Computer Science, Information Technology, or equivalent education/experience.
  • A minimum of 1 year of experience.


  • Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology.

Join Us

Making a positive impact on human health takes insight, curiosity, and intellectual courage. It takes brave minds, pushing the boundaries to transform healthcare. Regardless of your role, you will have the opportunity to play an important part in helping our clients drive healthcare forward and ultimately improve outcomes for patients.

Forge a career with greater purpose, make an impact, and never stop learning.

IQVIA is an EEO Employer - Minorities/Females/Protected Veterans/Disabled

IQVIA, Inc. provides reasonable accommodations for applicants with disabilities.  Applicants who require reasonable accommodation to submit an application for employment or otherwise participate in the application process should contact IQVIA’s Talent Acquisition team at to arrange for such an accommodation.

Job ID: R1102662