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.