PL/SQL Developer (Moody's + ETL)

We are seeking a detail-oriented and analytical PL/SQL Developer with hands-on experience integrating and managing Moody’s Analytics products (e.g., RiskAuthority, RiskCalc, or CreditLens). The candidate will be responsible for developing, optimizing, and maintaining PL/SQL packages, procedures, and data integration pipelines that interact with Moody’s risk engines and analytical systems. This role requires a strong understanding of relational database design, performance tuning, and data modeling, combined with the ability to work closely with business analysts, risk teams, and Moody’s technical representatives. Core Roles & Responsibilities Area- Description PL/SQL Development- Write and optimize complex PL/SQL code (procedures, functions, packages, triggers) to manage Moody’s data workflows. Moody’s Analytics Integration- Develop data exchange processes to feed Moody’s systems (e.g., RiskAuthority) and extract results into internal reporting/data marts. Data Analysis & Mapping- Collaborate with risk analysts and Moody’s consultants to map source data to Moody’s schemas and APIs. Performance Tuning- Diagnose and optimize slow-running queries, ensure efficient use of indexes, and manage statistics. ETL/Data Load Automation- Automate data extraction, transformation, and loading between Oracle DB and Moody’s applications or external sources. Data Quality & Validation- Implement control mechanisms for data validation, reconciliation, and exception handling. Documentation & Version Control- Create technical documentation, data dictionaries, and maintain version history using Git or similar tools. Collaboration & Support- Support testing (SIT/UAT), deployment, and post-production issues in coordination with infrastructure and business teams. Technical Skills with Weightage (%) Technical Skill Weight (%) Description PL/SQL Programming 35% Writing efficient packages, procedures, triggers; modular and performance-aware code. Oracle Database Design & Tuning 20% Data modeling, indexing, execution plans, AWR/ASH report analysis. Moody’s Analytics Product Experience 15% Integration with Moody’s platforms like RiskAuthority, RiskCalc, CreditLens, etc. ETL/Data Integration (SQL Loader, Shell) 10% Automating large file loads, scheduled jobs, and cross-platform data movement. Data Validation & Quality Checks 10% Writing scripts for data balancing, exception detection, rule-based validation. Version Control & Deployment Tools 5% Experience with Git, Jenkins, Liquibase (optional but valuable). Documentation & Communication Skills 5% Writing clear specs, flow diagrams, and technical documentation.