Software Engineering Advisor

ABOUT EVERNORTH:

Evernorth exists to elevate health for all, because we believe health is the starting point for human potential and progress. As champions for affordable, predictable and simple health care,

we solve the problems others don’t, won’t or can’t.

Our innovation hub in India will allow us to work with the right talent, expand our global footprint, improve our competitive stance, and better deliver on our promises to stakeholders. We are passionate about making healthcare better by delivering world-class solutions that make a real difference.

We are always looking upward. And that starts with finding the right talent to help us get there.

Role Title: Software Engineering Advisor

Job Description & Responsibilities:

Work with business and technical leadership to understand requirements

Design to the requirements and document the designs

Ability to write product-grade performant code for data extraction, transformations and loading using Spark, Py-Spark

Do data modeling as needed for the requirements

Write performant queries using Teradata SQL, Hive SQL and Spark SQL against Teradata and Hive

Implementing dev-ops pipelines to deploy code artifacts on to the designated platform/servers like AWS or Hadoop Edge Nodes

Implement Hadoop job orchestration using Shell scripting, Apache Oozie, CA7 Enterprise Scheduler and Airflow

Troubleshooting the issues, providing effective solutions and jobs monitoring in the production environment

Participate in sprint planning sessions, refinement/story-grooming sessions, daily scrums, demos and retrospectives

Experience Required:

Overall 8-10 Years

Experience Desired:

Experience in Jira and Confluence

Health care domain knowledge is a plus

Excellent work experience on Hadoop as data warehouse

Experience in Agile and working knowledge on DevOps tools

Education and Training Required:

Primary Skills:

Spark, Py-Spark, Shell scripting, Teradata, Hive and Hadoop

SQLs (using Teradata SQL, Hive SQL and Spark SQL) and Stored Procedures

Git, Jenkins, Artifactory

Unix/Linux Shell scripting (KSH) and basic administration of Unix servers

CA7 Enterprise Scheduler

AWS (S3, EC2, SNS, SQS, Lambda, ECS, Glue, IAM, and Cloud Watch)

Databricks (Delta lake, Notebooks, Pipelines, cluster management, Azure/AWS integration)

Additional Skills:

Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.