Software Engineer III, Informatica

MedImpact-posted 9 days ago
$95,717 - $169,898/Yr
Full-time • Mid Level
Onsite • San Diego, CA
5,001-10,000 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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
  • 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
  • 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
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Software Engineer Resume Examples
•
Software Engineer Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service