Data Engineering Consultant-IBM Infosphere

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

As a Technical lead in the CDC team, the candidate should manage the CDC process and ensure the data availability and quality for Optum Rx Data Estate teams.

Primary Responsibilities:

• Managing the existing CDC subscriptions for any maintenance activities, changes in source table definitions, ensuring the data availability and quality for Optum Rx Data Estate teams
• Monitoring the CDC subscriptions using management console, telemetry (alerts) and addressing CDC job failures, latency
• Communication around CDC application maintenance activities to all stakeholders and coordinating the effort around by working with source and consumer teams
• On-boarding new tables requested for CDC to new/existing subscriptions
• Maintaining the CDC infrastructure and planning for upgrades
• Continuous improvement to existing CDC application eco-system by leveraging new methods and technologies
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Engineering Degree in computer science or equivalent
• 8+ years of IT experience
• 5+ years of experience with change data capture (CDC) technology like IBM Infosphere Data Replication (IIDR) for real-time data replication, Qlik, Debezium, Apachek Kafka
• Experience with Apache Kafka for real-time data streaming and kafka connect for data integration
• Good knowledge in Azure, ADF or similar cloud-based orchestration tools
• Proven ability to provide level 3 support for unresolved issues and engaging vendors when necessary
• Proven ability to develop, maintain, and optimize large scale data pipeline on Databricks for both batch and real-time data processing
• Flexible for on call support during the rotational cycle for urgent incidents
• Flexible to work in rotational shifts, including weekends and holidays and per the schedule

Preferred Qualifications:

• Experience with ETL/ELT processes, data transformations, and datalake architectures
• Experience with iSeries Database

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.