Lead Software Engineer (Informatica Cloud)

Job Description

:

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 Workplaces in Canada by Great Place to Work® Canada.
• 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 need 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.