HIH - Software Engineering Associate Advisor

3 days ago


Hyderabad, Telangana, India Cigna Healthcare Full time US$ 1,20,000 - US$ 1,50,000 per year

HIH - Software Engineering Associate Advisor

Join the team that manages the end-to-end technology and life cycle management of the applications hosted both on premises and in the AWS cloud.

We are looking for an experienced Software Engineer with 8 to 10 years of experience to join the Data and Analytics Engineering (D&AE) operational effectiveness team. The Associate advisor will be responsible for managing and optimizing the data pipelines for the corporate data warehouse hosted on the Teradata platform. The ideal candidate will have a strong technical background and experience in creating & managing complex data queries and pipelines.

Key Responsibilities:

  • Design, develop, and maintain ETL processes to integrate data from Teradata into Databricks on AWS cloud
  • Optimize and fine-tune Teradata queries, database structures, and data loading strategies to ensure high performance and scalability.
  • Create and maintain data mappings, workflows, and sessions in Informatica for data extraction, transformation, and loading.
  • Collaborate with data architects, analysts and stewards to define the data requirements and ensure the availability and accuracy of the data for business users
  • Monitor and troubleshoot data pipelines, resolving issues related to data integrity, performance, and job failures
  • Develop and implement data validations and quality checks to ensure the accuracy and reliability of the data warehouse
  • Document technical specifications, processes, and workflows related to Teradata and Informatica development
  • Assist in capacity planning, performance tuning and security management
  • Partner with other teams and stake holders for any clarifications needed for the timely deliverables.
  • Ability to provide alternative solutions.
  • Experienced with agile methodology.

Qualifications:

  • Bachelor's degree in the related field.
  • 8+ years of experience in developer role.
  • 6+ years of hands-on experience with Teradata database development, including query optimization.
  • Strong knowledge of SQL and proficiency in writing complex queries, stored procedures, and macros in Teradata
  • 4+ years of experience with Databricks with focus on distributed data processing frameworks like Apache Spark
  • Experience with AWS services such as S3, Glue, Lambda, Airflow and EC2 for building and managing data infrastructures
  • Familiarity with Python for data engineering tasks in Databricks
  • Experience with data warehousing concepts
  • Ability to handle large datasets and optimize ETL performance for data loading and transformation
  • Experience with data pipeline scheduling
  • Experience with continuous integration and continuous delivery (CI/CD) tools like GitHub, Jenkins etc.
  • Excellent problem-solving skills and attention to details
  • Strong communication and collaboration skills

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.



  • Hyderabad, Telangana, India Cigna Healthcare Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Automation Engineer Associate Advisor - HIH - EvernorthABOUT 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...


  • Hyderabad, Telangana, India Cigna Healthcare Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Software Engineering Associate Advisor-HIH. Position OverviewWe're seeking a talented AI/ML Engineer to design, develop, and deploy cutting-edge AI and machine learning solutions. You'll work with state-of-the-art models and technologies, contributing to projects that have the potential to revolutionize industries.Roles & ResponsibilitiesDesign and...


  • Hyderabad, Telangana, India Cigna Healthcare Full time US$ 1,20,000 - US$ 2,00,000 per year

    HIH - SE Associate Advisor_McLaughlin Software Engineering Associate AdvisorPosition OverviewThe job profile for this position is Software Engineering Associate Advisor, which is a Band 3 Contributor Career Track Role.Excited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally...


  • Hyderabad, Telangana, India The Cigna Group Full time

    Job DescriptionSoftware Engineering Associate Advisor - HIH - EvernorthAbout EvernorthEvernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention, and treatment of illness and disease more accessible to...


  • Hyderabad, Telangana, India Cigna Healthcare Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Software Engineering Senior Advisor – HIH – EvernorthPosition Summary: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 applyOur people make all the difference in...


  • Hyderabad, Telangana, India Cigna Healthcare Full time US$ 90,000 - US$ 1,20,000 per year

     Software Engineering Associate Advisor - HIH - Evernorth About Evernorth: Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits 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...


  • Hyderabad, Telangana, India Cigna Healthcare Full time US$ 1,20,000 - US$ 2,00,000 per year

    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...


  • Hyderabad, Telangana, India Cigna Healthcare Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    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...


  • Hyderabad, Telangana, India Cigna Healthcare Full time US$ 1,00,000 - US$ 1,50,000 per year

    Software Engineering Associate Advisor - HIH - EvernorthAbout Evernorth:Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits 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...


  • Hyderabad, Telangana, India Cigna Healthcare Full time US$ 1,00,000 - US$ 1,50,000 per year

    Job DescriptionWe are excited to announce an opening for Software Engineering Associate Advisor atEvernorth Health Services India.Please find below the details of the role and its responsibilities.Skills Required:React, Java, AWS, Spring Boot, MongoDB, GraphDBExperience Range:8 - 11 yearsJob Description:About Evernorth:Evernorth Health Services, a division...