OFSAA ERM Tech Consultant — ALM & LRM Specialist

E4 Software Services Pvt Ltd.; Hinoba-an; On-site; PHP 600,000 - 900,000; Full time

Job summary

E4 Software Services Pvt Ltd. seeks an IC3 Technical Consultant to develop, configure, and support OFSAA ERM across modules such as ALM, LRM, Basel, FTP, and PFT. You will implement data pipelines, build transformations, and ensure high-quality deliverables under senior guidance.

You will work with ETL teams to load data, develop validation routines, and participate in SIT/UAT cycles while strengthening technical documentation and risk management concepts.

Qualifications

• Proficient in SQL/PLSQL with joins and analytic functions.
• Familiar with OFSAA modules: Metadata Framework, Rule Framework, cash flow engines.
• Experience with ETL tools ODI or Informatica or PL/SQL-based ingestion.
• Understanding of Oracle database concepts: partitioning, indexing, statistics.
• Familiar with Linux commands, batch execution, and log analysis.

Responsibilities

• Implement and configure OFSAA ERM modules (ALM, LRM, Basel, FTP, PFT).
• Configure rule framework components under supervision.
• Set up metadata objects, hierarchies, and product mappings.
• Develop SQL/PLSQL scripts, procedures, and views for data transformation.
• Build staging-to-foundation layer mapping logic per design documents.
• Support data validation routines, exception handling, and reconciliations.
• Collaborate with ETL teams to load data into staging/foundation layers.
• Assist in defining data pipelines under senior guidance.
• Perform data profiling, quality checks, and troubleshoot data loads.
• Prepare unit test cases and participate in SIT/UAT cycles.
• Support migrations between development, SIT, UAT, production environments.
• Provide root-cause analysis for defects during testing.
• Run OFSAA batch jobs, cash flow engines, and scenario executions.
• Monitor performance and assist tuning under senior guidance.
• Capture logs and resolve errors with leads.
• Maintain technical docs and mapping specs.

Skills

SQL/PLSQL programming

OFSAA components

ETL tools ODI/Informatica

Oracle DB concepts

Linux commands & log analysis

ALM, LRM, Basel, FTP familiarity

Data profiling & validation

Communication & teamwork

Independent task execution

Risk management concepts

Tools

ODI

Informatica

Exadata/OCI

Job description

E4 Software Services Pvt Ltd. seeks an IC3 Technical Consultant to develop, configure, and support OFSAA ERM across modules such as ALM, LRM, Basel, FTP, and PFT. You will implement data pipelines, build transformations, and ensure high-quality deliverables under senior guidance.

You will work with ETL teams to load data, develop validation routines, and participate in SIT/UAT cycles while strengthening technical documentation and risk management concepts.