Description

Support the Enterprise Data Transformation Program by building operational and analytical pipelines from front-end and downstream systems to a Snowflake and Azure Cloud Data Lake.

Responsibilities

• Lead the analysis and design of Informatica-based cloud ETL architecture using IDMC.
• Document source-to-target mappings, including data movement and transformation rules.
• Act as a liaison between data teams and technical groups such as security, infrastructure, and BU IT.
• Collaborate with product development teams to develop scalable architectural requirements.
• Partner with development teams to resolve complex design and development issues.

Required Skills

• 7+ years of experience in Data Integration Development or Data Analysis.
• 5+ years of experience within ETL Architecture.
• Adept experience in Data Warehousing environments utilizing ETL.
• Exposure to Informatica IDMC (CDI, CAI, CMI, CDIE).
• Proficiency in SQL and relational database tools.
• Experience with Snowflake and Azure Cloud.
• Bachelor's degree in IT, Computer Science, Business, or equivalent work experience.

Preferred Skills

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

Key Skills

Education

Any graduate