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
