At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.Position Summary
As a QA SQL Engineer, this person will provide testing support for the 340B applications (Web, Windows and Database) by understanding QA Database testing goals and contributes towards deliverables. Day to day activities for the job is to define testing strategies, perform test planning and executing unit, system, integration and regression tests of Backend applications, ETL/Data Integration and Datawarehouse solutions. This person will be responsible for implementing defined QA procedures to plan, design, implement, execute, evaluate, report results of software testing, and to avoid the release of defects (e.g., requirements review) under minimal supervision for projects of all scopes. Additionally, obtaining, maintaining, and documenting (application) system domain knowledge is necessary to perform defined QA procedures efficiently and effectively. In this role, you will need to be accountable for projects of high complexity, high risk, and high visibility; handle multiple projects of varied complexity simultaneously; provide feedback on and suggestions for improving QA Procedures to Project Leads and Technical Leads. You will be working with QA team, project managers, business analysts and application developers, to quickly capture the major business functions and technology underpinnings to be able to design and implement tests of system functionality that exercise all critical inter-system integration points.
Want more jobs like this?
Get jobs in Harrisburg, PA delivered to your inbox every week.
Additionally, You could also be asked to assist Project Leads building and maintaining the test environment and regression test bed, along with maintaining flexibility in testing with minimal, incomplete or missing requirements, and the performance of non-management QA and testing tasks, throughout the SDLC (i.e., from pre-project initiation through post-project review and monitoring).Required Qualifications
5 + years of experience in role executing all phases of the software development lifecyle, QA processes, and metrics.
• 5+ years of experience in a testing Database, EDI/ETL, DW Automation & Test Management Tools.
• 5+ years of Advance SQL Querying using SSMS
• 5+ years of experience with SSIS, SSRS, SQL Agent jobs.
Preferred Qualifications
- 5+ years of advanced SQL skills.
- Understanding of SSIS, SSRS and SQL Agent jobs, Profiling, Azure, and/or redgate tool experience.
- Understanding of stored procedures.
- EDI/ETL, DW testing experience using Querysurge, Tosca DI.
- BA degree in related field preferred
Education
Bachelor's Degree in related field or HS GED with 5 yrs of experience. Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:$92,700.00 - $185,400.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.Great benefits for great peopleWe take pride in our comprehensive and competitive mix of pay and benefits - investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:
- Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
- No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
- Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.