Data Engineer (Informatica/AWS)

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. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

We're looking for a motivated, early-career professional to join our dynamic Data Engineering team. This is an excellent opportunity to grow your skills while working with cutting-edge cloud technologies, building data integration solutions for BI reporting, analytics, MDM, and application integration using Informatica IDMC and AWS-based platforms.

What You'll Do?

• Design, build, and deploy data integration pipelines in our AWS/Informatica Cloud environment
• Develop and maintain data applications and reusable frameworks under the guidance of senior team members
• Participate in all phases of the development lifecycle - from design through implementation
• Translate business requirements into technical solutions using modern, cloud-based technologies
• Collaborate with cross-functional teams to deliver high-quality data solutions
• Contribute to agile development practices and continuous improvement initiatives
• Learn and grow through hands-on experience with enterprise-scale data systems

What You Need to Succeed?

Required:

• 2-5 years of experience developing data solutions using ETL tools (Prefer Informatica ETL Tool) or data integration platforms
• Strong SQL skills - comfortable writing queries and working with relational databases
• Experience creating data transformations and working with data pipelines
• Understanding of data modeling concepts and data structures
• Analytical mindset with problem-solving abilities
• Eagerness to learn new technologies and grow your technical expertise
• Strong collaboration skills and willingness to work in a team environment
• Ability to work effectively in an Agile/SDLC environment

Nice to Have Skills (We'll Help You Develop These!):

• Experience with Informatica Power Center, IDMC, or similar ETL platforms
• Exposure to MDM solutions (matching, merging, data quality, cleansing, profiling)
• Experience with AWS cloud services, AWS Glue, Step Functions, Lambda Functions
• Experience or knowledge with Agentic AI and Agentic AI frameworks I.E OpenAI Agents SDK, CrewAI, LangChain, LangGraph, MCP, RAG, Vector Databases, ML, DL.
• Knowledge of production change management processes
• Understanding of data warehouse design principles
• Experience or knowledge of CI/CD pipelines and DevOps practices for data engineering workflows
• Experience or knowledge of Jenkins for automated build and deployment processes
• Familiarity with version control systems such as GitHub or Bitbucket for collaborative development
• Experience or knowledge of NoSQL technologies or platforms such as MongoDB,  DynamoDB, DocumentDB
• Experience working with various data formats and storage technologies including AWS S3, Parquet, Avro, JSON, CSV, ORC, and XML for data ingestion, transformation, and storage

What Makes This Role Great for Early-Career Professionals

• Mentorship & Growth: Work alongside experienced data engineers who are committed to helping you develop your skills
• Modern Technology Stack: Gain hands-on experience with industry-leading tools (Informatica IDMC, AWS)
• Diverse Initiatives: Exposure to various data challenges including analytics, MDM, and enterprise integrations
• Career Development: Clear path for advancement as you build expertise
• Collaborative Environment: Multi-site, global team with opportunities to learn from diverse perspectives

What’s in it for you?

• Canada Order of Excellence for Mental Health at Work® certification from Excellence Canada. Sun Life is one of only four companies in Canada to ever receive this certification – 2024
• Top Work Places® for Remote Work – Monster Canada - 2024
• Great Place to Work® Certified for Most Trusted Executive Team in Canada – 2024 and 2023
• Great Place to Work® Certified for Best Workplaces in Canada – 2024 and 2022
• Great Place to Work® Certified for Best Workplaces for Women in Canada - 2024
• Great Place to Work® Certified for Best Workplaces in Ontario - 2023
• Great Place to Work® Certified in Canada in Financial Services and Insurance – 2023
• Flexible hybrid work model. #LI-Hybrid
• Pension, stock and savings programs to help build and enhance your future financial security
• Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
• A friendly, collaborative and inclusive culture
• Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.
• Competitive salary and bonus structure influenced by market range data
• The opportunity to move along a variety of career paths with amazing networking potential

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 [email protected].

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! Several work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

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: