Sun Life logo

Specialist Development

Sun Life
NewPosted yesterday

LOCATION

Bengaluru · Onsite

EXPERIENCE

5+ Years

TYPE

FullTime

SKILLS REQUIRED

SQLDebuggingPerformance OptimizationETL DevelopmentStored ProceduresRoot Cause Analysis

Job description

Overview

Develop, maintain and support SQL-based database objects and batch processes for Sun Life Global Solutions, with SQL, SSIS or Informatica as core skills.

What you'll do

  • Develop and maintain database objects such as complex SQL functions, procedures and packages.
  • 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.

What you'll need

  • Bachelor's degree in computer science, engineering, or a related field.
  • 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.
  • Ability 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.
  • Problem-solving: ability to identify, analyze and resolve some technical issues.
  • Communication: ability to communicate effectively both orally and in writing.
  • Computer 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.

Nice to have

  • Familiarity with PL/SQL, AWS, Snowflake.
  • Experience in supporting IT systems pertaining to the insurance domain.
  • Exposure to Autosys or equivalent job schedulers.
  • Experience working in Agile/Scrum environments.
  • Oracle certifications.

Details

  • Location: Sun Life Global Solutions Private Limited, Bengaluru.
  • Schedule: 1:30 PM to 10:00 PM.
  • Job category: IT - Application Development.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Specialist Development