Application Development Advisor- Hybrid

Cigna Healthcare•Charlotte, NC

2d•Hybrid

About The Position

Cigna-Evernorth Services Inc. seeks an Application Development Advisor for the Charlotte, NC location to serve as a key technical expert and trusted advisor in the design, development, and implementation of ETL (Extract, Transform, Load) solutions across multiple enterprise projects. This role involves ensuring data integrity, scalability, and performance through robust architecture, standards, and best practices. The advisor will act as a subject matter expert in ETL design and development, providing guidance throughout the project lifecycle, analyzing complex business requirements, and translating them into efficient ETL architecture, workflows, and data transformation rules. Responsibilities include creating ETL mapping, design, and product support documents, reviewing and validating design specifications and code deliverables, leading data analysis and metadata management initiatives, defining and enforcing ETL standards, developing and optimizing data extraction, transformation, and loading processes, writing and maintaining advanced SQL scripts, scheduling ETL jobs using ESP, designing and implementing CI/CD pipelines, performing application test planning and execution, executing data mapping activities, and collaborating with cross-functional teams. The position offers a hybrid work schedule.

Requirements

Bachelor’s degree in any field and 5 years of experience. Will accept a 3 or 4 year degree.
Experience with healthcare domain.
Developing ETL solutions using IBM DataStage.
Master data management using Reltio.
Experience with Apache Kafka.
Experience with Amazon S3.
Experience with IBM DataStage Designer.
Writing complex SQL queries to develop and test ETL requirements.
Using relational databases for source and target migration including Teradata, Oracle, DB2, and SQL Server.
Experience with Kafka Topic.
Experience with APIs.
Experience with JSON.
Experience with XML.
Using CA WA Workstation to create, manage, and schedule ESPs.
Using SQL editors such as Teradata Studio, Toad for Oracle, and Toad for IBM DB2.
Using Postman.
Using WinSCP.
Using Putty.
Using UltraEdit.
Using NotePad++.

Responsibilities

Ensure data integrity, scalability, and performance through robust architecture, standards, and best practices.
Act as a subject matter expert in ETL design and development, providing guidance throughout the project lifecycle.
Analyze complex business requirements and translate them into efficient ETL architecture, workflows, and data transformation rules.
Create ETL mapping, design, and product support documents.
Review and validate design specifications and code deliverables from development teams to ensure compliance with standards.
Lead data analysis and metadata management initiatives to support accurate and consistent data usage.
Define and enforce ETL standards, processes, and best practices, leveraging expertise in normalized and de-normalized data structures.
Develop and optimize data extraction, transformation, and loading processes within parallel processing frameworks.
Write and maintain advanced SQL scripts for data manipulation and validation.
Schedule the ETL jobs using ESP, testing and deployment in Production.
Design and implement CI/CD pipelines and methodologies for ETL deployments.
Perform comprehensive application test planning, execution, and defect resolution.
Execute data mapping activities, including source-to-target mapping and conversions to multiple output formats.
Collaborate with cross functional teams to ensure seamless integration of ETL solutions with enterprise systems.