Exemption Status:

United States of America (Exempt)

$95,717 - $132,808 - $169,898

“Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors.  A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.”

This position is not eligible for Sponsorship.

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team!

Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.

At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!

Job Description

Summary

The Informatica Developer works within the Application Development & Support team to provide complex software programming for new software, production support and maintenance for existing software, as well as ad-hoc support of key departmental initiatives which drive business functions.  The Informatica Developer receives general instructions on new projects and works autonomously to complete deliverables.

The position works within one of the following areas within the Application Development team: IT Finance, Government Programs & Services, Enterprise Data Warehouse, Data Exchange, Formulary Master Process, Pharmacy Network, Performance Engineering, Portals or Formulary Process Automation.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Design, develop, and maintain advanced Oracle PL/SQL packages, procedures, functions, triggers, and views
• Develop, enhance, and maintain ETL workflows using Informatica PowerCenter, Informatica Cloud, or similar ETL tools
• Build and maintain Unix/Linux shell scripts for data automation, monitoring, and job scheduling
• Gains a thorough understanding of functional requirements for new software requests
• Works with Business Systems Analysts to understand and clarify software requirements and translate into working software
• Designs, develops and performs testing of software to meet functional requirements
• Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products
• Partners with software team in the development of software engineering processes and best practices
• Works to identify and resolves technical or product problems
• Participates in software project meetings and provides status reports
• Translates technical designs into working software
• Maintains existing applications by enhancing software and troubleshooting issues
• Collaborates with team members and partners with others as needed to ensure successful completion of assigned software development tasks
• Ensures data quality, performance, and scalability of ETL processes and database solutions
• Participates in code reviews, release management, and process improvement efforts. Troubleshoot and resolve complex SQL/PLSQL issues, including performance tuning, query optimization, and execution plan analysis.
• Contributes to best practices, documentation, and continuous improvement initiatives within the team
• Applies software engineering and Object-Oriented Design principles in creating UML diagrams and technical design documents for software components
• Partners with team members and technical project lead to ensure component design fits in with the overall solution
• Adopts new techniques and technologies
• Initiates attendance at job related training to keep skills current; maintains current understanding of the industry’s best practices
• Assists with mentoring and training of less experienced IT staff members

Supervisory Responsibilities        

No supervisory responsibilities