QA & Testing Analyst ETL TesterBand 2About Cigna: Cigna exists to improve lives.  Together, with our 74, 000 employees worldwide that service Cigna, Express Scripts and other affiliate customers, we aspire to transform health services, making them more affordable and accessible to millions.

We are going through an exciting period of expansion; at the centre of our International division’s ambitious growth strategy we are currently working towards multi-year effort to implement a consistent digital strategy for the International Market.

The Position: Reporting to the QA Manager , the successful candidate will be responsible for on time delivery of test planning and executions activities in the delivery of Quality Assurance (QA) Testing for new or modified applications/systems across multiple platforms.  The QA & Testing Analyst will be a high-performing individual who is methodical, inquisitive and has a passion for quality.  They will partner with their Scrum Team and business colleagues on a journey of continuous learning and improvement to ensure ongoing optimisation of quality first delivery capability in support of key strategic outcomes for our business.

Working across our IM IT Team to deliver successful QA & Testing solutions enabling all methodologies but with a focus on SAFe Agile.  You will work with individuals from across the world, with both in-person and remote teams.

Main Duties / Responsibilities:

• Responsible for delivery QA targets for the assigned projects

• Product understanding and creating test design

• Execute test cases and report bugs on the tool

• Determine priority for test cases and create effective execution plans

• Participate in defect triage and RCA

• Participate in PI & Sprint planning and Agile ceremonies

• Track & report progress of testing as per the plan

• Contribute towards Sprint retrospective and continuous improvement initiatives

• Implement test techniques , methodologies and tools to achieve high-level of test coverage

• Mentoring & developing the Junior resources

• Adheres to the organization's Quality Engineering best practices and help to drive changes to achieve more efficiency

Required Skills and Experience:

• Bachelor’s degree in Computer Science or a related discipline and at least two, typically five or more years’ experience in a system quality environment, or an equivalent combination of education and work experience

• 2 - 5 Yrs. experience in Software QA – ETL Testing

• Good experience in validating data extraction, transformation and load functionality of the ETL process

• Strong knowledge on SQL queries, stored procedures and experience of doing backend testing

• Experience of working on ETL testing tools and validation across multiple database types

• Experience in test automation using coding, preferably python code

• Strong knowledge on SQL queries and experience of doing backend testing

• Good experience of working in all phase of Test Cycle (Test Design, Test Execution, Defect management & reporting)

• Good knowledge on using Microsoft SQL server tool

• Knowledge of the Healthcare Insurance Industry

• Broad knowledge of the Software Delivery Lifecycle with specific expertise of Software Testing

• Proven experience of working within an Agile environment

• Broad knowledge of automated testing and modelling tools

• Great knowledge of change management and test case generation techniques

• Competent user of Microsoft office applications like Excel, Word, Power

Point and Outlook:

• Excellent written and oral communication skills

• Strong problem-solving and analytical skills

• Comfortable working independently, leading a team or as part of a team

• Demonstrate accuracy and possess a keen eye for detail

• Strong interest in personal development

• Desirable Skills and Experience

• ISTQB Foundation or Intermediate Certified

• Mainframe, DB & API testing

• Test Automation using Python programming knowledge

• ETL tool knowledge like SSIS

About The Cigna Group:

Cigna Healthcare, a division of The Cigna Group, is an advocate for better health through every stage of life. We guide our customers through the health care system, empowering them with the information and insight they need to make the best choices for improving their health and vitality. Join us in driving growth and improving lives.