About this role
Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them.
Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself.
At Canada Life, we believe in improving the financial and physical well-being of all the Canadians we serve. The foundation of our strategy is to put the customer at the center of everything we do.
Are you a creative problem solver? Do you like to be challenged? Do you enjoy learning? Are you a team player? Do you like looking for opportunities to automate and improve processes? If you answered yes to all these questions, then we would love to talk to you.
The Lead ETL Developer is responsible for designing, developing, and supporting ETL solutions that meet our business partner’s expectations. You will be a member of a centralized team responsible for building and supporting integration solutions.
ESSENTIAL FUNCTIONS:
Design, develop and maintain ETL workflows using Informatica PowerCenter and or IICS
Extract, transform and load data from diverse sources (Mainframes, RDMS, APIs) into desired target data sources
Performs production support on ETL jobs as required.
Focuses on continually improving and automating integration points and processes.
Collaborates with data architects, business analysts and BI developers to translate requirements into technical solutions
Contributes to the standards and guidelines used to support the ETL application environment.
Performance tuning of end-to-end integration processes across the integration platform.
Identifies opportunity for reuse of objects across Data Warehouse/Mart & ETL BI Solutions.
Operational Support rotation
EDUCATION:
University or College education in Computer Science, Computer Engineering or a related field, or equivalent combination of education and experience. Interest in or active pursuit of related industry certifications are considered an asset.
EXPERIENCE:
Solid programming experience with Python and SQL
Minimum 7+ years’ experience in an Enterprise IT environment with practical experience in application development in data integration (ETL) using Informatica/IDMC
Advanced experience with Ab Initio and Syncsort DMX ETL is an asset.
Experience working with the following database technologies
MS SQL Server, Oracle, DB2 Midrange/Mainframe
Experience in technical specification design - Proven experience in designing and building operational integrations and standard data warehousing objects (e.g. type-2 dimensions, aggregations, star schema, etc.)
Solid working knowledge of other software developer toolsets.
Superior analytical and problem-solving skills.
Proven ability to develop and maintain collaborative business relationships.
Effective planning and organizational skills with the ability to adapt to change and perform effectively under pressure.
Experience supporting the Ab Initio platform is an asset.
Experience with BMC Control-M scheduling software is an asset.
Experience with Change Data Capture (CDC) tools are an asset.
Strong knowledge in service management including incident and change management procedures.
We are an equal opportunity employer with a commitment to diversity. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.
Other facts
About Empower
At Empower, we’ve always been guided by strong values with a focus on helping people achieve the financial freedom they deserve.
It’s been an incredible journey so far, but our story is just getting started.
From the very beginning, we’ve prided ourselves on putting our customers first in everything we do — which will never change. The genesis of Empower dates back to 1891, when our parent company was founded as an insurance firm on the Canadian prairie. After more than a century of expansion and a profound evolution of service offerings, the modern iteration of Empower was launched in 2014. Our past is a big part of who we are as a business, but we continue to invest heavily in our current principles and future endeavors.
Today, as the second-largest recordkeeper¹ in the U.S. and a comprehensive wealth management leader, we proudly serve more than 19 million individuals and over 88,000 different organizations.²
With a constant commitment to growth, innovation and technology, we are fully dedicated to transforming the lives of all Americans. Our personalized tools and solutions are aimed at helping everyone improve their financial confidence so they can pursue their passions and reach their unique goals.
That’s our promise.
------------------------
Disclosures: https://www.empower.com/social-media/
¹Pension & Investments DC Recordkeeper Survey (2024). Ranking measured by total number of participants as of December 2023.
²As of March 31, 2025.
What you'll do
- The Lead ETL Developer is responsible for designing, developing, and supporting ETL solutions that meet business partner expectations. This role involves collaborating with various teams to translate requirements into technical solutions and improving integration processes.
Ready to join Empower?
Take the next step in your career journey