QA & Testing Lead Analyst
Position Overview
The QA & Testing Lead Analyst
(Ab Initio)
is responsible for
implementing robust testing practices across the PBM organization’s data integration platforms. The candidate will ensure adherence to SAFE Agile practices and work closely with developers, data engineers, and other testers in small scrum teams to deliver high-quality ETL solutions in
a timely
and cost-effective manner. Specific duties include validating source-to-target data mapping,
creating
and executing test plans and test cases, estimating test efforts,
analyzing
and communicating test results, defect tracking, and supporting regression testing for automation readiness.
This role provides counsel and advice across multiple stakeholders on ETL testing matters, often requiring coordination between teams. The role may provide thought leadership and technical
expertise
across multiple disciplines and act as a lead within the team, mentoring junior testers.
Excited to grow your career?
We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position, you see is right for you, we encourage you to apply!
Our people make all the difference in our success.
Responsibilities
Work with business partners and IT staff to
establish
and implement a consistent ETL testing
methodology
.
Design and execute comprehensive test cases for ETL processes using Ab Initio.
Validate source-to-target data mapping and transformation logic for large-scale healthcare datasets.
Identify
and prepare complex test data to support defined test cases.
Develop and
maintain
regression test beds and schedule test cycles.
Ensure regression scripts are in
appropriate format
for automation.
Perform manual and automated ETL test execution.
Conduct UAT and End-to-End testing for ETL workflows.
Utilize
appropriate testing
tools and frameworks for ETL validation.
Validate and report progress, risks, issues, and defects to the agile team.
Communicate effectively with business partners and agile team members throughout the project lifecycle.
Support PI Planning, retrospectives, daily stand-ups, and business demos.
Participate in post-implementation testing and
lessons learned
analysis.
Bring new ETL testing methodologies and best practices to the team.
Qualifications
Required Skills
:
Strong knowledge and hands-on experience in SQL, Unix shell scripting,
Oracle
and Teradata databases
Mainframe experience a plus
Knowledge of Medical claims data and processing (Claims adjustments, ICD Codes, Procedures, Revenues,
etc
)
Excellent analytical and interpersonal skills along with excellent oral and written communication skills.
Proficiency
in ETL testing concepts and tools.
Hands-on experience with Ab Initio components: GDE, Co>Operating System, EME, Conduct>IT, Express>IT.
Strong SQL skills for data validation and query optimization.
Familiarity with Unix/Linux scripting.
Knowledge of defect tracking tools (Jira, Confluence).
Understanding of
automation frameworks and CI/CD tools (Jenkins, Git).
Strong written and verbal communication skills
.
Familiarity with Agile
methodology
and SAFE practices.
Required
Experience
& Education
:
5-8
years of experience in Ab Initio ETL
,
preferably in healthcare or PBM domain.
Experience with vendor management in an onshore/offshore model.
Proven experience testing large-scale enterprise data solutions.
Bachelor’s degree in technical/business areas or equivalent work experience.
Desired Experience:
Healthcare experience
including
Disease Management
Location & Hours of Work
Full-time position, working 40 hours per week. Expected overlap with US hours as appropriate
Primarily based in the Innovation Hub in Hyderabad, India in a hybrid working model (3 days WFO and 2 days WAH)
Equal Opportunity Statement
Evernorth
is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.
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.
