Job Description
Design and develop Data Sources, Data Models, Shorthands, Portfolios, Aggregations, Free Form and Tabular Report 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 the Unix & Linux Shell scripts for various requirement
- Development and review of PL SQL & other DB code to support data sourcing into Axiom.
- Development experience with Oracle Database will be mandatory to handle the data loading.
- OFSAA experience would be an added advantage.
- Experience with Informatica ETL and SQL development will be beneficial while working on Axiom CV
- Should have an experience with data loading into the Axiom schema across the network i.e.. from on-premises to Axiom Cloud
- Must have 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
- Have knowledge on 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, comfortable dealing with clients, very strong communication skills.
- Must have the ability to review project related documents such as BRD, FSD and understand the design and solutions architecture with minimal guidance.
- Ensuring code written meets the predefined company and departments standards.
- Understanding the 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 Environment activity like upgrade, patching and Product code releases onboarding