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
Required Qualifications:3+ years of experience with Informatica PowerCenter 1+ Experience with leading other ETL DevelopersPreferred Qualifications: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+ years of Healthcare Claims Data 1+ year experience of regulatory security requirements regarding HIPAA and other regulatory security requirements 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 erwinCareers 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, Claims data
Our mission is to help people live healthier lives and to help make the health system work better for everyone.- We seek to enhance the performance of the health system and improve the overall health and well-being of the people we serve and their communities. - We work with health care professionals and other key partners to expand access to quality health care so people get the care they need... at an affordable price. - We support the physician/patient relationship and empower people with the information, guidance and tools they need to make personal health choices and decisions.