Note: The job is a remote job and is open to candidates in USA. FormativGroup is a company that specializes in bridging the gap between business goals and modern platforms. The OFSAA Data Modeling Consultant will support the design, development, implementation, and support of Oracle Financial Services Analytical Applications solutions, focusing on data modeling and ETL/ELT development. The consultant will collaborate with various teams to analyze requirements and deliver scalable OFSAA-based solutions aligned to business and regulatory needs.
Responsibilities
- Partner with business analysts, users, and technical teams to analyze requirements, identify gaps, and design effective OFSAA-based solutions
- Design, develop, and maintain ETL/ELT processes to load, transform, and validate data across OFSAA applications and source systems
- Customize, merge, and deploy the OFSAA data model in alignment with client-specific business and regulatory requirements
- Support OFSAA staging and reporting data model activities, including data lineage, metadata, and data mapping
- Act as an escalation point for application support, troubleshooting complex production issues and driving root-cause resolution
- Support end-to-end implementation activities, including UAT, production deployments, defect fixes, system enhancements, and post-production support
- Collaborate with client stakeholders and internal teams across multiple phases of the OFSAA implementation lifecycle
Skills
- Strong expertise in OFSAA staging and reporting data models, with solid understanding of data lineage and data modeling concepts
- Hands-on experience with OFSAA ELT utilities such as Excel File Upload, F2T, T2T, Unified Metadata Manager, SCD, and AMHM
- In-depth knowledge of OFSAAI products, frameworks, metadata management, hierarchies, datasets, and core architectural components
- Advanced proficiency in SQL and PL/SQL, including stored procedures
- Strong experience working with Oracle Database
- Proven experience supporting clients across multiple phases of the OFSAA implementation lifecycle in a consulting environment
- Experience troubleshooting OFSAA application issues, production defects, data load failures, and system performance concerns
- Strong communication skills with the ability to work directly with business users, technical teams, and client stakeholders
- Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa currently
- To be considered for this position, candidates must reside in the following U.S. states: FL, NJ, NY, or NC
- Candidates residing outside these states are not eligible for consideration currently
- Not open to 3rd party/C2C engagement
Benefits
- Employees may be eligible for discretionary bonuses, commissions, or other incentive programs
- Comprehensive benefits package that includes medical, dental, vision, 401(k), paid time off
Company Overview