Informatica Developer

Insight Global; San Diego (CA); On-site; USD 110,000 - 150,000; Full time

Job summary

Insight Global is seeking an Informatica Developer with strong backend data engineering experience to support multiple ongoing data integration projects in the healthcare domain. The role focuses on building, optimizing, and maintaining data pipelines across internal applications, with emphasis on performance and reliability.

The ideal candidate operates independently, manages multiple priorities, and contributes to system improvements.

Qualifications

• 5-7+ years of experience in Informatica development.
• Strong SQL and PL/SQL development skills.
• Proficiency in Python scripting.
• Experience with Linux/Unix environments.
• Healthcare data experience and CMS regulations knowledge.
• Experience with Informatica PowerCenter and Developer Suite.

Responsibilities

• Develop and maintain ETL processes using Informatica PowerCenter and related developer tools.
• Write and optimize SQL and PL/SQL queries within Oracle databases.
• Use Python scripting for automation and data processing tasks.
• Monitor workflows and troubleshoot performance issues and failures.
• Analyze Informatica architecture to identify memory constraints and bottlenecks.
• Recommend and implement improvements to workflows and performance.
• Support multiple concurrent data integration projects and enhancements.
• Convert healthcare data files into structured formats such as CSV or flat files.
• Support upgrades and integration of in-house applications.

Job description

Job Description

We are seeking an Informatica Developer with strong backend data engineering experience to support multiple ongoing data integration projects. This role focuses on building, optimizing, and maintaining data pipelines that process healthcare data across internal applications. The ideal candidate works independently, handles multiple priorities, and actively improves system performance and reliability.

Key Responsibilities

• Develop and maintain ETL processes using Informatica PowerCenter and related developer tools


• Write and optimize SQL and PL/SQL queries within Oracle databases


• Use Python scripting for automation and data processing tasks


• Monitor workflows and troubleshoot performance issues and failures


• Analyze Informatica architecture to identify memory constraints and system bottlenecks


• Recommend and implement improvements to workflows, mappings, and performance


• Support multiple concurrent data integration projects and enhancements


• Convert healthcare industry data files into structured formats such as CSV or flat files


• Support upgrades and integration of in-house applications

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 5-7+ years of experience in Informatica development


• Strong experience with Informatica PowerCenter and Developer Suite


• Strong SQL and PL/SQL development skills


• Experience with Oracle databases, exposure to PostgreSQL is helpful


• Proficiency in Python scripting


• Experience working in Linux or Unix environments


• Ability to troubleshoot performance issues and optimize data workflows


• Proven ability to work independently with minimal supervision


• Experience working with healthcare data and industry standards


• Familiarity with CMS regulations and healthcare data formats such as HL7 or EDI


• Experience supporting data conversions and transformation libraries


• Background in client onboarding and workflow customization


• Experience with Informatica Intelligent Data Management Cloud is a plus