Optum is looking to improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best, and this role will directly contribute to this goal by managing and manipulating structured data to build business intelligence tools and support analyses.
Requirements
- 5+ years of Informatica PowerCenter / ETL Experience
- 5+years of complex SQL and Performance Tuning Experience
- 5+ years of experience with RDBS databases - Oracle, Teradata, SQL Server
- 5+ years of experience with front-end data warehouse or similar processing which includes extracting data for large files from various sources, cleansing data, and preparing the data for loading into a data warehouse
- Intermediate skill level with Microsoft Office Suite of tools and VISIO
- Experience deploying program changes to production
- Experience with State Medicaid / Medicare / Healthcare applications
Responsibilities
- Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
- Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
- Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
- Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows
- Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
- Scheduling and monitoring ETL/Informatica jobs in a development, system testing, and production environment
- Developing proactive processes for monitoring capacity and performance tuning
Other
- Proven excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
- Proven solid organization skills and ability to set priorities and schedule work deadlines
- Bachelor's degree or equivalent experience
- Ability to work remotely from anywhere within the U.S.
- Adherence to UnitedHealth Group's Telecommuter Policy
