Job Title:
Axiom Developer
Location:
Buffalo, NY (Remote)
Job Description:
- Design and develop Data Sources, Data Models, Shorthands, Portfolios, Aggregations, Free Form and Tabular Reports, and workflows using AXIOM controller view tool based on Regulatory report requirements.
- Development and review of PL/SQL code to support data sourcing into Axiom, understanding end-to-end data flow from DB to Axiom.
- Strong hands-on development experience with ETL jobs and creating Unix & Linux Shell scripts for various requirements.
- Development and review of PL SQL and other DB code to support data sourcing into Axiom.
- Development experience with Oracle Database is mandatory to handle data loading.
- OFSAA experience would be an added advantage.
- Experience with Informatica ETL and SQL development will be beneficial while working on Axiom CV.
- Experience with data loading into the Axiom schema across the network (i.e., from on-premises to Axiom Cloud).
- Prior performance tuning experience both inside the Axiom controller view as well as at the database level.
- Work on automation of Axiom workflows schedules using Automic Scheduler.
- Knowledge of US regulatory reports like FFIEC031, FFIEC041, FRY 9C, FRY 9LP, etc.
- Work in the role of an Axiom Developer in a fast-paced environment; must be a self-starter and comfortable dealing with clients with very strong communication skills.
- Ability to review project-related documents such as BRD and FSD, and understand the design and solutions architecture with minimal guidance.
- Ensure code written meets predefined company and department standards.
- Understand functional documents and work with BA/Users to develop the reports.
- Preparation and execution of detailed unit test cases to test the Axiom code in Controller View.
- Migration of Axiom components from Dev environment to Prod.
- Good experience in Regulatory Reporting and Data Warehousing.
- Provide BAU and post-implementation support of Regulatory reports on Axiom.
- Maintain and manage the Axiom CV application on Dev/Test/Cert and Prod environments, including activities like upgrades, patching, and product code releases onboarding.