Infrastructure Engineering Senior Analyst

The position is responsible for ensuring the quality and reliability of Data & Analytics applications and Financial/Oracle ERP applications under Evernorths 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.

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.
• Test plan & Test case design with SQL queries based on technical design and mapping documents
• Execute queries to verify the data transformations
• Run ETL jobs and monitor jobs to ensure data is extracted, transformed and loaded according to predefined systems.
• Perform business requirement analysis, develop system & integration test design, test execution, defect logging, reporting, and tracking.
• 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.

Qualifications:

Required 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:

• Bachelors degree in computer science or a related discipline, typically eight or more years of solid, diverse work experience in IT with 7+ 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
• Experience and knowledge in Python