Senior Software Developer – Data Warehouse / ETL

94939
Montreal, QC
Contract
Yesterday

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.

The pay range that the employer reasonably expects to pay for this position is between CA$80.00 and CA$100.00

Our voluntary benefits offering includes medical, dental, vision and retirement benefits.

This posting is for an existing vacancy.

If you believe this post to be fraudulent, please report by clicking here

Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.

We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.

Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!