PL/SQL Developer

IRIS Business Services Ltd; Navi Mumbai; On-site; INR 600,000 - 1,200,000; Full time

Job summary

IRIS RegTech Solutions Limited in Mumbai is seeking a skilled PL/SQL Developer to join our data engineering team. You will design and optimize PL/SQL packages, procedures, and ETL workflows across core banking and regulatory reporting systems.

You will handle large volumes of banking data, perform SQL tuning, UNIX shell scripting, and collaborate with business analysts to ensure data accuracy, reconciliation, and compliance. A Bachelor’s degree in computer science is required.

Qualifications

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.

Responsibilities

• Design, develop, and optimize complex PL/SQL packages, procedures, functions, and triggers for data processing and transformation.
• Build and maintain ETL workflows to extract data from core banking systems and load into data warehouses / staging / reporting layers.
• Work with large volumes of banking transactional data, ensuring accuracy, integrity, and performance.
• Perform SQL query tuning and optimize PL/SQL code for performance in high-volume banking environments.
• Collaborate with business analysts and functional teams to understand banking data requirements (e.g., core banking, regulatory/statutory reporting, risk, compliance).
• Develop and maintain data validation, reconciliation, and error-handling routines within ETL pipelines.
• Support data migration activities between core banking systems and downstream applications/data marts.
• Write and maintain technical documentation for database objects, ETL jobs, and data flows.
• Troubleshoot production issues, perform root cause analysis, and implement fixes with minimal downtime.
• Work with version control tools and adhere to coding standards/best practices.

Skills

PL/SQL development

ETL tools

Banking/FS domain

Relational DB concepts

SQL performance tuning

UNIX/Linux shell scripting

Data warehousing concepts

Analytical problem solving

Communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

ODI

Informatica

SSIS

Talend

Job description

IRIS RegTech Solutions Limited (formerly IRIS Business Services Limited) is India’s only listed RegTech SaaS provider, pioneering technology-driven regulatory and supervisory compliance solutions worldwide. Headquartered in Mumbai with subsidiaries across the U.S., Singapore, Malaysia, and Italy, IRIS serves over 30 regulators and 6,500 enterprises in 55 countries. The company is an active member of XBRL jurisdictions, including XBRL International, XBRL India, XBRL Europe, XBRL South Africa, and XBRL US. Recognized globally for its award-winning SupTech, RegTech, and DataTech platforms - including IRIS iFile, IRIS iDEAL®, IRIS CARBON®, and IRIS MSME - IRIS helps banking and financial sector regulators digitize supervision and enterprises and achieve seamless financial and ESG reporting.

IRIS’ products are XII certified, ISO 27001:13 and SSAE 18 (SOC 1 Type 2) certified, ensuring industry leading security and reliability. Combined with deep expertise in XBRL, AI, and ML, IRIS delivers robust, high-quality regulatory data infrastructure that enhances transparency, strengthens governance, and supports sustainable growth across the financial ecosystem.

We are looking for a skilled PL/SQL Developer with strong scripting and ETL experience to join our team working on data automation across core banking, data warehousing, and regulatory reporting systems. You'll be working at the intersection of banking data infrastructure and compliance, building pipelines that move and transform data from source banking systems into regulatory-ready formats.

Key Responsibilities

• Design, develop, and optimize complex PL/SQL packages, procedures, functions, and triggers for data processing and transformation.
• Build and maintain ETL workflows to extract data from core banking systems and load into data warehouses / staging / reporting layers.
• Work with large volumes of banking transactional data, ensuring accuracy, integrity, and performance.
• Perform SQL query tuning and optimize PL/SQL code for performance in high-volume banking environments.
• Collaborate with business analysts and functional teams to understand banking data requirements (e.g., core banking, regulatory/statutory reporting, risk, compliance).
• Develop and maintain data validation, reconciliation, and error-handling routines within ETL pipelines.
• Support data migration activities between core banking systems and downstream applications/data marts.
• Write and maintain technical documentation for database objects, ETL jobs, and data flows.
• Troubleshoot production issues, perform root cause analysis, and implement fixes with minimal downtime.
• Work with version control tools and adhere to coding standards/best practices.

Required Skills & Qualifications

• 2-4 years of hands-on experience in Oracle PL/SQL development (procedures, functions, packages, cursors, triggers, exception handling).
• Practical experience with ETL tools/concepts (e.g., Oracle Data Integrator (ODI), Informatica, SSIS, Talend, or custom PL/SQL-based ETL).
• Prior experience working in the Banking/Financial Services domain — exposure to core banking systems (e.g., Finastra, Flexcube, Finacle, TCS BaNCS, or similar) is a strong plus.
• Strong understanding of relational database concepts, data modeling, and normalization.
• Experience with SQL performance tuning (explain plans, indexing strategies, partitioning).
• Familiarity with UNIX/Linux shell scripting for job scheduling and automation.
• Understanding of data warehousing concepts (staging, ODS, dimensional modeling) is a plus.
• Good analytical, debugging, and problem-solving skills.
• Strong communication skills and ability to work with cross-functional/business teams.

Educational Qualification

Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.