Application Development Advisor- Hybrid

Cigna Group•Charlotte, NC

1d•Hybrid

About The Position

Cigna-Evernorth Services Inc. is hiring an Application Development Advisor in Charlotte, North Carolina, to serve as a technical expert and trusted advisor in designing, developing, and implementing ETL solutions across enterprise projects. The role focuses on creating reliable, scalable ETL architecture and workflows, maintaining data integrity and performance, and ensuring development deliverables meet established standards. The position follows a hybrid work schedule. The position requires a bachelor’s degree in any field (a three- or four-year degree is accepted) and five years of experience. Candidates must have experience in the healthcare domain and with the listed ETL, data management, database, scheduling, testing, and development tools and technologies. For occasional or permanent work from home, an internet connection through cable broadband or fiber optic service with at least 10 Mbps download and 5 Mbps upload is required.

Requirements

Bachelor’s degree in any field; a three- or four-year degree is accepted.
Five years of experience.
Experience in the healthcare domain.
Experience developing ETL solutions using IBM DataStage, including IBM DataStage Designer.
Experience with master data management using Reltio.
Experience with Apache Kafka, Kafka Topic, Amazon S3, APIs, JSON, and XML.
Experience writing complex SQL queries to develop and test ETL requirements.
Experience using relational databases for source and target migration, including Teradata, Oracle, DB2, and SQL Server.
Experience using CA WA Workstation to create, manage, and schedule ESPs.
Experience with SQL editors such as Teradata Studio, Toad for Oracle, and Toad for IBM DB2.
Experience using Postman, WinSCP, Putty, UltraEdit, and NotePad++.
For occasional or permanent home working, access to cable broadband or fiber optic internet service with at least 10 Mbps download and 5 Mbps upload.

Responsibilities

Serve as a subject matter expert in ETL design and development and provide 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, drawing on 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 ETL jobs using ESP, and test and deploy them in Production.
Design and implement CI/CD pipelines and methodologies for ETL deployments.
Plan and execute application tests and resolve defects.
Perform data mapping, including source-to-target mapping and conversion to multiple output formats.
Collaborate with cross-functional teams to integrate ETL solutions with enterprise systems.
Ensure data integrity, scalability, and performance through robust architecture, standards, and best practices.