UnitedHealth Group

Receive alerts when this company posts new jobs.

Informatica Health Care Data Warehouse ETL Developer - Richmond, VA - 728172

at UnitedHealth Group

Posted: 9/27/2017
Job Status: Full Time
Job Reference #: 728172

Job Description

Position Description

Sounds like a big challenge, right? Here, at Optum, you have the opportunity to achieve great things while you showcase your passion and technical expertise as a Data Warehouse ETL Developer. You'll be inspired by working alongside some of the most brilliant minds in technology who bring compassion, energy and focus to their work every day on a mission to change health care as we know it. Join us! Come share who you are and start doing your life's best work.(sm)
To learn more about Technology careers with UnitedHealth Group, please click here. 
Primary Responsibilities:
  • Define Informatica workflow and mapping standards so development is consistent across all development resources (i.e., no hard coding, leverage of maplet, reuse concepts, etc.)
  • Conduct ETL optimization, troubleshooting and debugging
  • Design and develop test plans for ETL unit testing and integration testing
  • Tune and optimize ETL jobs for performance and throughput. Interact with data modelers and data base administrator on data architecture optimization for ETL performance
  • Provide development support, including walk through approvals, to other ETL application resources to insure that standards are followed and optimized workflow is implemented
  • Document and maintain operational procedures in the form of an operations manual for all ETL workflow.
  • Lead troubleshooting efforts for ETL job issues related to pre-production and production
  • Leverage Informatica Data Quality as a mandatory process step for profiling data prior to downstream transformation 
  • Design and develop data validation processes using Informatica Data Quality.  Design and develop exception and error handling through data governance so that data stewardship is leveraged to assist with anomalies


To be considered for this position, applicants need to meet the qualifications listed in this posting.
Required Qualifications:
  • 3+ years of experience with Informatica PowerCenter
  • 1+ years of experience with Master Data Management (MDM) concepts using any MDM tool
  • 1+ year experience with Informatica Data Quality
  • 1+ year experience with Informatica MDM
  • 1+ year experience with  Informatica Test Data Manager
  • 1+ year experience of regulatory security requirements regarding HIPAA and other regulatory security requirements
  • 1+ Experience with leading other ETL Developers
Preferred Qualifications:
  • Data Experience across Medicaid, Medicare, Exchange and commercial payer environments
  • Teradata experience
  • Experience with dealing with 837 transactions
  • Experience with Informatica Meta Manager
  • Knowledge of data modeling and Erwin

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health - related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)


Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.



Job Keywords: Informatica developer, Informatica PowerCenter, Informatica, Informatica Data Quality, Informatica Test Data Manager, Informatica MDM, Master Data Management, MDM, Teradata, Erwin, data modeling, healthcare, Virginia, Richmond, Virginia, Medicaid, Medicare, Exchange

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!