> Markdown version of [/jobs/ext/569060-sr-ofsaa-and-oracle-database](https://www.wearedevelopers.com/jobs/ext/569060-sr-ofsaa-and-oracle-database). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr OFSAA and Oracle Database - **Company:** IBA InfoTech Inc. - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Business Software, Oracle Business Intelligence Enterprise Edition, Oracle (Applications) - **Published:** June 14, 2026 - **Apply:** https://ibainfotech.com/sr-ofsaa-and-oracle-database ## About the Role * 7+ years of application development and implementation experience * 4+ years of UNIX experience * 8+ years of Oracle experience * 3+ years of Oracle Financial Services Analytical Applications (OFSAA) experience * 5+ years of experience leading the requirement design process with both technical and business partners * 8 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning * 8+ years of PL/SQL experience Desired Qualifications * Good verbal, written, and interpersonal communication skills * A BS/BA degree or higher in science or technology * Business intelligence experience * ETL (Extract, Transform, Load) Programming experience * OBIEE (Oracle Business Intelligence Enterprise Edition) experience * Knowledge and understanding of accounting principles and policies, * Understanding of batch processing and scheduling tools. * Familiarity with Oracle GL business suite and its processing. * Understanding of Java and .NET-related technologies. ## Description * Acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology within the OFSAA framework / Oracle Datamart. * Analyzes business requirements, architects and writes technical specifications to design or redesign computer solutions. * Configures OFSAAi data flows using provided out-of-the-box as well as custom T2Ts, rules framework, task and batch schedules, integrates existing flows provided by vendors. * Installs, configures and troubleshoots OFSAA installations and participates in upgrades. * Leads projects and project teams, including assignment of tasks, and provides mentorship, direction, and guidance to less experienced staff. * Develops original and complex solutions or provides technical guidance to less experienced staff. * Leads and/or performs modeling, simulations and analysis efforts. * Verifies program logic by overseeing the preparation of test data, testing and debugging of programs written using SQL, PL/SQL or UNIX scripting. * Participates in overall systems integration testing. Provides input and direction on the scope of testing scripts. Maintains testing data for SIT and UAT environments. * Analyzes and troubleshoots various Oracle performance issues (for both batch processing as well as end-user interaction) in the datamart. * This leads to the migration of applications to production according to the SDLC model. * Develops new documentation, participates in the development of department technical procedures and designs user guides. * As an escalation point for application support and troubleshooting, provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems for various front-end applications, downstream and upstream applications and others. * Assures quality, security and compliance requirements are met for supported area and oversees updating and testing of the business continuation plan. * The ideal candidate will be an individual who takes ownership of a process and accountability for its day to day activities, is able to work independently or as part of a team, and seeks to work on a diverse range of programming languages. ## Related Videos - [Independently together: how micro-applications improve developer experience + app performance](https://www.wearedevelopers.com/videos/452-independently-together-how-micro-applications-improve-developer-experience-app-performance) - [Open Source: The Engine of Innovation in the Digital Age](https://www.wearedevelopers.com/videos/1103-open-source-the-engine-of-innovation-in-the-digital-age) - [Java Sucks (So C# Didn't Have To)](https://www.wearedevelopers.com/videos/100271-java-sucks-so-c-didn-t-have-to) - [OLAP for AI Applications and why you should care](https://www.wearedevelopers.com/videos/100212-olap-for-ai-applications-and-why-you-should-care) - [Application Modernization and Rabbits](https://www.wearedevelopers.com/videos/120-application-modernization-and-rabbits) - [The Future of Open Source](https://www.wearedevelopers.com/videos/1124-the-future-of-open-source) ## Related Articles - [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Java Basics](https://www.wearedevelopers.com/magazine/122-java-basics) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)