Informatica - Sr. Software Engineer - 27077 - 26234 - BF - JR164881 presso Carelon Global Solutions (CGS)

Position Title:

Job Family:

Shift:

Job Description:

JOB DESCRIPTION

Job Title

Senior Software Engineer I

Requirement Type

Sr. Associate

Job Location

Bengaluru/ Gurugram

Requirement Level

SSE

Hiring Manager
Team Lead

Primary Skill

Informatica, Oracle

Business

HSP

Skill Category

Niche

ABOUT ELEVANCE HEALTH

Elevance Health is a leading health company in America dedicated to improving lives and communities and making healthcare simpler.  It is the largest managed health care company in the Blue Cross Blue Shield (BCBS) Association serving more than 45 million lives across 14 states.

A regular in Fortune 500 list, Elevance Health ranked 20 in 2022. Gail Boudreaux, President and CEO of Elevance Health has been a consistent name in the Fortune list of most powerful women and currently holds 4th rank on this list.

ABOUT CARELONCARELON

Carelon Global Solutions (CGS) is a healthcare solutions company that simplifies complex operational processes to improve the health of the healthcare system.

Previously known as Legato Health Technologies, Carelon Global Solutions (hereinafter, CGS) underwent a name change and joined the Carelon family of brands in January 2023, as a fully owned subsidiary of Elevance Health (Previously Anthem Inc.). CGS brings together a global team of like-minded innovators who manage and optimize operational processes for health plans as well as providers.

Our brightest minds housed across our global headquarters in Indianapolis as well as Bengaluru, Hyderabad and Gurugram in India, Manila in the Philippines, Limerick in Ireland and San Juan in Puerto Rico bring with them innovative capabilities and an unmatched depth of experience. This global team uniquely positions CGS to enable scalable, next-generation platforms and specialized digital tools that make healthcare operations more practical, effective and efficient.

OUR MISSION & VALUES

Our Mission: Improving Lives and Communities. Simplifying Healthcare. Expecting More.
Our Values: Leadership | Community | Integrity | Agility | Diversity

JOB POSITION

Carelon Global Solutions India is seeking a SSE who will be responsible for Informatica , Oracle ETL Developer, Agile method, Skilled in Developing, Designing and implementing large scale enterprise applications . Supportive and resolve the team technical issues, Strong communication and collaboration skills with a proven track record of working effectively in cross-functional teams.

JOB RESPONSIBILITY

Senior associates will be responsible for the following:

Must Have:

• 5-8 years of experience and has extensive Knowledge in Informatica Power Center 9.1/8.x/7.x Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager, Data cleaning, Flat file system Fixed width, Delimiter, OLAP.

• Innovative thinking and strong problem solving and analytical capabilities.

• Strong working knowledge of Developing, Designing and implementing large scale enterprise applications.

• Possess strong analytical skills, organizational skills, attention to detail, and excellent verbal and written communication skills.

• Ability to establish and maintain effective working relationships with co-workers, managers and internal and/or external customers.

• Plans and conducts Informatica ETL unit and development tests

• Design, implement, test and maintain ETL components for multiple applications

• Provide post-production application support as required

• Provide data analysis to support new project definition/design to troubleshoot/resolve issues with existing subject areas

• Work independently or as part of a team to deliver ETL projects

• Follow established standards and best practices and provide input for improvement of those processes

• Maintain a high volume, multi-terabyte 24/7 ODS application

• Knowledge of Agile process

• Skilled in SQL, PL/SQL, SQL Plus, TOAD, SQL Assistant

• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets

• Developed rules and mapplets that are commonly used in different mappings

• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps

• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations

• Proficient with a database SQL language for user defined database extract or update statements. SQL and database skills are the two great building blocks for ETL work.

• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.

• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.

• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.

• Responsible for migration of the work from dev environment to testing environment

• Responsible for solving testing issues.

• Good understanding of data mapping, data validation, data manipulation, and data analysis use cases.

• Extensive experience working in Agile/Scrum methodology.

• Perform advanced ETL development activities using Informatica, PL/SQL, Oracle Database tuning, SQL tuning

• Oracle experience from the development perspective (database and application), PL/SQL

• Informatica PowerCenter developer needed to develop and enhance ETLs from various sources to Oracle ODS etc.

• SDLC Knowledge.

QUALIFICATION

• Bachelor’s or master’s degree .

EXPERIENCE

• 6-8 years of experience in ETL Informatica and Oracle.

SKILLS AND COMPETENCIES

• Extensive Knowledge in Informatica Power Center 9.1/8.x/7.x Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager, Data cleaning, Flat file system Fixed width, Delimiter, OLAP.

• Innovative thinking and strong problem solving and analytical capabilities.

• Strong working knowledge of Developing, Designing and implementing large scale enterprise applications.

• Possess strong analytical skills, organizational skills, attention to detail, and excellent verbal and written communication skills.

• Ability to establish and maintain effective working relationships with co-workers, managers and internal and/or external customers.

• Plans and conducts Informatica ETL unit and development tests

• Design, implement, test and maintain ETL components for multiple applications

• Provide post-production application support as required

• Provide data analysis to support new project definition/design to troubleshoot/resolve issues with existing subject areas

• Work independently or as part of a team to deliver ETL projects

• Follow established standards and best practices and provide input for improvement of those processes

• Maintain a high volume, multi-terabyte 24/7 ODS application

• Knowledge of Agile process

• Skilled in SQL, PL/SQL, SQL Plus, TOAD, SQL Assistant.

THE CARELON PROMISE

Aligning with our brand belief of ‘limitless minds are our biggest asset’, we offer a world of limitless opportunities to our associates.

It is our strong belief that one is committed to a role when it is not just what the role entails, but also what lies in its periphery that completes the value circle for an associate.

This world of limitless opportunities thrives in an environment that fosters growth and well-being, and gives you purpose and the feeling of belonging.

LIFE @ CARELON

• Extensive focus on learning and development

• An inspiring culture built on innovation, creativity, and freedom.

• Holistic well-being

• Comprehensive range of rewards and recognitions

• Competitive health and medical insurance coverage

• Best-in-class amenities and workspaces

• Policies designed with associates at the center.

EQUAL OPPORTUNITY EMPLOYER

Carelon is committed to a diverse and inclusive workplace and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics.

Reasonable Accommodation

Our inclusive culture empowers Carelon to deliver the best results for our customers. We not only celebrate the diversity of our workforce, but we also celebrate the diverse ways we work.

If you have a disability and need accommodation such as an interpreter or a different interview format, please ask for the Reasonable Accommodation Request Form.

Disclaimer: Offered designation titles differ*

Job Type: