Software Developer Specialist (informatica Power Center & Snowflake Iceberg Experience)

Intact Insurance

Toronto, Canada
Base: 118,700 - 145,100; bonus/equity: annual bonu...
Hybrid
Informatica power center
Snowflake iceberg experience
Design and evolve data platform
Design, develop, and optimize ingestion and transformation pipelines (batch and real-time)

Job Summary

  • Design, develop, and optimize ingestion and transformation pipelines (batch and real-time).
  • Improve reliability, performance, and governance (security, cataloging, quality, costs).
  • Provide technical guidance to the team, promote best practices (code reviews, standards, tests, documentation), and drive change.

Matching Summary

Design, develop, and optimize ingestion and transformation pipelines (batch and real-time).

Salary

Base: 118,700 - 145,100; Bonus/Equity: Annual bonus target up to double target, ESPP with 50% match; Benefits: Flexible work, telemedicine, wellness account, pension plan

Skills & Requirements

Must-have

  • Informatica Power Center
  • Snowflake Iceberg experience
  • design and evolve data platform
  • design, develop, optimize pipelines
  • model analytical data
  • Cloud migration experience

Nice-to-have

  • continuous learning culture
  • Agile culture (Scrum/Kanban)
  • high standards and craftsmanship
  • technical leadership

Key Requirements

  • 10 years in software/data engineering
  • ETL/ELT and large-scale data warehousing
  • Proficient in data modeling
  • Excellent SQL skills and optimization
  • Hands-on experience with Snowflake
  • Strong knowledge of Unix and Cloud ecosystem
  • Bachelor’s degree in computer science/software engineering or equivalent

Work Rights

Eligible to work in Canada

Tailored Resume

Cover Letter