Apply on Employer Site

MedImpact Healthcare Systems, Inc. · 1 month ago

Software Engineer III, Informatica

San Diego, CA

Full-time

Hybrid

Senior Level

$96K/yr - $170K/yr

6+ years exp

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join their team. The Informatica Developer will work within the Application Development & Support team to provide complex software programming for new software, production support, and maintenance for existing software.

Health CarePharmaceutical

No H1B

Responsibilities

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

Qualification

Oracle PL/SQLInformatica PowerCenterETL workflowsUnix/Linux shell scriptingDatabase performance tuningData modelingSQL optimizationProblem-solvingCommunication skillsCollaboration

Required

BS/BA and 6+ years' experience or equivalent combination of education and experience, and 2 years of SME in respective areas

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

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

Preferred

Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful

Benefits

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

Company

MedImpact Healthcare Systems, Inc.

Glassdoor2.8

MedImpact is the nation’s largest independent health solutions and pharmacy benefit company, serving commercial health plans, government programs, self insured/employer groups, and millions of consumers.

Founded in 1989

San Diego, California, USA

1001-5000 employees