Software Engineering Advisor [T500-10053]

Job Description

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.