The Senior ETL Developer plays a critical role in designing, developing, and maintaining enterprise-grade data integration solutions that support analytics, reporting, and operational decision-making. In this role, you will leverage deep expertise in Informatica, SQL, and cloud-based data platforms to build scalable, reliable ETL pipelines. You will collaborate closely with business partners, architects, and cross-functional technology teams to integrate data across core enterprise systems while ensuring data quality, performance, and compliance. This position supports complex data initiatives within a regulated financial services environment.
Position Responsibilities: - Design, develop, and maintain complex ETL solutions using Informatica PowerCenter and/or IICS to support enterprise data integration and reporting needs.
- Build and optimize data pipelines, transformations, and workflows aligned to data warehousing and integration best practices.
- Partner with application and business teams to integrate data from Salesforce and other enterprise platforms.
- Ensure data quality, reliability, and performance through monitoring, troubleshooting, root cause analysis, and optimization of ETL processes.
- Contribute to cloud based data initiatives and support continuous improvement of data engineering standards, documentation, and delivery practices.
Required Qualifications:- 7-10+ years of overall experience in software and data engineering within large enterprise environments.
- 5+ years of hands on experience with Informatica (PowerCenter and/or IICS), including complex ETL design and development.
- Strong expertise in ETL architecture, data warehousing concepts, data integration patterns, and advanced SQL with relational databases.
- Practical experience integrating data with Salesforce and other enterprise systems, with working knowledge of Python for data processing or automation.
- Experience working with cloud platforms and modern data ecosystems (Azure preferred), along with strong communication and cross functional collaboration skills.
Preferred Qualifications:- Familiarity with middleware and integration technologies and integration Patterns .
- Prior experience in Life Insurance, Long-Term Care, Annuities, or other regulated financial services environments.
- Experience supporting enterprise data modernization or cloud migration initiatives.
- Exposure to data governance, data quality, or regulatory reporting requirements.
- Ability to mentor junior developers and contribute to technical design discussions
When you join our team:- We'll empower you to learn and grow the career you want.
- We'll recognize and support you in a flexible environment where well-being and inclusion are more than just words.
- As part of our global team, we'll support you in shaping the future you want to see.
#LI-Hybrid
The role being advertised is an existing vacancy.
Referenced Salary LocationToronto, Ontario
Working ArrangementHybrid
Salary range is expected to be between$113,000.00 CAD - $163,000.00 CAD
Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact [redacted] for the salary range for your location.
Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [redacted] for more information about U.S.-specific paid time off provisions.
