Data Engineer (Informatica/AWS)

Experience: 2 to 5 years

Location: Toronto, Ontario, Canada

Skills: Informatica ETL Tool, SQL, data transformations, data pipelines, data modeling, Agile, AWS, AWS Glue, Step Functions, Lambda Functions, Agentic AI, OpenAI Agents SDK, CrewAI, LangChain, LangGraph, MCP, RAG, Vector Databases, ML, DL, CI/CD pipelines, DevOps, Jenkins, GitHub, Bitbucket, MongoDB, DynamoDB, DocumentDB, AWS S3, Parquet, Avro, JSON, CSV, ORC, XML

Job Description
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.

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)
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: Transparent 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 Outstanding 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: 65,000/65 000 - 105,000/105 000
Job Category: IT - Technology Services
Posting End Date: 19/03/2026

📌 Data Engineer (Informatica/AWS) (Mumbai)
🏢 Sun Life Financial
📍 Mumbai