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.
