Software Engineer II

Title: Software Engineer II

Job Location: 465 Main Street, Buffalo, NY 14203

DESCRIPTION:

Duties: Contribute to team responsible for maintaining and submitting various regulatory reports to the Federal Reserve including the FFIEC 031, FFIEC 041, FR Y-9C, FR Y-9LP, and the SOD (Summary of Deposit); design and develop Data Sources, Data Models, Shorthands, Portfolios, Aggregations, Fee Form and Tabular Report and workflows using AXIOM controller view tool; develop and review PL/SQL code to support data sourcing into Axiom, utilizing end-to-end data flow from databases to Axiom; work on automation of Axiom workflow schedules using Automic Scheduler; develop ETL jobs and create Unix Shell scripts for various requirements; extract data using Oracle PL/SQL and other Database code to support data sourcing into Axiom; prepare and execute detailed unit test cases for Axiom code in Controller View; migrate Axiom components from development environment to production; provide post-implementation support for Regulatory reports on Axiom; and maintain and manage the Axiom CV application on Development/Testing/Certification and Production Environment activity like upgrade, patching and Product code releases onboarding.

QUALIFICATIONS:

Minimum requirements: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, or a related technical field, and five (5) years of experience with data sourcing and extraction using Oracle PL/SQL, and Agile methodology throughout the software development lifecycle; two (2) years in systems analysis and application development using Informatica ETL, Unix Shell Scripting, Job Scheduler, reporting tools (OBIEE or Tableau), JIRA, and Confluence; performing risk and regulatory reporting within the banking industry; unit testing for code development; and requirements analysis for functional and technical design.

Salary: $136,750.00 - $146,750.00 per year.

Location

Buffalo, New York, United States of America