P and C Developer | DevStudio Platform (Oracle PL/SQL)

Job Title:

Location:

About the Role:

P&C Developer

DevStudio Developer

Key Responsibilities:

• Design and develop

  Oracle database objects

  (PL/SQL Packages, Procedures, Triggers, Views, Materialized Views)
• Build and optimize

  complex database transactions

  and batch processes
• Deliver accurate

  work estimates

  for scope changes
• Write and maintain

  technical specifications

• Perform

  code reviews

  , support QA testing, and resolve issues
• Work on

  performance tuning and monitoring

  of SQL
• Troubleshoot production problems and provide effective solutions
  

Mandatory Skills:

• Strong experience in

  PL/SQL

  ,

  Oracle SQL

• Proven expertise in designing Oracle objects: Tables, Indexes, Procedures, Functions
  
• Experience with

  materialized views

  ,

  dynamic SQL

  , and

  performance tuning

• Solid understanding of

  data modeling

  ,

  database normalization

  , and

  schema design

Nice to Have:

• Familiarity with

  Majesco DevStudio

  or other

  low-code platforms

• Exposure to

  P&C insurance

  domain
• Good communication skills and ability to work independently
  

Why Join Us?

• Opportunity to work on innovative insurance platforms
  
• Collaborative, fast-paced work environment
  
• Career growth with mentorship and leadership opportunities