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:
Job Description
Specialist – Development SQL, SSIS or Informatica
Are you ready to shine?
At Sun Life, we empower you to be your most brilliant self.
Who we are?
Sun Life is a leading financial services company with history of 150+ years that helps our clients achieve lifetime financial security and live healthier lives.
We serve millions in Canada, the U.S., Asia, the U.K., and other parts of the world. We have a network of Sun Life advisors, third-party partners, and other distributors. Through them, we’re helping set our clients free to live their lives their way, from now through retirement. We’re working hard to support their wellness and health management goals, too. That way, they can enjoy what matters most to them. And that’s anything from running a marathon to helping their grandchildren learn to ride a bike.
To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including:
- Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance.
- Investments. Mutual funds, segregated funds, annuities, and guaranteed investment products
- Advice. Financial planning and retirement planning services
- Asset management. Pooled funds, institutional portfolios, and pension funds
With innovative technology, a strong distribution network and long-standing relationships with some of the world’s largest employers, we are today providing financial security to millions of people globally.
Sun Life is a leading financial services company that helps our clients achieve lifetime financial security and live healthier lives, with strong insurance, asset management, investments, and financial advice portfolios. At Sun Life, our asset management business draws on the talent and experience of professionals from around the globe.
Sun Life Global Solutions (SLGS)
Established in the Philippines in 1991 and in India in 2006, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission.
Drawing on our collaborative and inclusive culture, we are reckoned as a ‘Great Place to Work’, ‘Top 100 Best Places to Work for Women’ and stand among the ‘Top 11 Global Business Services Companies’ across India and the Philippines.
The technology function at Sun Life Global Solutions is geared towards growing our existing business, deepening our client understanding, managing new-age technology systems, and demonstrating thought leadership. We are committed to building greater domain expertise and engineering ability, delivering end to end solutions for our clients, and taking a lead in intelligent automation. Tech services at Sun Life Global Solutions have evolved in areas such as application development and management, Support, Testing, Digital, Data Engineering and Analytics, Infrastructure Services and Project Management.
We are constantly expanding our strength in Information technology and are looking for fresh talents who can bring ideas and values aligning with our Digital strategy.
Our Client Impact strategy is motivated by the need to create an inclusive culture, empowered by highly engaged people. We are entering a new world that focuses on doing purpose driven work. The kind that fills your day with excitement and determination, because when you love what you do, it never feels like work. We want to create an environment where you feel empowered to act and are surrounded by people who challenge you, support you and inspire you to become the best version of yourself. As an employer, we not only want to attract top talent, but we want you to have the best Sun Life Experience.
We strive to Shine Together, Make Life Brighter & Shape the Future!
What will you do?
- Develop and maintain database objects like complex SQL functions, procedures, packages, etc.
- Build SQL queries and procedures for data maintenance/fixes, analysis of application and system data and ad hoc reporting. Optimize SQL queries for performance and scalability.
- Provide Production support for batch processes and troubleshoot issues in a time-sensitive environment. Monitor and manage job schedules using Autosys.
- Collaborate with business analysts and stakeholders to understand requirements and ensure robust solutions.
- Document solutions and procedures for support and knowledge sharing.
- Role Definition:
- Problem- solving: Ability to identify, analyze and resolve some technical issues
- Communications: Ability to communicate effectively both orally and in writing
- Compute Proficiency: Working knowledge of computer hardware, software, and internet technologies
- Organization and Time Management: Ability to plan, organize and manage time effectively
- Teamwork: Ability to work effectively with others and contribute to a team environment
- Adaptability: Willingness to learn on the job new technologies and skills - must be curious
- TECHNICAL SKILLS
Must Have Skills:
- Strong knowledge of RDBMS and 5+ years of hands-on experience with SQL and SQL server Integration Services (SSIS) or Informatica.
- Strong logical reasoning and critical thinking. Should be able to develop algorithms for solving business problems.
- Strong debugging and analytical skills in real time incident resolution.
- Proficient in SQL optimization and database performance tuning.
- Proficiency in analyzing and debugging an issue.
- Batch production support experience in enterprise environments
- Basic knowledge of Shell scripting and Unix or Linux OS.
.
Good to Have Skills:
- Familiarity with PL/SQL, AWS, Snowflake.
- Experience in supporting IT systems pertaining to Insurance domain
- Exposure to Autosys or equivalent job schedulers.
- Experience working in Agile/Scrum environments.
Our engineering career framework helps our engineers to understand the scope, collaborative reach, and levers for impact at every job role and defines the key behaviors and deliverables specific to one’s role and team and plan their career with Sun Life.
Your scope of work / key responsibilities:
- Collaborates effectively
- Drives collaboration among team members in his/ her function
- Presenting a supportive, united front when appropriate.
- Communicates Confidently
- Communicates crisply and candidly.
- Communicates effectively across audiences (reporting managers, peers, business partners)
- Balances talking and listening to foster candid dialogue.
- Focuses on the Customer
- Raises concerns and recommends potential solutions for those processes that negatively impact the customer service experience or the fair treatment of customers.
- Helps employees understand the impact of their work on the customer/ client.
- Organizes own work to meet agreed upon deadlines.
- Focuses on surfacing underlying customer issues / concerns and identifying root causes.
- Takes Accountability
- Takes steps to understand decision making processes and procedures – uses this understanding in developing work plans
- Escalating issues or redirecting enquiries in a timely and efficient fashion.
- Following up with customers when we say we will and delivering on our commitments.
- Works under general supervision on day-to-day matters.
- Understands our Business
- Enhances understanding about the business of SLF (e.g. products and services, org structure, key competitors)
- Understands how his/her role relates to the Business Unit/ Function's objectives
Technical/Education Requirements:
- Bachelor’s degree in computer science, Engineering, or related field
- Oracle certifications (nice to have).
Schedule: 1:30 PM to 10:00 PM
Job Category:
IT - Application DevelopmentPosting End Date:
19/11/2026Skills Required
- Bachelor's degree in Computer Science, Engineering, or a related field
- 5+ years of hands-on experience with SQL and SQL Server Integration Services or Informatica
- Strong knowledge of relational database management systems
- Strong logical reasoning and critical thinking skills
- Strong debugging and analytical skills for real-time incident resolution
- Proficiency in SQL optimization and database performance tuning
- Experience analyzing and debugging technical issues
- Batch production support experience in enterprise environments
- Basic knowledge of Shell scripting and Unix or Linux operating systems
- Familiarity with PL/SQL
- Familiarity with AWS
- Familiarity with Snowflake
- Experience supporting IT systems in the insurance domain
- Exposure to Autosys or equivalent job schedulers
- Experience working in Agile or Scrum environments
- Oracle certification
What We Do
A UK company, Sun Life Financial of Canada is focused on building excellent customer service by offering the highest levels of customer care. We have been serving customers in the UK for over 100 years








.png)