PL/SQL Development: Write and optimize complex PL/SQL code including procedures, functions, packages, and triggers to manage Moody's data workflows.
Moody's Analytics Integration: Develop data exchange processes to feed Moody's systems (e.g., Risk Authority) and extract results into internal reporting/data marts.
Data Analysis & Mapping: Collaborate with risk analysts and 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 database statistics.
ETL/Data Load Automation: Automate extraction, transformation, and loading between Oracle DB and Moody's applications or external sources.
Data Quality & Validation: Implement control mechanisms for 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 SIT/UAT testing, deployment, and resolve post-production issues in coordination with infrastructure and business teams.
Skills:
Bachelor's degree in information technology, Computer Science, or related field.
Strong PL/SQL programming (packages, procedures, triggers, modular and performance-aware code).
