Software Engineer Lead - ETL Informatica

Minneapolis, Minnesota
Dec 12, 2018
Dec 14, 2018
Employment Status
Full Time

Health Care that Starts with You!

Join a truly mission-driven organization! Independent, nonprofit UCare is recognized as one of the Minnesota's leading health plans. We provide more than 225,000 members across Minnesota and western Wisconsin with the health coverage plans and services they need to maintain and improve their health. The innovative coverage we create makes a difference for Medicare-eligible individuals, individuals and families enrolled in Minnesota Health Care Programs, such as MinnesotaCare and Medical Assistance, and disabled adults with special health care needs. UCare is growing in size, membership, products, geographic coverage, and employees. We're an organization that's going places. Be part of a team that cares about you, be part of UCare.


At UCare, we deliver high-quality health coverage and services to help members of all ages maintain and improve their health. It's a big job that takes innovative ideas, strategic partnerships, and a commitment to doing the right thing. Above all, it takes a compassionate team that is dedicated to making a real difference in the lives of our members and our communities.


Working at UCare is more than just a career; it's a mission. A mission that defines us as professionals, unites us as an organization, and shapes how we interact with our members and each other. Our values of integrity, community, quality, flexibility, and respect permeate every aspect of our organization - from who we are and how we act, to what we do and how we do it. We owe our continued success to our employees who proudly embody our mission and values in everything they do.


This position is responsible leading the design, delivery, support, and maintenance of data integration solutions—primarily using Informatica PowerCenter.  Lead design, develop, implement, test, analyze, and support data integration software applications. This includes researching, designing, documenting, and modifying software specifications throughout the production life cycle. Analyze and debug in a timely and accurate fashion and provide status reports where required.  May require after hours support. Serve as a resource to other software engineers and answer questions and guide as required.  Be willing to be the final say for the group when needed if decisions can't be decided upon as a group.


·Collaborate with project leads, business analysts, end users and third party contacts to design, develop, implement and test software applications.


·Collaborate with other engineers, analysts, and designers in conceptualizing and developing new data integration programs and applications.


·Plan phases of software development life cycle (SDLC) for a variety of projects.


·Assist in the preparation and documentation of software requirements and specifications.


·Research, finalize, consult, and document business, functional, technical requirements.


·Recommend, schedule, and perform software improvements and upgrades.


·Write, translate, and code software programs and applications according to specifications.


·Run and monitor software performance tests on new and existing programs for the purposes of correcting errors, increasing performance through SQL tuning, and general debugging.


·Perform critical analysis of QA results and deliver updates to ensure excellent data quality.


·Generate statistics and prepare and write reports for management and/or team members on the status of the programming process.


·Write programming scripts to enhance functionality and/or appearance of company Web site and/or related Web applications as necessary.


·Collaborate and lead other members of the IT department to assist in resolving problems associated with the integration of Informatica with schedulers, databases, file transport protocols, and external trading partners. 


·Create Automic (UC4) jobs and schedule per the requirements of each project.


·Be involved in meeting for upcoming projects to determine ETL need on the projects.


·Coordinate all ETL documentation.


·Perform Informatica Administrator duties.


·Other projects and duties as assigned.


Bachelor's degree in Computer Science preferred; demonstrated experience may be considered in lieu of degree. 

Required Experience

Seven years of experience designing and building enterprise integration solutions using Informatica PowerCenter. Experience in developing ETL design guidelines, standards and procedures to ensure a manageable and a low support-footprint ETL infrastructure and architecture. Provide analysis and design reviews with development peers to avoid duplication and inefficiency.  Experience mentoring other ETL developers.

Preferred Experience

Minimum of 2 years working on Agile teams.


UCare is proud to be a recognized Star Tribune Top Workplace for the 9th consecutive year. As a part of our collaborative team, you'll experience the rewards that come with helping others and seeing the positive results of your hard work. We value and respect each individual's ideas and contributions, and give you the freedom to grow both personally and professionally. We are centrally located, and offer onsite education, equipment and wellness resources, a myriad of volunteer activities, and a number of other rewards. If you're looking for a welcoming environment that celebrates what you have to offer, helps you build on your strengths, and gives you the opportunity to truly make a difference, we invite you to apply.


As an Equal Opportunity/Affirmative Action Employer, we welcome and employ a diverse employee group committed to meeting the needs of UCare, our members, and the communities we serve.






Enter a highly collaborative environment where people are truly engaged, and feedback is valued. You'll enjoy a competitive salary and benefits, as well as a host of other perks, including a nationally recognized wellness program, and a bright, open, award-winning office space in Northeast Minneapolis just minutes from major freeways and retail centers. At UCare, we welcome and employ a diverse employee group committed to meeting the needs of UCare, our members, and the communities we serve.

Similar jobs

Similar jobs