Previous Job
Previous
ETL Developer
Ref No.: 18-00081
Location: Bloomington, Minnesota
Position Type:Contract
Start Date / End Date: 09/24/2018 to 03/24/2019
 SENIOR ETL DEVELOPER – 4 openings

Position Description
This position will be working within Information Technology (IT) under the general direction of Enterprise Data Officer. This position will be dedicated to developing data integration solutions leveraging enterprise integration platform (Informatica). This position will partner with other team members in creating data integration reference architecture, design patterns and integration solutions to address data and integration needs for the Enterprise Data Assets including Integrated Data Stores / Consumption layer / Data Hub / Enterprise Data Warehouse. This position will work with IT staff, Business Users, Data Stewards, Project Managers / Scrum Masters, Data Architects, QA analysts and others. The ideal candidate for this position should be self-motivated, capable of working with minimal supervision, technically capable, and possess the ability to communicate complex technical matters with business user, and has background in the design and implementation of Enterprise Data Assets for Health Care Organization at a technical level.
·Perform complex technical activities and guidance in the design and implementation of the Enterprise Data Asset Integration.
·Contribute to building strategy, roadmap and implementation plan for creation of enterprise data assets (EDW, Data Hub, Data Stores, etc.) from integration perspective.
·Follow established principles of IT Mission, Vision and Values.
·Adhere to established policies and procedures including Enterprise Architecture principles, Security standards,, design / development methodologies when defining, designing and implementing solutions.
·Responsible for designing, coding, testing and documenting Informatica ETL as per the standards and best practices.
·Work with matrix team and contribute to best practices with industry knowledge and introduce efficiency, reusable objects, maplets, parallelism, ETL versus ELT, etc.
·Assist with sizing and estimation of ETL design and development. Provide realistic estimates and meet commitment with reasonable accommodation with hand set an example.
·Involve in test plan development (unit, system, QA, UAT etc.)
·Define Implementation strategy and plan and own execution of implementation including post implementation task like production validation.
·Provide on-call support and production support to systems in production.
·Assist in continuous improvement efforts and enhancing project team methodology and performance.
·Other duties as assigned.

Education
Bachelor's degree in Computer Science, Engineering or Information Systems degree; demonstrated experience may be considered in lieu of degree.

Required Experience
7-8 years of extensive Informatica experience with 5 - 8 years of overall Data Integration experience in leading ETL tools like Ab Initio, Data Services, Data Stage, Pentaho. 3-5 experience of strong integration background on Data Warehouse, Operational Data Stores, Data Analytics, Integration concepts (ETL, ELT, ESB), parallel / pipeline processing. Proficiency in data analysis, SQL queries and tuning is a must.

Preferred Experience
Knowledge on Informatica products, platform administration, test data management, business glossary, metadata management and experience working with Health Care Payer data.