Senior Software Engineer - Oracle Forms & Reports

Azentio Software

About Azentio Azentio Software incorporated in 2020 at Singapore, has been carved out of 3i Infotech, Candela Labs, Beyontec Technologies and Path Solutions. Azentio Software provides mission critical, vertical-specific software products for customers in banking, financial services and insurance verticals and includes key products such as KASTLE (Universal Lending), AMLOCK (Anti-Money Laundering & Compliance software suite), iMal, PREMIA Astra (Core Insurance software), ORION (Enterprise Resource Planning software) and MFUND Plus (Asset Management platform). Azentio has over 800 customers in more than 60 countries, with a team of over 2,300 employees across offices in 12 countries (and growing) globally and is wholly owned by Funds advised by Apax Partners Azentio offers a comprehensive range of products – serving core operations to modern digital needs – for the financial services industry. Our deep domain knowledge and solutions in financial services extend across insurance, retail and corporate lending, Islamic Banking, anti-money laundering and asset management. In addition, Azentio proudly serves mid-market enterprises across the Middle East, Africa, Asia Pacific, and India with a comprehensive ERP solution At Azentio, we believe that growth is a continuous journey. We believe that each step of this journey must be taken by committing to excellence - excellence in our products, our services, our ideas, and our people
Job Title: Senior Software Engineer - Oracle Forms & Reports Years of Experience: 5 to 7 years Location: Chennai
Role Summary: We are seeking a skilled Oracle Forms and Reports Developer who brings a wealth of experience in Oracle D2K, SQL, PL/SQL, and enterprise application development. The successful candidate will demonstrate a proven track record in designing, developing, enhancing, and maintaining robust business applications utilising Oracle Forms (versions 10g/11g/12c/14c) and Oracle Reports. This role requires hands-on expertise in building and optimising database-driven solutions, with the ability to translate complex business requirements into effective technical solutions
The ideal applicant should be adept at developing and fine-tuning PL/SQL packages, procedures, functions, triggers, and views, ensuring efficient and reliable performance. Experience with performance tuning of PL/SQL code and SQL queries is essential. The candidate should also possess solid skills in debugging and troubleshooting application issues across Oracle Forms, Reports, and PL/SQL programmes
Additionally, the role demands proficiency in migrating and upgrading legacy Oracle Forms/Reports applications to newer platforms (such as 12c/14c), as well as designing and modifying data models, tables, indexes, and other key database objects. Familiarity with integrating Oracle Forms and Reports with external systems (including Java components, web services, and CSV/XML outputs) will be highly valued. Effective collaboration with QA teams, Business Analysts, and other cross-functional stakeholders for system testing and user acceptance testing is also a critical aspect of this position
What will you do?

Responsible for designing, developing, and maintaining applications utilizing Oracle Forms (10g/11g/12c/14c) and Oracle Reports.
Develop and optimize PL/SQL packages, procedures, functions, triggers, and views in alignment with application requirements.
Analyze business requirements and translate them into comprehensive technical specifications.
Perform performance tuning of PL/SQL code and SQL queries to ensure optimal efficiency.
Diagnose and resolve issues within Oracle Forms, Reports, and PL/SQL programs.
Execute migration and upgrade activities for Oracle Forms/Reports applications to current versions (12c/14c).
Create and revise data models, tables, indexes, materialized views, and other database objects as needed.
Integrate Oracle Forms & Reports seamlessly with external systems, including Java components, web services, and CSV/XML outputs.
Collaborate effectively with QA, Business Analysts, and cross-functional teams to facilitate system testing and user acceptance testing (UAT).
Deliver production support, conduct root cause analysis, and carry out ongoing performance optimization.

What skills required?

5+ years of Oracle Forms and Reports development experience
Advanced skills in Oracle SQL and PL/SQL (triggers, packages, procedures, functions, query optimization)
Experience with Oracle Database versions 10g to 23ai
Strong grasp of database design, normalization, and data modeling
Skilled in debugging and troubleshooting PL/SQL
Familiar with deployment tools like SQL Developer and TOAD
Proficient with Unix/Linux scripts and automation
Comfortable working in Agile/Scrum teams
Insurance sector experience preferred
Experience with Premia or Beyontec products an advantage

What we Aim for? Azentio aims to be the leading provider of Banking, Financial Services & Insurance (BFSI) & Enterprise Resource Planning (ERP) software products in Asia Pacific, Middle East & Africa & United States. We will achieve this by:

Providing world class software products, built on the latest technologies.
Providing best in class customer service, built on a deep understanding of our domains and local nuances.
Being an employer of choice, attracting high quality talent.
Achieving top quartile growth and margins.

Azentio Core Values:

Customer centricity - Put customers at the center of everything
Innovation - Keep looking for a better way
Accountability - Own your work, end-to-end
Results - Focus on outcomes, not just effort