Oracle Exadata: Utilize experience with versions 12c or above to manage and optimize databases. (Currently in 19c)
PL/SQL: Handle outdated ETL processes with a strong emphasis on packages, procedures, functions, triggers, and indexing. Provide troubleshooting support as the team transitions to other ETL tools.
Dynamic SQL: Develop and maintain dynamic SQL queries.
Parallel Processing: Design and automate processes using Autosys. Experience with scheduling software such as Control M, Autosys, and IBM tools is required.
SQL Explain Plan: Analyze and optimize SQL queries using Explain Plan.
Data Preparation: Prepare data to simplify reporting processes, ensuring minimal need for complex data processing.
Requirements Gathering: Collaborate with small business lending teams, especially in digital analytics (AB Initio), to gather and understand requirements.
Transformation Projects: Support the transformation of small business processes using tools like nCino, ensuring data integration into the analytics space.
Dashboard Integration: Feed data into dashboards for real-time analysis and reporting.
Regulatory Reporting: Manage regulatory reporting processes, ensuring all reports are accurately generated and submitted.
Automation Recreation: Recreate and optimize processes for automation.
Performance Tuning: Apply fundamental knowledge of performance tuning to ensure efficient data processing and system operations.