Lead Software Engineer

Sun LifeWaterloo, ON
$90,000 - $140,000Hybrid

About The Position

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.

Requirements

  • 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

Responsibilities

  • 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.

Benefits

  • 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service