MedImpact-posted 12 days ago
Full-time • Mid Level
Onsite • San Diego, CA
5,001-10,000 employees

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 Essential Duties and Responsibilities include the following. Other duties may be assigned. Design, develop, and maintain ETL workflows and mappings in Informatica PowerCenter Develop and optimize complex Oracle PL/SQL procedures, functions, triggers, and packages Build and maintain 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 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 production issues related to data processing and performance 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 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.

  • Design, develop, and maintain ETL workflows and mappings in Informatica PowerCenter
  • Develop and optimize complex Oracle PL/SQL procedures, functions, triggers, and packages
  • Build and maintain 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
  • 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 production issues related to data processing and performance
  • 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
  • BS/BA and 8+ years’ experience or equivalent combination of education and experience, and 4 years of SME in respective areas
  • Eight (8) plus years of experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter and B2B Data Exchange products
  • Hands-on experience with PowerCenter Mapplets, Mappings, Workflows, and Applications
  • Experience in PowerCenter Developer using Data Transformation and Developer Studio tools
  • Strong ETL and data modelling experience, including schema design, query optimization, and performance tuning
  • Eight (8) plus years of experience in development of database processes using Oracle SQL, PL/SQL in Oracle 12c and Unix shell scripting
  • 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
  • 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
  • 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
  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service