Description

Lead the analysis and design of Informatica-based cloud ETL architecture for the Enterprise Data Transformation Program, building pipelines from front-end systems to a Snowflake and Azure Cloud Data Lake.

This role is on-site.

Responsibilities

• Design Informatica IDMC cloud ETL architecture, documenting source-to-target mappings and transformation rules.
• Build operational and analytical pipelines connecting downstream systems to Snowflake and Azure.
• Liaise between data teams and technical groups including security, infrastructure, and BU IT.
• Collaborate with product development teams to define scalable architectural requirements.
• Partner with development teams to resolve complex design and implementation issues.

Required Skills

• 7+ years of experience in Data Integration Development or Data Analysis.
• 5+ years of experience within ETL Architecture.
• Expertise in Data Warehousing environments utilizing ETL.
• Hands-on experience with Informatica IDMC (CDI, CAI, CMI, CDIE).
• Proficiency in SQL and relational database tools.
• Experience with Snowflake and Azure Cloud platforms.

Preferred Skills

• Agile delivery experience.
• Commercial Insurance or Claims domain experience.

Key Skills

Education

Any graduate