Qureos Mentor

Apollo Technology Solutions LLC

<div><div>Job Title: PL/SQL Analyst 
Location: Remote but someone local to NYC preferred 
Duration: Long Term 
 
Job Description 
We are looking for a Technical Support Analyst for a full-time, fully remote opportunity. The engagement is to work within a split team of 10 to support a suite of financial applications in a NYC bank. The selected candidate will develop and maintain complex IBM Cognos reports and Oracle PL/SQL queries, support a Loan Application and its interfaces, consult with business users, and must have banking or loan application experience. 
What You'll Do
<ul><li>Develop, maintain, and modify complex reports, queries, and data extracts using IBM Cognos and Oracle PL/SQL.</li>
<li>Support and maintain the Loan Application and its associated interfaces, ensuring smooth functionality and integration.</li>
<li>Consult with business users to address application functionality questions and provide technical guidance.</li>
<li>Troubleshoot and resolve issues at the server, client, and interface levels, including working with vendors for support and upgrades.</li>
<li>Create ad-hoc reports and data extracts for regulatory, IT, and business needs, leveraging strong SQL and data modeling skills.</li>
</ul>What You'll Need 
Required:
<ul><li>PL/SQL and SQL Development/ Development Support</li>
<li>Minimum of 5 years applications support and/or development experience in the financial domain.</li>
<li>Strong Financial Applications Background, preferably supporting a loan or deposit type system &ndash; e.g. LoanIQ.</li>
<li>Strong Data Modeling and SQL skills that can be applied to interface development, ad-hoc data extracts and scheduled report writing.</li>
<li>Experience working with and supporting interfaces for a data warehouse &ndash; e.g. OFSA.</li>
<li>Excellent troubleshooting skills &ndash; at server, client and interface level.</li>
<li>Excellent Data Analytics skills.</li>
<li>Proven ability to work with a vendor regarding support issues, enhancements and upgrades.</li>
<li>Ability to quickly develop ad-hoc reports on the fly for regulatory and IT purposes.</li>
<li>Ability to document business requirements and present comprehensive, logical solutions to business users.</li>
<li>Oracle 10g/11, Microsoft SQL Server, PL/SQL programming, Schemas, Views, Stored Procedures, Triggers experience</li>
<li>Report development experience</li>
<li>Enterprise Scheduling Tools (e.g. Cybermation, AutoSys) experience</li>
<li>ETL Tools (e.g. SSIS, DTS, Informatica) experience</li>
<li>Utilities development (batch scripting, ftp scripting) experience</li>
<li>Data Modeling Tools (e.g. Erwin) experience</li>
</ul>Physical Demands
<ul><li>Ability to safely and successfully perform essential job functions consistent with the ADA and other federal, state, and local standards</li>
<li>Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings</li>
<li>Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor</li></ul></div></div>

PL/SQL Analyst

Join Apollo Technology Solutions LLC and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Apollo Technology Solutions LLC

ABOUT_COMPANY

PL/SQL Analyst