SQL Senior Application Developer – Optum (Eden Prairie, MN)

UnitedHealth Group Incorporated

We currently have several immediate openings in our Eden Prairie, MN location for SQL Senior Application Developers. In this exciting role, you will participate in the systems development life cycle for new development, enhancements and maintenance projects in Data Warehouse/Data Analytics environment. 

 

As a member of the Delivery Management team, you will lead development project teams to design, develop and deploy ETL software needed to support a variety of business needs. The position will report to a resource manager, but will be matrixed to project managers for completion of project activity.

 

This role is expected to lead both onsite and offshore teams with a full accountability of delivery and meet client commitments.

 

Responsibilities:

• Research, evaluate, identify alternative approaches to support development needs
• Recommend, design and code efficient and effective solutions for challenging problems for medium to large work efforts of medium to high complexity
• Comply with standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments
• Demonstrate collaborative skills working within a project team of diverse skills
• Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment
• Act as a Project Development Lead with one or more developers matrixed for the completion of the project
• Provide technical over sight to multiple development initiatives.
• Provide guidance and direction to less-seasoned staff
• Conduct technical trainings to broader technical audience
• Present and socialize business segment services and capabilities to senior leadership

Success Factors:

• Ability to deliver functionality in two or more programming languages within a single development environment
• Ability to create high complexity detailed technical design specifications
• Ability to act as project technical lead for high complexity projects
• Ability to act as a lead developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer
• Ability to lead walk though of design documents and provide technical leadership over programming team
• Strong analytical and technical aptitude
• An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
• Effective communications with all levels of internal and external customers and staff, including issue resolution, negotiation of project related priorities, and completion dates
  

Requirements:

• 8+ years of experience working in a high volume DataStage environment
• 8+ years of experience in developing Oracle procedures, functions, packages, database triggers and troubleshooting using PL/SQL and SQL
• 6+ years of experience in implementing advanced features of Oracle like
• Autonomous Transactions, Ref-Cursors, PL/SQL Tables, Table Partitioning, V-Arrays, Materialized Views, Merge statements,SQL*Loader, External Tables, Pipelined/Table functions, Result Cache, With Clause and Multi Table Inserts
• 6+ years of experience troubleshooting performance issues, SQL tuning is a must
• Evaluate and understand a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
• Develop ETL code meeting  100 percent of technical specifications and business requirements according to the established designs
• 8+ years experience in applications systems analysis and/or development and/or support
• 8+ years experience with multiple file structures and programming languages
• 8+ years experience with high level technical phases of applications systems analysis and programming activities
• Thorough understanding of technological infrastructure and how it relates to projects is a plus
• 8+ years experience with Oracle, SQL Server in Unix environment
• 8+ years experience with MS Office (Outlook, Excel and Word)
• Experience with any SSH client
• Highly experience with complex shell scripting using Unix, and PERL and crontab
• Healthcare domain background is a plus
• Clinical domain experience is a plus
• Knowledge with HIE formats 837 i&p, HL7/ADT is a plus
• Experience in converting specifications to programs and data mapping in an
• ETL DataStage environment. In addition ETL Pentaho knowledge is a plus
• Provide High Level and Low Level Architecture Solution/Design to the project
  Strong knowledge in data base technologies Teradata, Oracle, SQL Server, DB2, Netezza and GreenPlum
• 4+ years of experience with TWS/d job scheduler automation tool

Assets:

• Deep understanding of Hadoop stack such as Hadoop (Java)
• AIX
• Multiple programming languages (Perl, Shell script, C++)
• UDB/EEE
• Autosys or equivalent job scheduling tool experience
• UnitedHealth Group experience
  

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

Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.




UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment. In addition, employees in certain positions are subject to random drug testing.

See full job details and apply at employer site