Description

You will design and develop Regulatory reports using the AXIOM Controller View tool, including Data Sources, Data Models, Shorthands, Portfolios, Aggregations, and workflows.

Responsibilities

• Develop and review PL/SQL code to support data sourcing into AXIOM, ensuring end-to-end data flow from the database.
• Build and maintain Unix/Linux shell scripts and ETL jobs using Informatica for data loading and processing.
• Perform performance tuning for AXIOM Controller View and Oracle Database queries to optimize report generation.
• Automate AXIOM workflow schedules using Automic Scheduler and manage migrations from Dev to Prod environments.
• Execute unit test cases and provide BAU support for US regulatory reports such as FFIEC031, FFIEC041, FRY 9C, and FRY 9LP.

Required Skills

• 5+ years of hands-on experience with Oracle Database, PL/SQL, and SQL development.
• Strong proficiency in AXIOM Controller View, including experience with data loading into AXIOM schemas.
• Experience with Informatica ETL and creating Unix/Linux shell scripts.
• Knowledge of US regulatory reporting frameworks (FFIEC, FRY reports).
• Ability to review BRD, FSD, and design solutions with minimal guidance.
• Experience with performance tuning at both the application and database levels.

Preferred Skills

• Previous experience with OFSAA (Oracle Financial Services Analytical Applications).
• Familiarity with Automic Scheduler for workflow automation.
• Experience managing AXIOM application upgrades, patching, and releases across Dev/Test/Prod environments.

Key Skills

Education

Any Graduate