refresh

トレンド企業

Trending

採用

JobsCigna

Application Development Advisor - HIH - Evernorth

Cigna

Application Development Advisor - HIH - Evernorth

Cigna

Hyderabad, India

·

On-site

·

Full-time

·

2w ago

Benefits & Perks

Healthcare

401(k)

Learning Budget

Healthcare

401k

Learning

Required Skills

Python

Apache Spark

SQL

Teradata

Data Engineering

Agile

Scrum

Role Title: Application Developer Advisor – Full Stack Data Engineer Position Summary:

Cigna, a leading Health Services company, is looking for an exceptional engineer. The Full Stack Data Engineer is responsible for the delivery of a business need starting from understanding the requirements to deploying the software into production. This role requires you to be fluent in some of the critical technologies with proficiency in others and have a hunger to learn on the job and add value to the business. Critical attributes of being a Full Stack Engineer, among others, is ownership, eagerness to learn & an open mindset. In addition to Delivery, the Full Stack Engineer should have an automation first and continuous improvement mindset. Person should drive the adoption of CI/CD tools and support the improvement of the tools sets/processes.

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, Python
  • Write referenceable & modular code
  • 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.
  • Troubleshooting the issues, providing effective solutions and jobs monitoring in the production environment
  • Have a quality mindset, not just code quality but also to ensure ongoing data quality by monitoring data to identify problems before they have business impact
  • Take risks and champion new ideas

Experience Required:

  • Overall 8-10 years of experience

  • 5 years of experience required in listed primary skills in Full Stack Data Engineering role

  • 5 years of Python scripting experience

  • 5 years of Data Management & SQL expertise – Teradata & Snowflake experience strongly preferred

  • 3 years being part of Agile teams – Scrum

Experience Desired:

  • Strong experience in writing complex and effective SQLs (using Teradata SQL, Hive SQL and Spark SQL) and Stored Procedures
  • Health care domain knowledge is a plus

Primary Skills

Full Stack Data Engineering role:

  • Excellent work experience on Databricks as Data Lake implementations
  • Strong development experience in Spark, Py-Spark, Shell scripting, Teradata.
  • Python, C, C, Java, Scala, or other OO compiled language
  • Experience with BDD and TDD development methodologies
  • Experience with version management tools – Git preferred
  • Experience in Agile and working knowledge on DevOps tools (Git, Jenkins, Artifactory, GitHub Actions/Runners)
  • AWS (S3, EC2, SNS, SQS, Lambda, ECS, Glue, IAM, and CloudWatch)
  • Databricks (Delta lake, Notebooks, Pipelines, cluster management, Azure/AWS integration
  • Big data technologies, Kafka, Airflow, Databricks, Spark

Additional Skills:

  • Experience in Jira and Confluence
  • Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.

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.

Total Views

0

Apply Clicks

0

Mock Applicants

0

Scraps

0

About Cigna

Cigna

Cigna

Public

The Cigna Group is an American multinational for-profit managed healthcare and insurance company based in Bloomfield, Connecticut.

10,001+

Employees

Bloomfield

Headquarters

Reviews

3.0

9 reviews

Work Life Balance

3.8

Compensation

2.5

Culture

2.8

Career

2.2

Management

2.0

35%

Recommend to a Friend

Pros

Remote work flexibility and work from home options

Good work-life balance

Great people and teamwork

Cons

Poor management and micro-controlling leadership

Frequent layoffs and job instability

Limited career advancement opportunities

Salary Ranges

18 data points

L2

L3

L4

L5

L6

L2 · Financial Analyst L2

0 reports

$74,750

total / year

Base

$29,900

Stock

$37,375

Bonus

$7,475

$52,325

$97,175

Interview Experience

4 interviews

Difficulty

2.8

/ 5

Duration

14-28 weeks

Offer Rate

50%

Experience

Positive 50%

Neutral 0%

Negative 50%

Interview Process

1

Application Review

2

Recruiter Screen

3

Technical Phone Screen

4

Team Member Interviews

5

Panel/Multiple Interviews

6

Offer

Common Questions

Coding/Algorithm

Technical Knowledge

Behavioral/STAR

Past Experience

Culture Fit