Senior Software Developer – Data Warehouse / ETL

Mandate Description

We are looking for a Senior Software Developer specializing in Data Integration (ETL/ELT) to contribute to the evolution of data platforms within a large organization in the insurance industry.

The consultant will be involved in integrating data from the company's underwriting and quoting systems into enterprise data warehouses, as well as supporting the migration from Oracle to Snowflake.

The role involves close collaboration with IT, Business Intelligence (BI), and various business teams to develop, optimize, and maintain robust data integration and transformation solutions.

Key Responsibilities

• Design, develop, test, and deploy ETL/ELT data integration solutions.

• Contribute to the migration of data and processes from Oracle to Snowflake.

• Develop and maintain data pipelines using Informatica PowerCenter and IICS.

• Design and optimize Data Vault and dimensional data models.

• Ensure data quality, performance, and reliability.

• Collaborate with BI analysts, developers, and deployment teams.

• Document development activities and provide technical production support.

• Estimate development efforts and contribute to project planning and delivery.

Required Technical Skills

• 5–10+ years of experience in data integration and Data Warehouse environments.

• Strong expertise in ETL/ELT techniques and methodologies.

• Solid hands-on experience with Oracle and PL/SQL.

• Experience with Informatica PowerCenter and IICS.

• Knowledge of Snowflake and data migration environments.

• Experience with Data Vault and dimensional data modeling.

• Knowledge of WhereScape is considered an asset.

• Experience in the property and casualty (P&C) insurance industry is considered an asset.

Ideal Candidate Profile

• Autonomous, versatile, and solution-oriented developer.

• Ability to work effectively in complex technical environments.

• Strong communication and collaboration skills.

• Bilingual in French and English.

• Bachelor's degree in Computer Science, Software Engineering, or equivalent education and experience.

• Availability to provide rotating Level 2 production support, typically at month-end.