Informatica Developer Jobs in Ontario (NOW HIRING)

Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times.

Our employee promise represents Intact's commitment to you in exchange for living our Values, striving to do your best work, being open to change and investing in your career. In return, we promise to provide support, opportunities and performance-led financial rewards at a workplace where you can shape the future, win as a team and grow with us.

Pay at Intact is about much more than just salary.

• Flexible work arrangements and a hybrid work model

• Possibility to purchase up to 5 extra days off per year

• Multiple benefits offered to support physical and mental wellbeing, including telemedicine, Wellness account and much more

• Share plan & other savings: up to 12% of salary or even more (ask how you could earn guaranteed income for life)

Salary range (but not limited to):

Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance):

As part of our commitment to Win As A Team, we share our success with employees through our annual bonus plan and Employee Share Purchase Plan (ESPP) - with Intact matching 50% of your net shares.

Our pension offerings provide flexibility and long-term security for our employees beyond their careers. We are one of the few companies offering the opportunity to receive guaranteed income for life via our defined benefit pension plan.

Salary for the candidate will be determined taking into consideration a number of factors including: experience, skills, qualifications, anticipated contribution to role, internal equity, etc. The salary range presented above is based on a 35-hour workweek and would represent a majority of different candidate profiles. However, we encourage candidates who may fall outside of this range to apply as well.

About the role

About Us

We're IntacLab-the tech arm of Intact-where we turn bold ideas into real-world impact. Our team spans product, design, data, AI, and engineering, and we build digital products that are simple to use, powerful under the hood, and focused on outcomes.

We believe in autonomy, high standards, and genuine teamwork. You'll find a culture that values continuous learning, clear thinking, and craftsmanship. If you join us, you'll work on high-stakes projects with a supportive team that challenges you to do your best.

This year, we're rolling out several strategic initiatives to build on what we've achieved and push innovation even further. It's a great time to come aboard.

The Role

As a specialist software developer, you bring strong modeling experience, excellent analytical skills, and technical leadership. You design and evolve our data platform, which is used on a large scale for business decisions and high-impact innovative initiatives.

Technology Environment

Informatica Power Center experience, Snowflake Iceberg experience Cloud migration experience, Snowflake (SQL), S3, Git, Unix, Visual Studio Code, Control-M. Always on the lookout for new tools, we test and approve those that could improve our daily operations.

Your Daily Mission

• Integrated into a multidisciplinary team, you balance autonomy with collective work to deliver user-centered solutions.

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

• Model robust analytical data (star, Data Vault, bronze/silver/gold) for BI and data science.

• Improve reliability, performance, and governance (security, cataloging, quality, costs).

• Collaborate with analysts, testers, architects, and stakeholders to translate needs into solutions.

• Provide technical guidance to the team, promote best practices (code reviews, standards, tests, documentation), and drive change.

• Contribute to an Agile culture (Scrum/Kanban) focused on value and incremental delivery.

Desired Profile

• Bachelor's degree in computer science/software engineering or equivalent.

• 10 years in software/data engineering, including ETL/ELT and large-scale data warehousing.

• Proficient in data modeling and analytical architectures.

• Excellent SQL skills and optimization; hands-on experience with Snowflake.

• Strong knowledge of Unix and the Cloud ecosystem (preferably AWS).

• Python and Java (a plus).

• Experience with CI/CD, automated data testing, quality/observability.

• Basic understanding of AI/machine learning (advantageous for collaborating with Data Science).

• Bilinguism (FR-EN) - For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.

• No Canadian work experience required, but must have authorization to work in Canada.

• Eligible to work in Canada; no prior Canadian work experience required.

Ready to shape the future of data at IntactLab? Send your application and join a team where your expertise has a direct impact.

#LI-Hybrid

We are an equal opportunity employer

At Intact, our Value of respect is founded on seeing diversity as a strength. We strive to create an accessible workplace where employees feel valued, included and encouraged to share their unique perspectives.

We encourage applications from individuals who are members of equity-deserving groups, including but not limited to women, Indigenous peoples, persons with disabilities, Black people, and members of the 2SLGBTQI+ community.

As part of Intact's commitment to reconciliation, we acknowledge that we work, meet and travel across the land currently called Canada, originally inhabited by First Nations, Metis and Inuit people. This history extends through many centuries and continues to evolve today.

We have policies to ensure equal access and participation for people with disabilities, including providing workplace adjustments (accommodations). A copy of applicable policies is available on request.

If we can provide a specific adjustment to make the recruitment process more accessible for you, please let us know when we reach out about a job opportunity. We'll work with you to meet your needs.

Learn more about our recruitment process and your candidate journey here.

Please note that Intact does not provide sponsorship or other support for immigration-related matters including but not limited to employer-specific closed work permits. Candidates must be eligible to work in Canada from the anticipated start date and throughout their employment and are solely responsible for maintaining their work eligibility.

If you are an employee of Intact or belairdirect, please apply for this role on Internal Career Site.