UnitedHealth Group Principal, Data Engineering - ETL - Telecommute in Latham, New York
Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)
As a Principal, Data Engineering - E TL for the State of New York All Payer Database (APD) Project, you will be responsible for managing delivery of all Informatica components of a multi-Terabyte Oracle Exadata environment that will contain public and private health care claims and encounter data from insurance carriers, health plans, third-party administrators, pharmacy benefit managers, Medicaid and Medicare. Data will be synthesized to support the management, evaluation, and analysis of the NYS health care system. This project is comprehensive to 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 hands-on technical role accountable for optimizing and successfully delivering all components of the Informatica solution.
You’ll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.
Install, upgrade and patch Informatica components of the NY APD solution so that the environment remains current
Implement procedures to maintain, monitor, backup and recovery operations of the ETL environment so that the environment is reliable and highly available through time
Define Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (I,e, no hard coding, leverage of maplett/reuse concepts)
Conduct ETL optimization, troubleshooting and debugging
Designs and develops 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 insure we are in compliance with all NYS standards
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
Designs and develops data validation processes using Informatica Data Quality
Designs and develop exception and error handling through data governance so that data stewardship is leveraged to assist with anomalies
Create PL/SQL stored procedures, functions and packages for moving the data between staging areas
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database
Develop Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
Create Packages and Procedures to automatically drop table indexes and create indexes for the tables
You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
3+ years of experience with Informatica Powercenter
3+ years of experience with SQL and PL/SQL
2+ years of experience with LINUX/UNIX Scripting
1+ years of experience with Informatica Data Quality
Solid knowledge of regulatory security requirements regarding HIPAA and other regulatory security requirements
Full COVID-19 vaccination is an essential requirement of this role. UnitedHealth Group will adhere to all federal, state and local regulations as well as all client requirements and will obtain necessary proof of vaccination prior to employment to ensure compliance
- Bachelor's degree preferred
To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies now require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles require full COVID-19 vaccination as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment.
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)
*All Telecommuters will be required to adhere to UnitedHealth Group’s Telecommuter Policy.
Colorado, Connecticut or Nevada Residents Only : The salary range for Colorado/Connecticut/Nevada residents is $94,500 to $171,700. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you’ll find a far-reaching choice of benefits and incentives
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: ETL Architect, Informatica Powercenter, SQL, Linux, Unix, Informatica Data Quality, HIPAA, Latham, NY, New York
- UnitedHealth Group Jobs