Job Title: ACBS Automation ETL/Lansa Developer
Department: Information Technology
The candidate will be required to work closely with the Operations teams supporting the
ACBS (Advanced Commercial Banking System). Responsibilities will include gathering
requirements and performing the development needed to automate daily input and update
of Facilities, Loans, Collateral and supporting information for a direct interface into
Design and development of automated processes and/or workflows to integrate
information from external sources to drive the creation and update of Facilities
and Loans into our ACBS system.
Automated creation of Facility records and associated details.
Automated creation of Loan bundles in desired status.
Creation and maintenance of templates that are used to enrich the data included in
the incoming XML messages.
Automated renewal/rollovers of Facilities and Loans.
Enhancement and development of various notices.
Perform test and validation with the users to ensure the processes are working are
Coordinate with production support on the setup of workflows and schedules
required to perform updates
Technical Skills & Requirements:
Extensive experience in Financial Services, Commercial Banking
4+ years’ Experience with ACBS commercial lending system version 6+
Expert knowledge using Informatica 9+
Strong hands-on experience with DB2, SQL
Strong knowledge of client/server and AS/400 architectures and processes.
Expert in working with all types of sources and targets
Strong organization, analytical skills, self-starter
Good written and verbal communication