Lead Software Engineer (Informatica Cloud)

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues – experts in their fields – who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients – who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Role Summary

We are looking for an experienced and high-performing individual with a strong ETL and Informatica IDMC background to join the Corporate Risk team. In this role you will be exposed to major projects, a variety of assignments, problem solving, maintaining stability, performing technical implementations, coordinate activities and work together with team members and vendors to maintain, enhance and continuous improvements on the supported systems. The successful candidate must be willing to work in a fast-paced dynamic environment, can work effectively with other IT teams and business partners to implement IT solutions that meet business needs.

What will you do

• As a member of the RDR (Risk Data Repository) project and operations support team, interface with other engineers, vendors, infrastructure teams, business analysts, testing specialists, and business partners to deliver high quality solutions and maintain a stable, high performing data management and application environments
• Design, develop, and implement IDMC Data Integrations, Data Profiling, and Data Quality working with on‑prem and (AWS) cloud sources and targets
• Monitor, troubleshoot and optimize performance of IDMC processes to ensure they run smoothly and efficiently
• Collaborate with stakeholders to understand business requirements and translate them into technical solution
• Maintain essential IT infrastructure, including operating systems, security tools, software, and hardware.
• Identify and participate in improvement, system renewal, stability, upgrade, and Disaster Recovery projects.
• Take complete ownership of work assignments and ensure the successful completion of assigned tasks
• Participate in various review processes (e.g., Business Requirements, Test plans, Design reviews, etc.) to gain a solid understanding of the applications and provide input into the various deliverables
• Provide coaching to other team members on tools, techniques, and processes
• This role includes on‑call and after‑hours support on a team rotation basis.

What do you need to succeed

• 7+ years of progressive information technology experience with full application development life cycle and systems integration experience using ETL tools (Informatica PowerCenter/IDMC)
• 2+ years hands on experience with IDMC and its various modules (i.e., IDQ/CDQ), utilizing REST API and managing intricate data structures
• Experience with IDMC Advanced CDI or CDI‑Elastic (for handling large volume data processing)
• 3+ years hands on experience with AWS services (EC2 instances, S3 buckets, RDS, Bedrock, Sagemaker, S3, Lambda, Glue, API gateway, Amazon Quick/Quick Sight etc.)
• Bachelor’s degree or diploma in computer science / engineering or equivalent
• Experience in (Autosys) scheduling
• Strong Knowledge of SQL and relational database concepts
• Experience working with complex technical environments, multiple IT platforms (Linux/Unix, Cloud, Windows)
• Knowledge of ITIL standards and best practices
• Experience with the DevOps tools (Git, Bitbucket, Jenkins, CDD, Ansible)
• Strong communication and analytical skills, including conceptual, requirements interpretation, solution creation and problem‑solving abilities

What’s in it for you

• We’re honoured to be recognized as a 2026 Best Workplace in Canada by Great Place to Work Canada.
• We are thrilled to be recognized by Excellence Canada with their top‑level certification, the Canada Order of Excellence for Mental Health at Work®, for prioritizing employee well‑being, fostering a positive work culture, and achieving excellence in mental health.
• Wellness programs that support the three pillars of your health – mental, physical, and financial
• The opportunity to move along a variety of career paths with amazing networking potential.
• As a hybrid organization, you and your leader use business and client needs to choose where you work, at home or in the office.

Notes / Unique requirements

• Occasional travel between Toronto and Waterloo
• This role requires Reliability Security Clearance. In addition to a law enforcement inquiry and a credit check, as part of your application, the Government of Canada will ask if you lived or travelled outside of Canada for 6‑consecutive months during the last 5 years, and you must account for all activities during this time.
• Must be able to satisfactorily complete applicable background checks prior to the start date and during employment, in accordance with Sun Life’s policies and practices.

Salary Range: 90,000/90 000 - 140,000/140 000

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds. Persons with disabilities who need accommodation in the application process, or those needing job postings in an alternative format, may e‑mail a request to View email address on ca.talent.com.