About UHG

Careers at UnitedHealth Group


We have modest goals: Improve the lives of others. Change the landscape of health care forever. Leave the world a better place than we found it. Such aspirations tend to attract a certain type of person. Crazy talented. Compassionate. Driven. To these individuals, we offer the global reach, resources and can-do culture of a Fortune 5 company. We provide an environment where you’re empowered to be your best. We encourage you to take risks and in return, offer a world of rewards and benefits for performance. Exceeding your limits is an exceptional start to your life's best work.SM


Just like you, we are driven by a set of fundamental principles that are guiding our way forward. Our values of integrity, compassion, relationships, innovation, and performance serve as a foundation to transform health care. Are you in? Learn more about your future at UnitedHealth Group at careers.unitedhealthgroup.com


Job Category:

Information Technology



Approximate Salary:

Not Specified

Position Type:

Full Time

Principal ETL/DataStage Engineer - Minnetonka, MN

UHG - Minnetonka, Minnesota

Posted: 11/15/2018

We are seeking a Principal ETL/Datastage Engineer to lead migration from high cost DataStage to lower cost Informatica or open source ETL tools. The new hire will need to interact with business users and understand how and what kind of data the business wants to see for their analysis. Once the engineer has an understanding of the data, they will be responsible for Troubleshoot issues reported by Business on priority and analyzing the fix. A large part of this role will be to migrate existing DataStage landscape to Informatica or Open Source ETL tools.

Primary Responsibilities:

  • Coordinate with offshore team and provide timely support resolving their inquiries
  • Participate in on call for Production Support
  • Participate in Root Cause analysis and discussions
  • Create SDLC phase delivery documents like BRS / SRS / HLD, etc.
  • Understand existing environment and business of various source systems
  • Discuss reported issues directly with the user and act to resolve immediately
  • Ability to take initiative and ownership on tasks
  • Work with Infrastructure team, while supporting the Informatica environment, to get to the root cause of the issue
  • Work with DBAs independently to overcome performance issues
  • Develop implementation guidelines for Open Source ETL tools
  • Operationalize and develop best practices for Open Source ETL tools
  • Mentor and provide leadership to junior team members
  • Conduct technology training sessions to team and end users
  • Ensure that the technical infrastructure is sufficiently robust, scalable, and efficient to deliver the integrated services underlying the physical environment that supports the processes, resources, and operators required for developing, integrating, sustaining enterprise applications and support services
  • Address the day-to-day management and maintenance of infrastructure services, systems, applications, and hardware usage
  • Support architecture, preliminary design, implementation, and infrastructure operations
  • Develop infrastructure strategy and operational policies, standards, and processes tailored to agency or department missions
  • Develop asset management processes that support the provisioning, tracking, reporting, ownership, risk, controls, and financial status of Enterprise Technology assets
  • Ensure service level management through the development of processes, people, technology, and service level and operating level agreements
  • Understand and use software development practices to manage configuration and automate provisioning
  • Ensure infrastructure and operations security, such as network and application firewalls, authentication, identity management, and intrusion detection and prevention
  • Perform the planning, consulting, technical analysis, design, development, testing, implementation and daily support of all ETL software for all supported platforms within UHG’s infrastructure and systems
  • Integrate and manage middleware and software tools within the various computing platforms

Required Qualifications:

  • 8+ years of experience in product implementation and administration of ETL (DataStage, SSIS) with concentration on the Informatica suite of products
  • Strong knowledge and working experience of Informatica with updated version 10.1
  • Strong and extensive DW experience, ETL Concepts like Design, Development and Process
  • Deep understanding of the Informatica products (e.g. Power Exchange, Power Center, IDS and IDQ) with respect to development
  • Experience working with the following database technologies Oracle and CRM
  • Master data management, data quality, data governance, data archiving and test data management (TDM)

Preferred Qualifications:

  • Proficiency with Oracle PL / SQL, procedures, packages and functions
  • Proficiency with UNIX Shell Scripting, SQL and TWS
  • Work experience in Agile Projects
  • Proficiency with Red hat Linux, networking concepts, LDAP, QAS
  • Datawarehouse concepts
  • Exposure to Implementation of OpenSource ETL tools and technologies 
  • Exposure to other ETL technologies DataStage, SSIS, Talend
  • ELT understanding and WSR experience

Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. This is the place 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: Data engineering, ETL, DataStage, Informatica, Minnetonka, MN, Minnesota

Apply Now