Sign In
 [New User? Sign Up]
Mobile Version

NY SPARCS Application Developer ETL - Albany, NY

UnitedHealth Group

Albany, NY
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

752959 NY SPARCS Application Developer ETL Albany NY

NY SPARCS Application Developer ETL - Albany, NY (752959)

Position Description

As an ETL Developer for the State of New York Hospital Discharge Data Intake Project, you will be responsible for delivery of Informatica components of a multi-Terabyte Oracle Exadata environment that will contain public and private health care encounter data from NY hospitals and other provider facilities.  Data will be synthesized, using Informatica, to support the management, evaluation, and analysis of the NYS health care system.  This project requires comprehensive knowledge of the  Informatica product suite in that it includes not only PowerCenter, but also Test Data Manager, Master Data Management and Data Quality components of the solution.  This is a hand’s on technical role accountable for sourcing data from New York State providers, staging, auditing, cleansing enriching and targeting data to its final NY All Payer Database (APD) reporting structures in Oracle.


Primary Responsibilities:

  • Create data mapping and workflow using Informatica Powercenter to extract, transform and load data into the NY APD target reporting environment 
  • Conform to 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 DBAs 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
  • Advocate and enforce secure coding principles, as defined by State of New York coding policies, to ensure we are in compliance with all NY standards
  • Assist in documenting and maintaining operational procedures in the form of an operations manual for all ETL workflow
  • Assist with 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 
  • Assist in designing and developing data validation processes using Informatica Data Quality. 

Required Qualifications:

  • 3+ years of experience with Informatica PowerCenter
  • 2+ years of healthcare Data Experience across Medicaid, Medicare, Exchange or commercial payer environments
  • 1+ year experience with Informatica Data Quality

Preferred Qualifications:

  • Strong knowledge of HIPAA regulatory security requirements
  • Oracle experience
  • Experience with 837 transactions
  • Knowledge of  Informatica Test Data Manager

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, healthcare, data quality, HIPAA, 837, Ablany, NY

Job Details

  • Contest Number752959
  • Job TitleNY SPARCS Application Developer ETL - Albany, NY
  • Job FamilyInformation Technology
  • Business SegmentOptumInsight

Job Location Information

  • Albany, NY
    United States
    North America

Additional Job Detail Information

  • Employee StatusRegular
  • ScheduleFull-time
  • Job LevelIndividual Contributor
  • ShiftDay Job
  • TravelNo
  • Telecommuter PositionNo
  • Overtime StatusExempt

UnitedHealth Group is the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone.

Powered ByLogo

Featured Jobs[ View All ]

Featured Employers [ View All ]