Skip to main content

Product Verification Analyst III (Extract Transform & Load)

Company: 
BCBSA
CIty: 
Chicago
State: 
Illinois
Employment type: 
Full time
Remote Position: 
No
Required degree level: 
Other

Overview

100% Remote - Full-Time Offsite for designated States

Responsible for developing and executing formal test plans to ensure the delivery of quality software applications. Involved in test planning, writing test cases/scripts, test case automation and test execution. Acts as an internal quality consultant to advise / influence business or technical partners. Develop test scenarios and scripts that accurately trace to business requirements through Requirements Traceability Matrix. Maintain an up-to-date test catalog based on department standard template. Responsible for developing test data strategy and validating test data prior to execution. Ensures test cases are reviewed and signed off by all stakeholders and peers prior to execution. Ensures exceptions to the above are documented and approve by PV management. Execute manual and automated test plans in an efficient manner. Create execution schedule with assigned resources prior to execution. Log defect tickets following the department standards. Ongoing interaction with peers, staff and customers in the Association, and vendor partners outside of the Association. Regular interaction with project team leaders and Project Manager. Work directly with manager in a lead capacity.

Responsibilities

Responsibilities include but are not limited to:

  • Design, write and edit a peer-reviewed, stakeholder signed-off test plan based on the department template. Participate in peer reviews of projects outside area of responsibility. Develop a PV project plan and ensure testing dates are accurately captured in overall Project Plan maintained by PM. Responsible for updating test execution estimates based upon metrics collected. Ensures exceptions to the above are documented and approve by PV management.
  • Create, review, and acquire decision on Automation Business Case. Based on approval, define requirements for automatable functionality. Engage with automation developers to complete scoped functionality. Responsible for UAT, adoption (based on successful UAT), and timely updating of automation, based upon upcoming application changes. Responsible for budgeting automation within the project. Responsible for providing an analysis of actual value vs. expected value from business case.
  • Responsible for providing daily status during test execution. Responsible for providing weekly status, on time, to all stakeholders. Responsible for providing weekly status, on time, for management dashboard. Responsible for researching customer issues and escalating risks/issues appropriately and in a timely manner. Test and investigate issues to determine the appropriate resolution.
  • Participates in test standards/templates and skill development. Acts professionally and fosters relationships with other groups. Serves as a coach and mentor to the department staff regarding how to develop and adopt department standards. Responsible for identifying/vocalizing areas for improvements, implementing process improvements and ensuring long term compliance. Contribute to the creation and maintenance of structured testing methodologies and processes for the PV department.
  • Responsible for attending PV team meetings and punctuality. Completes assigned responsibilities and is prepared for team meetings. Completes timesheets accurately and on-time



Qualifications

Required Basic Qualifications:

  • Bachelor's Degree in Computer Science, Information Systems or other related field, or equivalent work experience in similar work environment.
  • Minimum 7 years of IT work experience
  • Testing background and expertise with test tools (TSO, File-Aid, capture/playback, Mercury Interactive)
  • Extract Transform & Load (ETL) role specific experience:
    • Experience testing ETL in a dimensionally modeled data warehouse.
    • Experience testingETL with complex transformation rules and very large data sets.
    • Experience using tools associated with testing ETL jobs (e.g. Ab Initio)
    • Experience testing BI reports/dashboards; (e.g. Cognos & Tableau)
  • Experience leading project teams in a cross-functional environment preferred.
  • Strong analytical skills
  • Strong team-oriented interpersonal and communication skills to lead team efforts.
  • Ability to define approach to validating system functionality and quality delivery of all assigned projects and technical initiatives
  • Ability to develop/review testing strategies and test plans, including functional testing, regression testing, negative testing, deployment testing , job execution (Control-M) testing , and error handling testing.
  • Ability to reinforce team to follow QA Guidelines, QA methodology and Best Practices.
  • Ability to work with our business partners to understand the requirements.
  • Ability to work with the operations team to coordinate the build of the testing environment for the initiative.
  • Ability to track defects and report on testing progress and results.
  • BCBS or claims processing background preferred
  • ITS software knowledge preferred


Preferred Basic Qualifications:

  • Certification ISTQB, CSQE or CSQA preferred, professional test tool certification (HP, Atlassian, etc.)



Equal Opportunity Employer

Blue Cross Blue Shield Association is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, national origin, age, gender identity, disability, veteran status, genetic information or any other legally protected characteristics.

Make an impact on healthcare in America. A career with Blue Cross Blue Shield Association allows you to be part of the foundation that supports the 35 Blue Cross and Blue Shield companies nationwide, while protecting and strengthening the Blue Cross Blue Shield brand. Our work is helping provide greater access to cost-effective healthcare, improve the health of America and build stronger communities. With a commitment to diversity, equity and inclusion, we celebrate different cultures, languages, backgrounds and experiences while striving to advance health equity, and we want you to join Team BCBSA.

Accommodations:
Vision Accommodations, Hearing Accommodations, Neurodiversity, Learning, Mental Health, Mobility