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

Senior ETL Developer - Informatica - Horsham, PA

UHG - Horsham, Pennsylvania

Posted: 12/12/2018

Together, we deliver smarter, faster and simpler solutions for a modern, innovative health system. We are also the career home to Senior ETL Developers who bring compassion and passion, energy and focus to their work every day. If you strive to help people live healthier lives by building your career with a leader in health care, this is the career for you! Come share your expertise and your passion and do your life's best work.(sm)
As part of this group, you will be a primary contributor in developing, testing and deploying key data warehouses, data marts and will be working with cutting edge technology. This role will prepare you for significant career growth.
We are immediately seeking a Senior ETL Developer with advanced ETL Architecture/Development background.  This is a onsite ( office based ) position in Horsham, PA

Primary Responsibilities:

  • Provide scalable solutions for handling large data volumes (Terabytes of data)
  • Gather and analyze business requirements and convert them to design specifications, unit test plans, and troubleshoot client issues
  • Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions
  • Accountability in deliverables with the ability to work independently
  • Maintaining the data warehousing environment as part of a rotational production support role
  • Contribute to strategic projects, ETL design and architecture, performance tuning activities, etc. 
  • Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives.
  • Perform and own data analysis during development and report findings to the team.
  • Involved in production support activities as needed.
  • Engage within a scrum team and actively contribute to the team on a daily basis.
  • Understand and follow our internal change management process.
  • Be a part of and contribute to ETL code reviews with the goal of ensuring standardization, best practices, consistency, and quality.
  • Provide ETL design, development and unit testing estimations based on business
  • Develop design specifications, unit test plans, and troubleshoot client issues.
  • Work with a diverse project team with an emphasis on repeatable processes and technical documentation  

Required Qualifications:
  • Bachelor’s degree or higher
  • Informatica expertise with an emphasis on working with a diverse set of sources and targets, implementing auditing, error trapping/tracking, reusability and restartablilty, and the ability to troubleshoot and performance tune Informatica mappings, sessions and workflows
  • 5+ years’ PL/SQL or T-SQL experience
  • 5 + year’s ETL and Database tuning experience
  • 5 + years’ experience with Data Warehousing principles with hands on experience with slowly changing dimensions and fact tables
  • Detailed work ethics around analysis and coding practices
  • Provide scalable solutions for handling large data volumes (Terabytes of data)
  • Develop design specifications, unit test plans, and troubleshoot client issues
  • Accountability in deliverables with the ability to work independently - required
  • Excellent communications and collaboration skills
  • Ability to work in a fast paced environment and meet deadlines
Preferred Qualifications:
  • Informatica PowerExchange CDC experience on Oracle, DB2, and Mainframe
  • Exadata, Teradata, or Netezza Appliance database expertise
  • Experience working in an Agile Methodology environment
Careers at UnitedHealthcare Medicare & Retirement.
The Boomer generation is the fastest growing market segment in health care. And we are the largest business in the nation dedicated to serving their unique health and well-being needs. Up for the challenge of a lifetime? Join a team of the best and the brightest to find bold new ways to proactively improve the health and quality of life of these 9 million customers. You'll find a wealth of dynamic opportunities to grow and develop as we work together to heal and strengthen our health care system. Ready? It's time 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:  ETL, ETL Developer, Lead ETL, Senior ETL, Informatica, PL/SQL, PowerExchange, Agile, UnitedHealth Group, UHG, UnitedHealthcare, UHC, Horsham, PA, Pennsylvania

Apply Now