McKesson Database Developer - EDI Specialist in Dubuque, Iowa

Title: Database Developer - EDI Specialist Location: Tulsa, OK or Dubuque, IA

Position Description

Responsible for performing data mapping using Symphonia and other mapping tools to support standard based Healthcare transactions. Responsible for EDI map development and testing to ensures integrity of EDI data and successful integration. Work with trading partners to ensure mapping compliance. Resolves level 1 & level 2 technical mapping gaps and troubleshoots issues within the EDI system. Uses PL/SQL and SQL*Loader for data extraction, translation, and database loads (ETL). Responsible for day-to-day production application support for ETL loads jobs into an Oracle database using Linux shell scripting. Identifies and investigates data quality/integrity problems, determines impact and provides solutions to problems.

McKesson is in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. McKesson Health Solutions delivers industry-leading clinical evidence and expert technology to help payers and providers collaborate for better healthcare outcomes at lower costs. Our solutions reduce unnecessary healthcare utilization while improving outcomes; operationalize complex volume- and value-based payment models; and optimize billing communication between providers, patients and payers. Our solutions are in more than four out of five payers in the country; more than 3,900 hospitals and facilities use our InterQual® evidence-based decision support criteria; and our RelayHealth® financial solutions are used to automate 1.9 billion financial transactions each year. We understand the importance of a system that works together. Your expertise, drive and passion can help us carry out our mission to improve lives and advance healthcare. Join our team of leaders to begin a rewarding career. Qualifications Minimum Requirements

2+ years SQL scripting experience

3+ years of X12 EDI or related experience Critical Skills

understanding of Oracle Database Development SQL queries experience required Must have ability to connect remotely Strong technical background, troubleshooting and maintenance Assertively seek solutions at the root level of problems Experience in Excel, Oracle, writing SQL queries, and Linux shell scripting

Additional Knowledge & Skills

Experience working with healthcare EDI transactions (270/271, 276/277) Healthcare or insurance technical background Hands on knowledge of IT design, coding, and testing Education

4-year degree in computer science or related field or equivalent experience Physical RequirementsGeneral Office DemandsBenefits & Company StatementMcKesson believes superior performance – individual and team – that helps us drive innovations and solutions to promote better health should be recognized and rewarded. We provide a competitive compensation program to attract, retain and motivate a high-performance workforce, and it’s flexible enough to meet the different needs of our diverse employee population.We are in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. We partner with payers, hospitals, physician offices, pharmacies, pharmaceutical companies and others across the spectrum of care to build healthier organizations that deliver better care to patients in every setting.But we can’t do it without you. Every single McKesson employee contributes to our mission—whatever your title, whatever your role, you act as a catalyst in a chain of events that helps millions of people all over the globe. Talented, compassionate people are the future of our company—and of healthcare. At McKesson, you’ll collaborate on the products and solutions that help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry that’s vital to us all.McKesson is an equal opportunity and affirmative action employer – minorities/females/veterans/persons with disabilities.Qualified applicants will not be disqualified from consideration for employment based upon criminal history.Agency StatementNo agencies please.Category: Technology