Job Description :
Need local MN candidates , available for in person interviews . H1B candidates can be submitted .



This assignment will go through December 31, 2019 and will be supporting our Data Management & Reporting program. We are going to be having one interview but it will be around 90 minutes long as there will be multiple people involved. We are targeting an April 15th start date.



The top three skills that the hiring leader is looking for are:

· Informatica PowerCenter development

· Data warehouse modeling experience

· SQL Server and Oracle database experience



Otherwise the JD covers what he is looking for.



SOFTWARE ENGINEER SENIOR – ETL INFORMATICA - (req1549)

Position Description

This position is responsible for the design, delivery, support, and maintenance of data integration solutions—primarily using Informatica PowerCenter. 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.

·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.

·Other projects and duties as assigned.

Education

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

Required Experience

Ten 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

Two years working on Agile teams.