Description

Design and develop regulatory reporting solutions using the Axiom ControllerView tool.

Responsibilities

  • Design and develop data sources, models, shorthands, portfolios, and tabular reports within Axiom ControllerView.
  • Develop and review PL/SQL and database code to manage end-to-end data flows from databases to Axiom.
  • Build ETL jobs and Unix/Linux shell scripts to support data sourcing and loading from on-premises environments to Axiom Cloud.
  • Perform performance tuning within Axiom ControllerView and at the database level.
  • Automate Axiom workflow schedules using Automic Scheduler and manage migrations from Dev to Prod.

Required Skills

  • 3+ years of experience in regulatory reporting and data warehousing.
  • Strong proficiency in PL/SQL and SQL development.
  • Hands-on experience with Oracle Database for data loading.
  • Experience creating Unix and Linux shell scripts.
  • Proven ability to handle ETL job development.
  • Experience with performance tuning in database and Axiom environments.
  • Ability to interpret BRD and FSD documents to implement design and architecture.
  • Bachelor's degree.

Preferred Skills

  • Experience with OFSAA.
  • Knowledge of Informatica ETL.
  • Familiarity with US regulatory reports such as FFIEC031, FFIEC041, FRY 9C, or FRY 9LP.

Education

Bachelor's degree