**Software Engineering** **Senior Analyst** **-** **ETL** **Developer** 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. Position Overview Responsible for overall design and development of data integration code for the engineering team/asset.  Responsible for providing technical knowledge on integration and ETL processes to build and establish coding standards. Create a working agreement withing the team and other stakeholders that are involved. Partner and align with Enterprise Architect, Product Owner, Production Support, Analyst, PVS Testing team, and data engineers to build solutions that conform to defined standards. Perform code reviews and implement suggest improvements.  Responsibilities + Well versed in design, development, and unit testing of ETL jobs that read and writes data from database tables, flat files, datasets, IBM MQ’s, Kafka topics, S3 files, etc.   + Carry out Data Profiling of Source data and generate logical data models (as required or applicable).   + Define, document, and complete System Requirements Specifications including Functional Requirements, Context Diagrams, Non-Functional Requirements, and Business Rules (as applicable for Sprints to be complete). + Create Source-to-Target mapping documents as required and applicable. + Support definition of business requirements including assisting the Product Owner in writing user stories and acceptance criteria for user stories. + Support other scrum team members during the following activities (as required or applicable). + Design of test scenarios and test cases. + Develop and identify data requirements for Unit, Systems, and Integration tests. Qualifications **Required Skills** **:** + Adept working experience in design and development of performance efficient ETL flows dealing with millions of rows in volume.  + Must have experience working in SAFE Agile Scrum project delivery model.  + Good at writing complex SQL queries to pull data out of RDBMS databases like Oracle, SQL Server, DB2, Teradata, etc.  + Good working knowledge of Unix scripts.  + Batch job scheduling software such as CA ESP.  + Experienced in using CI/CD methodologies.  **Required** **Experience** **& Education** **:** ** ** + Must have 3 to 5 years of hands-on development of ETL jobs using IBM DataStage version 11 or higher.  + Working knowledge of Data Modelling, solution architecture, normalization, data profiling etc.  + Adherence to good coding practices, technical documentation, and must be a good team player.   **Desired Experience:** ** ** ** ** + Healthcare experience    **Location & Hours of Work** + Full-time position, working 40 hours per week. Expected overlap with US hours as appropriate + Primarily based in the Innovation Hub in Hyderabad, India in a hybrid working model (3 days WFO and 2 days WAH) **Equal Opportunity Statement** _Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations._ **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.