Job: Report Writer/ Applications Support Engineer

Title Report Writer/ Applications Support Engineer
Start Date 2014-12-30
Location New York City, PA
Job Information

please mention your visa status while replying.

Report Writer/Applications Support Engineer

Exclusive to CAI.

Please see vendor comments for rate information.

Duration- Long term- 36 mos++

Local candidates preferred; face to face interview ideal
Must be able to troubleshoot Cognos reports and understand the foundation/backend of it
Support Development required and must know SQL and PL/SQL
Must be willing to learn other banking applications (Loan IQ)
Banking Industry required

Job Title:
Report Writer/Applications Support Engineer

Job Description:
The engagement is to work within a split team of 10 (Allentown & NYC) to support a suite of financial applications in a NYC bank. This is a working team member position. The candidate’s primary function will be writing, maintaining, and modifying complex queries and reports using IBM Cognos and an Oracle database (PL/SQL). The candidate will also be required to support and maintain a Loan Application and it’s associated interfaces, consult with business users on application functionality and/or technical questions. Applicants with experience in the banking industry or experience supporting a Loan application will only be considered.

Summary of necessary skills:
Experience writing and maintaining Reports using IBM Cognos and Crystal.
Minimum of 5 years applications support and/or development experience in the financial domain.
Strong Data Modeling and SQL skills that can be applied to interface development, ad-hoc data extracts and scheduled report writing.
Strong Financial Applications Background, preferably supporting a loan or deposit type system – e.g. LoanIQ.
Experiencing working with and supporting interfaces for a data warehouse – e.g. OFSA.
Excellent troubleshooting skills.
Excellent Data Analytics skills.
Proven ability to work with a vendor regarding support issues, enhancements and upgrades.

Well versed in the following technologies:
Oracle 10g/11, SQL Server, PL/SQL programming
IBM Cognos/Crystal Reports
Enterprise Scheduling Tools (e.g. Cybermation, AutoSys)
ETL Tools (e.g. SSIS, DTS, Informatica)
Utilities development (batch scripting, ftp scripting)

Summary of Desired Skills:
Experience working with LoanIQ
Experience working with one or more Oracle Financials Products (e.g. OFSA)
Understanding of .Net/COM based technologies – for interface/API development and troubleshooting.


Apply Now