QA & Testing Senior Analyst - HIH - Evernorth

Section 2: Position OverviewProvide a concise summary of the position, its purpose, and its importance within the company. Section 1: Job TitleClearly state the position's title to convey the role and level of responsibility.QA & Testing Senior Analyst Position OverviewThe position is responsible for ensuring the quality and reliability of Data & Analytics applications and Financial/Oracle ERP applications under Evernorth's Finance IT / DPaAS department. This includes developing and executing test scenarios and scripts, analyzing business requirements, tracking defects, and collaborating with various teams and stakeholders. The role is crucial in ensuring that the applications meet the company's standards and effectively support its financial operations. Section 3: ResponsibilitiesClearly outline the primary duties and tasks associated with the role. Use action verbs (i.e., lead, drive, analyze, assess, research, etc.) to convey expectations.Responsibilities< >Develop ETL test scenarios & test scripts based on source to target mapping documentation and perform ETL testing on different data warehouse systems both on-premises and on AWS cloud.Perform business requirement analysis, develop system & integration test design, test execution, defect logging, reporting, and tracking.Test plan & Test case design with SQL queries based on technical design and mapping documentsExecute queries to verify the data transformations Run ETL jobs and monitor jobs to ensure data is extracted, transformed and loaded according to predefined systems. < >Understand how changes impact work upstream and downstream including various back end and front-end architectural modules.Interact with both onsite and offshore team members.Perform in multi-vendor projects along with Business leads, IT leads, QA Leads and other stakeholders.Define test data conditions and work closely with Data team & related application partners to prepare the data.Actively participate and manage with business leads to get the testing complete in all phases of testing (System, integration testing and UAT)Work with JIRA and Zephyr test tracking tools.Develop and generate status reports using test tracking tools.Develop and execute comprehensive suites of automation test plans, test cases for inclusion in regression, automation for newly integrated features to augment QA testing.Adheres to the organization's Quality Engineering best practices while helping to drive changes to our testing practices where necessary. Section 4: QualificationsSpecify the skills, experience, and education required for the role. Differentiate between the "must-haves" and "nice-to-haves". Required skills: List the specific skills required for the job, including technical, leadership skills, and any industry-specific skills.Required Experience: Clearly state any mandatory requirements, such as formal education, certifications, licenses, or specific years of experience.Desired Experience: List any "nice-to-have" experience, including industry experience, exposure to specific technologies, certifications, etc. QualificationsRequired Skills:< >Leadership skills to take the initiatives and guide the team members. Excellent written and verbal communication skills Solid analytical skills, highly organized, self-motivated and a quick learner Flexible and willing to accept change in priorities as necessary.  Required Experience & Education: < >Bachelor's degree in computer science or a related discipline, typically eight or more years of solid, diverse work experience in IT with 6+ years of experience in Quality Assurance with automation experience preferred.Experience in Designing and developing scripts to run automated tests to ensure consistency, repeatability and accelerates delivery. Experience in understanding application architecture for cloud-based applications.Good Experience in database & data warehouse testing with experience working with dimensional models.Experience working with dimensional models, good knowledge of Relational databases, SQL, PL/SQL, and experience in Tableau reports/dashboards.Proficiency in SQL and ability to develop complex SQL scripts.  Desired Experience:  < >Healthcare domain knowledge Oracle Financials (ERP) knowledge   These two sections will be "standardized" in the JD template and made not editable.Location & Hours of Work(Specify whether the position is remote, hybrid, in-office and where the role is located as well as the required hours of work)About Evernorth Health Services Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.