PL/SQL Developer

Iris Software Technologies; Turbhe; On-site; INR 600,000 - 1,200,000; Full time

Job summary

IRIS RegTech Solutions Limited, headquartered in Mumbai, is seeking a skilled PL/SQL Developer to join our data automation team. You will design and optimize PL/SQL packages and ETL workflows that transform data from core banking systems into regulatory-ready formats, supporting compliance and reporting across regulatory domains.

You will work with ODI, Informatica, SSIS, or Talend to move data into warehouses, ensure data integrity, and contribute to performance tuning in high-volume banking

Qualifications

• 2-4 years of Oracle PL/SQL development experience.
• Experience with ETL tools/concepts (ODI, Informatica, SSIS, Talend).
• Banking/Financial Services domain exposure is a strong plus.
• Strong relational DB concepts and data modeling knowledge.
• UNIX/Linux shell scripting for automation.
• Understanding of data warehousing concepts is a plus.

Responsibilities

• Design, develop, and optimize PL/SQL packages, procedures, functions, and triggers.
• Build and maintain ETL workflows to move data from core banking systems to data warehouses.
• Tune SQL queries and PL/SQL for high-volume banking environments.
• Collaborate with stakeholders to understand data requirements for regulatory reporting.
• Write and maintain technical documentation for DB objects and ETL processes.
• Troubleshoot production issues and perform root-cause analysis.

Skills

Oracle PL/SQL

ETL pipelines

SQL performance tuning

UNIX/Linux scripting

Data warehousing concepts

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.