Application Development Advisor

Application Development Advisor- Hybrid

remote type

Hybrid

locations

Charlotte, NC

time type

Full time

posted on

Posted Today

job requisition id

26012676

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.

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.

• Hybrid work schedule.

Qualifications

• Bachelor’s degree in any field and 5 years of experience. Will accept a 3 or 4 year degree.

• Must have experience with: healthcare domain; developing ETL solutions using IBM DataStage;

• Master data management using Reltio; Apache Kafka; Amazon S3; IBM DataStage Designer;

• Writing complex SQL queries to develop and test the ETL requirements;

• Using relational databases for source and target migration including Teradata, Oracle, DB2, and SQL Server; Kafka Topic; APIs; JSON; 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; Postman; WinSCP; Putty; UltraEdit; and NotePad++;

• If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.