Oracle PL/SQL Developer

Introduction

This role involves working on mission-critical regulatory and liquidity reporting systems required by regulators and senior management. The position requires a strong Oracle and ETL expert capable of designing scalable solutions, optimizing performance, and troubleshooting complex production issues independently.

Required Skills & Qualifications

• 7-10 years of hands-on development experience with Oracle Exadata, SQL, and PL/SQL
• Experience in ETL/Data Warehousing design and development for large-volume data processing
• Strong knowledge of SQL performance tuning using Explain Plan, SQL Trace, TKPROF, AUTOTRACE, AWR Reports
• Solid understanding of Oracle Architecture, including SGA & PGA memory structures, Oracle server processes, and query optimization
• Strong debugging and troubleshooting skills in production environments
• Prior work experience at the client or in the client's industry

Applicants must be able to work directly for Artech on W2

Preferred Skills & Qualifications

• Regulatory Reporting experience, particularly liquidity, risk, finance, or banking regulatory projects
• Experience with Python for automation, data processing, and ETL enhancements
• Knowledge of Apache Airflow for workflow orchestration and scheduling
• Experience working with Containers (e.g., Docker/Kubernetes)
• Familiarity with CI/CD pipelines, including Jenkins, Git, and automated deployment practices
• Experience in Agile/Scrum delivery teams
• Experience implementing reconciliation, exception handling, and audit controls in data pipelines
• Exposure to metadata-driven ETL frameworks or reusable data integration platforms
• Experience with Tableau or other enterprise reporting and analytics tools
• Financial services or banking domain knowledge, especially around Liquidity Reporting (LCR, NSFR, FR2052a, ILST) and data lineage requirements

Day-to-Day Responsibilities

• Design, develop, and maintain batch/ETL interfaces using the organization's metadata-driven framework
• Support and troubleshoot existing ETL processes, including production issue resolution and root cause analysis
• Develop and optimize Oracle SQL/PLSQL code for large-volume data processing on Exadata
• Perform SQL performance tuning using AWR, Explain Plan, TKPROF, SQL Trace, and related tools
• Maintain data lineage and end-to-end traceability for ETL changes
• Implement liquidity reporting derivations and regulatory reporting data transformations
• Participate in code reviews, Agile ceremonies, and CI/CD deployment activities

For immediate consideration please click APPLY to begin the screening process with Alex.