CVS Health Advisor, Quality Assurance (EDW PBM) in Richardson, Texas

Job Description

The Advisor, Quality Assurance (EDW PBM) will be responsible for: Excellent Verbal and Written communication skills. Provides expert Advisory input during requirements and design phases that assist in developing business solutions. Expert knowledge and hands on experience with Teradata SQL14.0 assistant. Expert and hands on knowledge of Informatica Power Center 9.5 and 9.6's client tools such as designer, workflow manager, workflow monitor, SQL query tool. Provides technical analysis against business requirements that ensure delivery of a quality solution. Creates or advises others on testing strategies. Instruct others to develop SME knowledge. Utilize automated testing tools. Employ quality processes such as defect issue reporting, SDLC/ISO 9000/CMMI. Establish and ensure adherence to quality assurance testing process, standards, guidelines and methodologies. Perform complex data profiling techniques using Informatica Analyst 9.6 and Informatica Developer 9.6.1. Maintaining / enhancing / debugging EDW regression and automation components in CA Lisa Dev/Test Workstation ver 9.0. Well versed with understanding of java, classes, object oriented programming, debugging and enhancing existing code scripts using Eclipse 4.4. Create automation scripts in Basic Teradata Query {BTEQ) and assist other employees to in using scripts against Source to Target Mapping (STTM) and Informatica. Demonstrate a mastery in multiple application area(s) and a thorough understanding of platforms/applications or software product used by a PBM, with knowledge of two (2) or more functionalities such as Eligibility, Adjudication, Drug Pricing, etc. Working knowledge of Serena Dimension ver 12.2. l or higher. Working knowledge of Micro Focus Serena Business Manager. Expert in testing Infoworks 2.2.0, HIVE 14.0 and Oracle Log Miner. Well versed in testing data ingestion jobs, pipelines, cubes, debugging and validating Microstrategy reports. Will be required to work weekends every other month and as needed.

Required Qualifications

A Master's degree or foreign equivalent in Engineering, Computer Science, IS, or closely related technical field and 3 years of experience in data and functional QA testing in a large scale data warehousing environment, including 3 years of experience with overseeing testing aspects of a technical project; using BTEQ or SQL scripting; testing Enterprise data warehouse applications; and writing test plans, test cases, and test strategies required. Will accept a Bachelor's degree and 6 years of experience in lieu of a Master's degree and 3 years of experience. Must apply by 09/16/18.

Preferred Qualifications

Please see required qualifications


A Master's degree or foreign equivalent in Engineering, Computer Science, IS, or closely related technical field and 3 years of experience in data and functional QA testing in a large scale data warehousing environment. Caremark, LLC will accept a Bachelor's degree and 6 years of experience

Business Overview

CVS Health, through our unmatched breadth of service offerings, is transforming the delivery of health care services in the U.S. We are an innovative, fast-growing company guided by values that focus on teamwork, integrity and respect for our colleagues and customers. What are we looking for in our colleagues? We seek fresh ideas, new perspectives, a diversity of experiences, and a dedication to service that will help us better meet the needs of the many people and businesses that rely on us each day. As the nation’s largest pharmacy health care provider, we offer a wide range of exciting and fulfilling career opportunities across our three business units – MinuteClinic, pharmacy benefit management (PBM) and retail pharmacy. Our energetic and service-oriented colleagues work hard every day to make a positive difference in the lives of our customers.

CVS Health is an equal opportunity employer. We do not discriminate in hiring or employment against any individual on the basis of race, ethnicity, ancestry, color, religion, sex/gender (including pregnancy), national origin, sexual orientation, gender identity or expression, physical or mental disability, medical condition, age, veteran status, military status, marital status, genetic information, citizenship status, unemployment status, political affiliation, or on any other basis or characteristic prohibited by applicable federal, state or local law. CVS Health will consider qualified job candidates with criminal histories in a manner consistent with federal, state and local laws. CVS Health will not discharge or in any other manner discriminate against any Colleague or applicant for employment because such Colleague or applicant has inquired about, discussed, or disclosed the compensation of the Colleague or applicant or another Colleague or applicant. Furthermore, we comply with the laws and regulations set forth in the following EEO is the Law Poster: EEO IS THE LAW at and EEO IS THE LAW SUPPLEMENT at

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. If you require assistance to apply for this job, please contact us by clicking Advice and Counsel at mailto:Advice&

CVS Health does not require nor expect that applicants disclose their compensation history during the application, interview, and hiring process.

For inquiries related to the application process or technical issues please contact the Kenexa Helpdesk at 1-855-338-5609. For technical issues with the Virtual Job Tryout assessment, contact the Shaker Help Desk at 1-877-987-5352. Please note that we only accept resumes via our corporate website: