Optum, a global organization, is seeking to improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best.
Requirements
- 7+ years of experience with Informatica PowerCenter and ETL development
- 5+ years of experience writing complex SQL and performance tuning
- 5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)
- 3+ years of experience leading the design and implementation of ETL solutions using Informatica PowerCenter
- 3+ years of Informatica PowerCenter administration experience
- 5+ years of data warehouse development experience
- 5+ years of data modeling experience using ERWIN or similar tools
- 3+ years of Unix Shell (Bash/Korn) scripting experience
- 2+ years of experience with Azure Data Factory and Snowflake
Responsibilities
- Develop and lead the design and implementation of new and existing interfaces solutions using Informatica PowerCenter to extract, transform, and load data (ETL) from multiple data agency sources
- Automate data staging processes and optimize ETL job scheduling for performance and efficiency
- Oversee and lead the development of mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations
- Monitor and troubleshoot ETL jobs across development, testing, and production environments
- Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata
- Collaborate with stakeholders to define requirements, document technical solutions, and support project planning
- Participate in unit, integration, and system testing
Other
- Proven solid communication, collaboration, and mentoring skills
- Proven solid organizational and time management skills
- Residing in or near Springfield, IL
- Adhere to UnitedHealth Group’s Telecommuter Policy
