HIH Software Engineering Associate Advisor Join the team that manages the endtoend 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 solid 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 cloudOptimize and finetune 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 usersMonitor and troubleshoot data pipelines resolving issues related to data integrity performance and job failuresDevelop and implement data validations and quality checks to ensure the accuracy and reliability of the data warehouseDocument technical specifications processes and workflows related to Teradata and Informatica developmentAssist in capacity planning performance tuning and security managementPartner with other teams and stake holders for any clarifications needed for the timely deliverables Ability to provide alternative solutions Experienced with agile methodology Qualifications Bachelors degree in the related field 8 years of experience in developer role 6 years of handson experience with Teradata database development including query optimization Strong knowledge of SQL and proficiency in writing complex queries stored procedures and macros in Teradata4 years of experience with Databricks with focus on distributed data processing frameworks like Apache SparkExperience with AWS services such as S3 Glue Lambda Airflow and EC2 for building and managing data infrastructuresFamiliarity with Python for data engineering tasks in DatabricksExperience with data warehousing conceptsAbility to handle large datasets and optimize ETL performance for data loading and transformationExperience with data pipeline schedulingExperience with continuous integration and continuous delivery CI CD tools like GitHub Jenkins etc Excellent problemsolving skills and attention to detailsStrong 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

📌 Software Engineering Associate Advisor (Hyderabad)
🏢 The Cigna Group
📍 Hyderabad