Evernorth Health Services
Healthcare
QA&TestingSeniorAnalyst
Neural analysis suggests this role is
optimal for Senior candidates.
“QA & Testing Senior Analyst at Evernorth Health Services. Skills: ETL Testing, SQL, Data Warehousing, Agile. Design test cases for ETL processes. Execute test cases for ETL processes”
Industry & Context.
Innovative problem-solving ability; Defect identification; Defect isolation; Troubleshooting
Flexible with timings
What They're Looking For.
Must Have
3 years of relevant experience, 3-5 Yrs. experience in Software QA & ETL Testing, Good understanding of Healthcare Domain, Good knowledge of SDLC and STLC, Expertise of Software Testing, Understanding of ETL processes, Understanding of data warehousing, Experience working with large data sets, Writing complex SQL queries, Testing experiences in DB systems, Experience in running ETL jobs, Experience in monitoring ETL jobs, Experience in debugging ETL jobs, Experience with test case design, Experience with test case execution, Understanding of data models, Understanding of data mapping documents, Understanding of ETL design, Understanding of ETL coding, Experience within Agile development environment, Understanding of BI concepts, Experience in OBIEE reporting, Broad knowledge of automated testing tools, Broad knowledge of modelling tools, Knowledge of building automation tools, Knowledge of deployment tools, Excellent analytical skills, Innovative problem-solving ability, Good communication skills, Very good team player, Flexible with timings
Nice to Have
Kubernetes experience a plus
What You'll Do.
Design test cases for ETL processes
Execute test cases for ETL processes
Design test cases for data integration
Execute test cases for data integration
Validate accuracy of data
Validate completeness of data
Develop SQL to validate data
Check for null values
Check for truncated values
Ensure correct data aggregations
Run Jobs using IBM DataStage
Execute test cases through Zephyr
Validate data in Target database
Identify defects in ETL processes
Isolate defects in ETL processes
Report defects in ETL processes
Identify issues in ETL processes
Isolate issues in ETL processes
Report issues in ETL processes
Develop test data for ETL testing
Maintain test data for ETL testing
Run GITHUB commands for Automation
Validate data in OBIEE dashboards
Validate data in OBIEE reports
Identify data quality issues in Source data
Collaborate with development team
Improve ETL processes
Participate in design of automated testing tools
Participate in implementation of automated testing tools
Participate in design of automated testing frameworks
Participate in implementation of automated testing frameworks
Actively participate in Status reporting
Actively participate in Agile meetings
Document test results
Communicate with stakeholders on status
Track defects in applications
Report defects in applications
How You'll Work.
Team & Collaboration
Collaborate with development team; Agile meetings; Communicate with stakeholders
Communication Scope
Status reporting; Communicate with stakeholders
Process & Methodology
Agile development environment, Sprint planning, Sprint demos, Sprint retrospectives, Sprint ceremonies
Full Job Description
**_Position Overview_** We are seeking a highly motivated and experienced ETL Tester to join our team and play a crucial role in ensuring the quality and reliability of our data platform and pipelines. You will be responsible for leading the development and implementation of an automated testing framework specifically designed for validating the Extract, Transform, Load (ETL) processes. **_Responsibilities_** * Design and execute test cases for ETL processes and data integration * Validate the accuracy and completeness of data being loaded into the target systems * Develop SQL to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations. * Run the Jobs using IBM DataStage for ETL Process. * Execute test cases through Zephyr. * Validate data in Target database according to mapping and business rules. * Identify, isolate, and report defects and issues in the ETL processes * Develop and maintain test data for ETL testing * Run GITHUB commands for Automation. * Validate data in OBIEE dashboards and reports against Database. * Identify data quality issues in Source data * Collaborate with the development team to resolve defects and improve the ETL processes * Participate in the design and implementation of automated testing tools and frameworks * Actively participate in Status reporting and Agile meetings. * Document test results and communicate with stakeholders on the status of ETL testing. * Track and report the defects in applications like JIRA and Zephyr. **_Qualifications_** **Required Skills:** * Good understanding of Healthcare Domain. * Good knowledge of SDLC and STLC with specific expertise of Software Testing. * Strong understanding of ETL processes and data warehousing * Experience working with large data sets and writing complex SQL queries * Testing experiences in DB systems like Oracle, SQL server * Experience in Toad for Oracle and DB2 Applications * Experience in running ETL jobs, monitoring and d
Applying for this QA & Testing Senior Analyst role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Workday
- Workday has a multi-step form — save your progress after every section.
- "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
- Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
- Job requisition numbers are useful when following up with HR by email.
ANONYMOUS · UNFILTERED
What do employees actually say about Evernorth Health Services?
Real rants from real employees. Read before you apply.