Job Description

SummaryAs a \xe2\x80\x8bProfessional 2 Product Developer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve - a community\'s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare\'s biggest challenges. Here are the details on this position.Your role in our missionEssential Job Functions

• Establishes and enforces data warehousing standards at the client site to meet client requirements and business needs.
• Determines data warehousing strategy; selects tools and techniques, including middleware, data cleansing tools, and/or data management systems to provide the solution to data and client issues and other matters of significance and to meet business needs.
• Conducts research into new data warehouse applications and determines viability for adoption.
• Evaluates existing subject areas stored in the data warehouse and determines where data should be stored.
• Assists in several components of the overall architecture of the data warehouse system.
• Documents tasks for end-user, technical, and managerial review to ensure high quality customer service.

Basic Qualifications

• Bachelor\'s degree in computer science, mathematics, or related field preferred
• Five+ years of experience in Informatica - Power Center 10.x, Power Exchange 10.x
• Design, develop and maintain robust Informatica PowerCenter mappings and workflows that process huge volumes of data across multiple platforms.
• Solid experience with performance tuning of Informatica processes in partitioned database environment.
• Advanced SQL, UNIX Shell Scripting skills, CICS and ability to write complex Stored Procedures.
• Strong knowledge and Hands-on experience in complex data transformations dealing with large volume of data.
• Experience working with COBOL/mainframe file structures using Power Exchange
• Design and develop DB2 Procedures and UNIX Shell Scripts for Data Import/Export, Data Conversions, Performance-tuning and work on migration of database jobs in between different environments.

Preference to candidates with:

• Healthcare domain (Medicaid or Medicare).
• Ability to start at short notice.

What you should expect in this role

• Hybrid Office environment.
• Fast-paced, challenging and rewarding work environment.
• Work life balance.
• Will require late evening work to overlap US work hours.

Gainwell Technologies