Irsl·4 days ago
4 days ago
PL/SQL Developer
Sign up free to see how well your resume matches this role.
What you'll do
- 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.
What they're looking for
- 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.
- Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
Nice to have
- Understanding of data warehousing concepts (staging, ODS, dimensional modeling) is a plus.
- Exposure to core banking systems (e.g., Finastra, Flexcube, Finacle, TCS BaNCS, or similar) is a strong plus.
Summarised by NextRaise from the employer’s description, which follows in full below.
Full description from employer
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.
To read more about IRIS, visit our website: https://irisregtech.com
About the Role
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.
Company
Irsl
Mumbai, India
Company facts come from this company's own listings. We only show what the postings themselves carry.