Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 28 hours ago

Senior PL/SQL & ETL Developer

IRIS RegTech Solutions Limited37 open roles

Where
Navi Mumbai
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior PL/SQL & ETL DeveloperIRIS RegTech Solutions Limited · Navi Mumbai

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on IRIS RegTech Solutions Limited's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.3% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.0%1 day
  2. 4.2%3 days
  3. 11.3%7 days
  4. 17.6%14 days
  5. 34.3%30 days
  6. 43.5%60 days
This job: posted 28 hours ago

The posting

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.
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against IRIS RegTech Solutions Limited's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on IRIS RegTech Solutions Limited's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    IRIS RegTech Solutions Limited's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.