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.