Sign In
 [New User? Sign Up]
Mobile Version

SSIS Developer - Eden Prairie, MN

UnitedHealth Group


Location:
Eden Prairie, MN
Date:
09/05/2017
2017-09-052017-10-04
Job Code:
1739379
Apply on the Company Site
  •  
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details


SSIS Developer - Eden Prairie, MN(Job Number:710669)
Description

No industry is moving faster than health care. And no organization is better positioned to lead health care forward. We need attention to every detail with an eye for the points no one has considered. The rewards for performance are significant. You'll help improve the health of millions. And you'll do your life's best work.(sm)

 

The primary role of the developer is to take the design and technical specifications and develop effective and high quality technical solutions that meet the business requirements. The technical domain of the ETL Developer includes understanding Data Integration (DI) best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, DI development, performance tuning and support system testing.

 

**Typical travel scenario - Travel is based on project size, scope and location. Projects may require up to 80% travel. If travel is required , typical travel schedule is out early Monday, back late Thursday with telecommute from home on Friday.

 

Primary Responsibilities:

  • Ability to work closely with Business Analysts and SMEs to understand business requirements
  • Perform Data profiling and analysis of structured and unstructured data
  • Define new interface layouts  (custom or healthcare industry standards)  for integrating  into the Data warehouse
  • Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
  • Validate the ETL design and ensure that technical specifications are complete, consistent, concise, and achievable.
  • Create ETL Processes and reports using Microsoft SQL Server Suite (SSIS, SSRS, SSAS) and other data integration tools like Data Stage, Informatica, Ab initio
  • Develop ETL code as per the technical specifications and business requirements according to the established designs
  • Familiarity with reporting tools like Cognos, Business Objects , Microstrategy
  • Proficient in  leading and managing the development resources
  • Create Process Flows using Visio 
  • Create Dimensional models using ERWIN or other data modeling tools
  • Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
  • Performance tuning of ETL processes
  • Well versed with Automation tools like Tivoli Maestro
  • Ability to work in a  matrixed  team environment with distributed responsibility across different teams
  • Ability to work  and deliver in a very high paced environment with limited information at times to support business needs
  • Experienced in delegating and coordinating development and testing in an onsite-offshore delivery model
  • Experienced in  working with sensitive/de-identified data environments
  • Experience in working with  encrypted and secure data transfers
  • Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.
  • Participate in ETL architecture design reviews.
  • Conduct ETL unit testing and code reviews.
  • Participate in system and integration test; identifies and remedies solution defects.
  • Create other technical artifacts needed for project implementation

Job Bus Advisory & Tech Cnsltng
Primary Location US-MN-Eden Prairie
Other Location United States
Organization Ops Consulting
Schedule Full-time
Number of Openings 4
Apply on the Company Site

UnitedHealth Group is the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone.

Powered By

Featured Jobs[ View All ]

Featured Employers [ View All ]