Informatica ETL Engineer – Worcester, MA

Codetech • Worcester, MA

10h

About The Position

We are seeking an experienced Informatica ETL contractor to partner with the Claims Business unit. The role focuses on evaluating operational challenges, auditing legacy data workflows, and designing robust, modern ETL frameworks. The engineer will collaborate closely with the database team and provide substantial production support to maintain high data reliability. Prior Property and Casualty insurance experience is not required; the role prioritizes strong technical skills in Informatica PowerCenter and Oracle, a dedicated support mindset, and excellent communication skills.

Requirements

• Advanced expertise in Informatica PowerCenter and/or IICS for building, managing, and troubleshooting data pipelines.
• Strong knowledge of Oracle databases, including complex SQL querying, PL/SQL, and query performance optimization.
• Extensive, proven experience in production support, incident management, and system maintenance.
• Demonstrated experience auditing legacy ETL flows and designing scalable framework patterns.
• Exceptional written and verbal communication skills, including the ability to explain technical issues clearly to business stakeholders.
• Strong cross-functional collaboration skills, particularly when working with database teams and business leads.

Responsibilities

• Investigate existing Claims data workflows to identify performance bottlenecks, operational pain points, and systemic errors.
• Propose, design, and implement end-to-end technical solutions that improve system efficiency and business capabilities.
• Audit and research current ETL processes and recommend operational improvements and architectural changes.
• Design, build, and deploy flexible, scalable, and reusable ETL frameworks.
• Collaborate with Database Engineering and DBA teams to align data models, optimize SQL queries, and streamline deployments.
• Provide hands-on production support, root-cause analysis, and performance tuning for critical ETL data pipelines.

What This Job Offers

• Education Level: No Education Listed