Sr. Lead- PLSQL

We are looking for a skilled Oracle PL/SQL Developer to join our team, working closely with Developers, Team Leads, and Architects. The ideal candidate will have strong problem-solving skills, hands-on experience with PL/SQL, and the ability to work flexibly across multiple tasks.

Roles & Responsibilities:

1. Development & Technical Design

• Understand functional requirements from Functional Specification Documents (FSD) and prepare technical specifications.
• Design and develop PL/SQL programs including Tables, Views, Triggers, Functions, Procedures, Packages, Collections, and Arrays.
• Write dynamic SQL queries and fine-tune queries for optimal performance.
• Handle exceptions and implement Autonomous Transactions where needed.

2. Oracle Expertise

• Hands-on experience with Oracle predefined packages:
• DBMS_SQL, DBMS_PROFILER, UTL_FILE, UTL_HTTP, DBMS_DDL, DBMS_JOB, DBMS_LOB, DBMS_OUTPUT, DBMS_REFRESH, DBMS_UTILITY.
• Perform data extraction from CSV, Excel, and text files.
• Knowledge of Data Dictionary and advanced PL/SQL concepts.

3. Reporting & Tools

• Experience with Jasper Reports is a plus.
• Hands-on experience with Oracle Forms and Reports is an added advantage.

Qualifications:

• Strong experience in real-time Oracle PL/SQL development.
• Knowledge of database design, indexing, and query optimization.
• Ability to work collaboratively with teams in a dynamic environment.

What We Aim For:

• To be the leading provider of BFSI and ERP software products in APAC, Middle East, Africa, and the US.
• Deliver world-class software products built on the latest technologies.
• Provide best-in-class customer service, understanding local nuances and domain-specific requirements.
• Attract high-quality talent and be an employer of choice.