Your Role
The Data Services Quality Engineering team is part of the BSC Data & Analytics Organization. We provide testing services for Data & Analytics projects. The data is sourced from various internal and external applications and loaded to the consumption layer. The Quality Engineer, Senior, will report to the IT Manager. In this role you will be working with Data & Analytics, Data Engineering, Data Analysis, Application, and Business teams.
Your Work
In this role, you will:
Develop test scenarios and underlying test scripts (Functional and SIT) based on provided requirements/design documentation and business inputAttend requirement sessions and evaluates requirements for testabilityCreate traceability from development hand off through testingParticipate in design sessions to understand implications of design to testingProvide test estimates for large initiatives as requested under the guidance of testing leadershipReview Business Requirement Document (BRD), Technical Design Document (TDD), Data Model, Source-to-target mapping document (STTM)Prepare Test Plans, Test Scenarios, Test Data, Test Cases, Test Scripts based on BRD, TDD, STTMReview test artifacts with business users and technical teamMaintain test cases in test management system and track defects in JIRAConduct daily defect calls with IT PM, Development team and Business teamProvide test reports/status to Test Lead, IT PM and discuss roadblocks if necessaryPerform root-cause analysis for the defects/issues and provide solution if requiredFollow best practices and maintain quality assurance standardsWork closely with cross-functional counterparts in business, development, release and project managementHave proficiency working in Agile methodologyProvide overall technical leadership across multiple projects simultaneouslyHave thorough understanding of automation frameworks and ability to design, develop and maintain automation frameworkExecute and maintain test scripts in the automation framework for regression and smoke testing of various BSC applicationsHave the ability at applying advanced professional principles and concepts to complex work assignmentsParticipate and present in automation code reviewsAssess suitability of manual test cases for automation
Your Knowledge and Experience
Requires a bachelor's degree, preferably in Computer Science, or equivalent experience and a minimum of 5 years of prior relevant experience5 years of Quality Engineering experience, with 4 years of experience in Data Warehousing preferredPrefers at least 1 year of experience in Cloud Data Platform Testing with Azure Data Lake Storage (ADLS) Gen2 and data pipeline development using DBT Cloud/Core tool on Snowflake DBKnowledge of ETL processes, Relational Database Design Methods (Snowflake/Star Schema), Slowly Changing Dimensions etc.Ability to analyze error logs in UNIX, update shell scripts, and create SQL scriptsAbility to perform automated regression testing in all non-production environmentsExcellent written and oral communication skillsHealthcare domain experience is preferable but not requiredPreferred experience working on at least one large data warehouse project/initiativeHands-on experience in using Informatica or similar ETL toolAnalyzing and writing testing cases based on ETL specifications/ Source-to-Target Mapping documentsKnowledge of data & analytics in cloudDemonstrate a mindset of continuous improvement in process/technology etc.Experience with coding in python or any other object-oriented programming language is preferred
Pay Range
The pay range for this role is: $ 99000.00 to $ 148500.00 for California.
Note
Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.
#LI-EB1