Senior Etl Developer Jobs in Kitchener, ON (NOW HIRING)

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.

At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful.

When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

You are as unique as your background, experience, and point of view. At Sun Life, you will be encouraged, empowered, and challenged to be your best self. You will work with dynamic teams to deliver innovative technology solutions that help make life brighter for our clients.

We are looking for a Software Engineer to support the development, integration, and ongoing operations of enterprise applications within Corporate IT. This opportunity is open to both new graduates and early-career experienced professionals, with responsibilities scaled to experience level.

As a Software Engineer, you will contribute to the development, support, and ongoing enhancement of business-critical applications that support Sun Life's Anti-Money Laundering (AML) and Financial Crime technology platforms.

This role combines hands-on development with operational support responsibilities, with opportunities to contribute to cloud-based data integration, ETL/data pipelines, ETL job scheduling, and AML technology solutions in AWS environments.

What will you do?

• Develop, test, maintain, and support enterprise software applications, data integration solutions, and ETL/data pipelines under the guidance of senior engineers.
• Assist in analyzing business and technical requirements and contribute to solution discussions.
• Develop and maintain code, scripts, automation tools, and data integration components.
• Assist in the development, testing, scheduling, and monitoring of ETL/data pipelines using tools such as Informatica IDMC/IICS or AWS Glue, as applicable.
• Assist in scheduling, monitoring, and troubleshooting ETL/data integration jobs using technologies such as Informatica IDMC/IICS, AWS Glue, and related scheduling/orchestration tools to ensure timely and reliable processing of AML and Financial Crime data.
• Support applications and data pipelines that enable AML monitoring, financial crime investigations, regulatory reporting, and data management processes.
• Assist with data extraction, transformation, validation, reconciliation, and troubleshooting activities across relational databases and cloud data platforms.
• Participate in Agile ceremonies (sprint planning, stand-ups, retrospectives).
• Provide application support, including incident resolution and troubleshooting.
• Support system or project documentation.
• Collaborate with cross-functional teams and business stakeholders.
• Ensure adherence to Sun Life standards for security, compliance, and change management.
• Identify opportunities for automation, optimization, and continuous improvement.
• Participate in rotational on-call support as required for production systems

What do you need to succeed?

• Foundational knowledge of programming languages (e.g., Java, Python, C#, or similar).
• Basic understanding of SQL, relational databases, and data manipulation concepts.
• Hands-on experience with AWS cloud services through internships, co-op placements, academic projects, or professional experience.
• Experience working in AWS environments, including AWS Glue, S3, Lambda, CloudWatch, IAM, or related cloud data and integration services.
• Exposure to ETL/data integration concepts and experience with AWS Glue, Informatica IDMC/IICS, or similar data integration platforms through work, internship, co-op, or academic projects.
• Exposure to batch processing, job scheduling, workflow orchestration, or ETL monitoring concepts through coursework, internships, co-op placements, or projects.
• Exposure to data extraction, transformation, loading, validation, reconciliation, and error handling concepts.
• Exposure to scripting, automation, or API development through coursework or projects (e.g. PowerShell, shell scripting).
• Familiarity with software development lifecycle concepts (Agile, DevOps).
• Experience working with APIs, integrations, and enterprise systems is an asset.
• Familiarity with CI/CD pipelines, cloud platforms, or modern DevOps practices is an asset
• Strong problem-solving and analytical thinking.
• Willingness to learn and adapt to new technologies and tools.
• Effective communication and collaboration skills.
• Ability to work in a team-oriented environment.
• Attention to detail when validating data, documenting issues, and supporting production systems

What will be nice to have:

• Exposure to financial systems or enterprise applications.
• Knowledge of cloud technologies or modern data platforms.
• Interest in Anti-Money Laundering (AML), Financial Crime, compliance technology, regulatory reporting, or risk management solutions.
• Exposure through coursework, internships, or projects to financial services, compliance, risk, analytics, or regulatory technology domains.
• Academic, internship, or project experience with Informatica IDMC/IICS, AWS Glue, or similar ETL/data integration technologies.
• Exposure to scheduling and orchestration tools such as Informatica Taskflows, AWS Glue Workflows, and AutoSys.
• Experience building or supporting data pipelines, batch jobs, file processing, data quality checks, or data reconciliation processes.
• Familiarity with data warehousing concepts, dimensional modeling, or reporting/analytics platforms such as Power BI.
• Experience with automation frameworks or workflow tools.

What's in it for you?

• We're proud to be a Best Workplace for Hybrid Work by Great Place to Work Canada
• Be part of our continuous improvement journey in developing the next greatest digital enterprise experience that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives.
• Flexible Benefits from the day you join to meet the needs of you and your family.
• Pension, stock and savings programs to help build and enhance your future financial security.

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

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 thebrightside@sunlife.com.

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

Job Category:

Posting End Date: