Senior PL/SQL & ETL Developer

IRIS RegTech Solutions Limited
Department Icon IT / Software Development & Related
Posted: 3 weeks ago
5-10 years
Turbhe, India
IT / Software Development & Related
work from office
Full Time
Closes 20 Dec 2026
Posted: 3 weeks ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Posted over 15 days ago, so the role may have closed. Confirm on the employer's page when you apply, or see similar jobs.

Job Description

About IRIS:

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.

Role overview

We are hiring a Senior PL/SQL & ETL Developer to design, build and tune high-volume Oracle data pipelines. You will own complex PL/SQL code, ETL workflows and data warehouse structures that feed business-critical and regulatory reports.
The role suits a hands-on engineer who writes performant, well-tested database code and can diagnose production issues end to end. You will work closely with business analysts, data architects and QA, and mentor junior developers.

Key responsibilities

    • Design, develop and maintain PL/SQL packages, stored procedures, functions and triggers for transactional and analytical workloads.
    • Build and enhance ETL workflows in Informatica PowerCenter, Talend or Oracle Data Integrator (ODI) to extract, transform and load data from multiple source systems.
    • Design multi-tier staging layers (landing, staging, curated) with robust data validation, reconciliation and reject-handling rules.
    • Implement dimensional models (star and snowflake schemas) and Slowly Changing Dimensions (Type 1, 2 and 3).
    • Load bulk and file-based data using SQL*Loader, External Tables and Oracle Data Pump (expdp/impdp).
    • Tune slow SQL and PL/SQL using Explain Plans, SQL Trace and TKPROF; apply partitioning, indexing, materialized views and hints where justified.
    • Process large data volumes efficiently with BULK COLLECT, FORALL and PL/SQL collections.
    • Build and maintain a centralized error-logging and exception-handling framework across database code.
    • Automate file handling, loads and housekeeping with Unix/Linux shell scripts (Bash/Korn).
    • Schedule and monitor batch jobs in Control-M, Autosys or DBMS_SCHEDULER, and resolve job failures within agreed SLAs.
    • Manage code in Git, GitLab or Bitbucket, follow branching and code-review standards, and support release deployments.
    • Provide L2/L3 production support, perform root-cause analysis and document fixes.
    • Prepare technical design documents, mapping specifications and unit test cases.
    • Review code and mentor junior developers on PL/SQL and ETL best practices.
Required technical skills

Core PL/SQL development
    • Advanced database objects: packages, stored procedures, functions and database triggers.
    • Performance collections: BULK COLLECT, FORALL, nested tables and associative arrays.
    • Dynamic SQL: EXECUTE IMMEDIATE and the DBMS_SQL package.
    • Error management: custom exception handling and centralized error-logging frameworks.
ETL & data warehousing
    • Enterprise ETL tools: Informatica PowerCenter, Talend or Oracle Data Integrator (ODI).
    • Data architecture: star schema, snowflake schema and Slowly Changing Dimensions (SCD Type 1/2/3).
    • Data ingestion: SQL*Loader, External Tables and Oracle Data Pump (expdp/impdp).
    • Data integrity: multi-tier staging design and complex data validation rules.
Performance tuning & optimization
    • Diagnostic tools: Explain Plans, TKPROF and SQL Trace analysis.
    • Database partitioning: range, list, hash and composite partitioning strategies.
    • Index optimization: B-Tree, Bitmap, function-based and partitioned indexes.
    • Execution tuning: materialized views (with query rewrite) and optimizer hints.
Automation & ecosystem
    • OS scripting: Unix/Linux shell scripting (Bash/Korn) for automation and file handling.
    • Job orchestration: Control-M, Autosys or Oracle DBMS_SCHEDULER.
    • Development tools: TOAD for Oracle, PL/SQL Developer or SQL Developer.
    • Code management: Git, GitLab or Bitbucket.
Qualifications & experience
    • Bachelor's or Master's degree in Computer Science, IT, Engineering or a related field (B.E./B.Tech/MCA/M.Sc.).
    • 6+ years of hands-on Oracle PL/SQL development on Oracle 12c, 19c or later.
    • 3+ years building production ETL pipelines on at least one enterprise ETL tool.
    • Proven delivery on data warehouse or reporting projects handling multi-million-row daily loads.
    • Track record of measurable SQL/PL/SQL performance improvements in production.
    • Experience working in Agile/Scrum teams with formal SDLC, code review and release processes.
Good to have
    • Banking or financial-services domain experience, especially regulatory reporting (e.g. RBI or SARB returns), risk or finance data marts.
    • Exposure to data quality, data lineage and audit-trail requirements in regulated environments.
    • Oracle certification (Oracle Database SQL Certified Associate, Oracle PL/SQL Developer Certified Professional).
    • Familiarity with CI/CD for database code (Liquibase, Flyway or Jenkins pipelines).
    • Working knowledge of Python for data processing or automation.
    • Exposure to cloud data platforms (OCI, AWS or Azure) or Oracle Autonomous Database.
Soft skills
    • Strong analytical and problem-solving skills, with a methodical approach to root-cause analysis.
    • Clear written and verbal communication with business, QA and infrastructure teams.
    • Ownership of deliverables, including timelines, quality and production stability.
    • Ability to work under tight reporting deadlines and handle on-call support when needed.
    • Willingness to mentor team members and share knowledge through code reviews and documentation.

Skills

SQLOraclePL/SQLPythonBashShell ScriptingSnowflakeETLData WarehousingInformaticaTalendAWSAzureJenkinsCI/CD

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

IRIS RegTech is a leading RegTech company helping organizations comply with regulatory requirements, data management, and filing solutions.

Similar Jobs

View all
Bag Logo
Jobaaj
Get jobs like this by email

New IT / Software Development & Related roles in Turbhe.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.