Software Engineer III, Informatica at MedImpact Healthcare Systems, Inc.

San Diego, California, United States -

Full Time

Start Date

Immediate

Expiry Date

27 Feb, 26

Salary

169898.0

Posted On

29 Nov, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle PL/SQL, Informatica, ETL, Unix/Linux Shell Scripting, Data Automation, Software Engineering, Performance Tuning, Query Optimization, Data Warehousing, Relational Databases, Debugging, Technical Documentation, Customer Service, Collaboration, Problem Solving

Industry

Hospitals and Health Care

Description

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 Client Responsibilities This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Education and/or Experience BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas Computer Skills Six (6) plus years of experience in development of database processes using Oracle SQL, PL/SQL in Oracle 12c and Unix shell scripting Four (4) plus years of experience with Informatica or similar ETL/data integration platforms Hands-on experience with PowerCenter Mapplets, Mappings, Workflows, Applications or similar ETL tools Strong ETL and data modelling experience, including schema design, query optimization, and performance tuning Proficiency in Oracle PL/SQL, including advanced SQL, stored procedures, and performance optimization Familiarity with job scheduling tools such as UC4, Control-M, AutoSys, or similar Excellent knowledge of debugging, tuning and optimizing performance of database queries Strong experience with Unix/Linux Shell scripting for ETL orchestration and automation Solid understanding of relational databases, data warehousing concepts, and batch/real-time integration patterns Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications Strong proficiency in database interfacing and relational database management systems Excellent problem-solving, analytical, communication skills and collaboration with cross-functional teams Certificates, Licenses, Registrations Click or tap here to enter text. Other Skills and Abilities Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful Competencies To perform the job successfully, an individual should demonstrate the following competencies: Composure Decision Quality Organizational Agility Problem Solving Customer Focus Drive for Results Peer Relations Time Management Dealing with Ambiguity Learning on the Fly Political Savvy Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic). Work Location This position must work on-site at the San Diego Headquarters for purposes of providing adequate support to internal clients; being available for face-to-face interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as for facilitation of quick and effective decisions through collaboration with stakeholders. Remote work is not an option for these purposes. Working Hours This is an exempt level position requiring the incumbent to work the hours required to fully accomplish job responsibilities and reasonably meet deadlines for work deliverables. The individual must have the flexibility to work beyond traditional hours and be able to work nights, at weekends or on holidays as required. Work hours may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm. Travel This position requires no travel, however attendance maybe required at various local conferences and meetings. The Perks: Medical / Dental / Vision / Wellness Programs Paid Time Off / Company Paid Holidays Incentive Compensation 401K with Company match Life and Disability Insurance Tuition Reimbursement Employee Referral Bonus To explore all that MedImpact has to offer, and the greatness you can bring to our teams, please submit your resume to www.medimpact.com/careers MedImpact, is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego, California. Our solutions and services positively influence healthcare outcomes and expenditures, improving the position of our clients in the market. MedImpact offers high-value solutions to payers, providers and consumers of healthcare in the U.S. and foreign markets. Equal Opportunity Employer, Male/Female/Disabilities/Veterans OSHA/ADA: To perform this job successfully, the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. MedImpact was founded more than three decades ago by a pharmacist and independent drug store owner who saw firsthand how families struggled with the high cost of prescriptions, and how it impacted their lives, financial security, and health. So, he started MedImpact to make prescription benefits understandable and accessible. While we have grown to be one of the leading PBMs in America, we remain as committed to these principles today as we did when it all began.

Responsibilities

The Informatica Developer is responsible for complex software programming, production support, and maintenance of existing software. This role involves designing, developing, and maintaining ETL workflows and ensuring data quality and performance.