Senior Software Engineer- PlSQL

**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 - PLSQL**

**Years of Experience**: 6 to 10 Years

**Location**: Cairo, Egypt

**Role Summary**:
**What will you do?**
- Design, develop, and maintain complex **PL/SQL packages, procedures, functions, triggers**, and **cursors**.
- Implement **autonomous transactions**, **exception handling**, and ensure optimal error logging and recovery.
- Work with **external tables**, **materialized views**, and **schedulers** for automated data processes.
- Perform **data extraction, data migration, and data loading** activities using optimized scripts and tools.
- Conduct **performance tuning** of PL/SQL code, queries, and database operations.
- Integrate and manipulate **XML and JSON** data formats using Oracle libraries and tools.
- Design and generate **BIRT reports**, ensuring accuracy and performance.
- Work on **analytical functions** and complex queries for reporting and data analysis.
- Debug and troubleshoot PL/SQL code using advanced techniques and tools.
- Collaborate with DBAs to execute database-level operations and functions, including maintenance and optimization.
- Follow best practices for version control, code documentation, and deployment.

**What skills required?**
- 6+ years of hands-on experience in PL/SQL development in Oracle environments.
- Strong knowledge and working experience with:

- Procedures, Functions, Packages, Triggers
- Autonomous Transactions
- External Tables, Materialized Views
- Oracle Schedulers
- Cursors, Exception Handling
- Data Extraction, Migration, Loading
- BIRT Reports (Business Intelligence Reporting Tool)
- Analytical SQL Functions
- XML and JSON data types and Oracle libraries
- Performance Tuning and Debugging Techniques
- DBA-level utilities and database operations
- Good understanding of relational database concepts, data normalization, and design.
- Strong problem-solving and analytical skills.
- Ability to work independently as well as collaboratively in a team environment.

**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**:
We work as one, **Collaborate**without boundaries, and win together.

We work with **Uncompromising Integrity** and **Accountability.**

**Customer** is at the core of all that we do.

We are **Diverse and Inclusive**. We treat our people, our customers and our wider community with **Respect and Care.**

We **Innovate**, we **Excel**and we **Grow Together**.

We **Give Back** to our communities through our business and our people.

We take **Pride** in all that we do and together we **Enjoy** the journey