OFSAA Developer
TEKsystems - Columbus, OH
Apply NowJob Description
Description A financial entity is seeking an OFSAA (Oracle Financial Services Analytical Applications) Developer/SME to support its ongoing profitability, scale readiness, and regulatory reporting projects. They rely on OFSAAA applications suite to calculate profitability by account which can be rolled up by product, customer, and organization to provide data for financial and risk reporting. The application collects account, customer and transaction information from the Enterprise Data Warehouse as well as some direct source systems. The data is used to calculate transfer pricing, loan loss reserve, equity, profit contribution, and other financial data for use in financial reporting, marketing, risk, and numerous other downstream bank applications. Towards this end, the client leverages OFSAA 8.1.0 applications suite along with the clients IBM DB2 Data Warehouse, DataStage ETL, Zena Enterprise Job Scheduling. The data captured and processed in the OFSAA data foundation layer serves as a data source for the banku2019s BI applications and is the source of truth for the banku2019s financials. This position will be required to maintain, enhance, and work with these applications as needed, ensure all IT SDLC processes are documented and practiced, work extremely close with the finance business team on process improvements and enhancements requested to the data, software, and cross impact other bank applications as code and processes change. Responsibilities include: u2022 Configuration, development, patching/upgrades, and customization of the following modules: OFSAAI, OFSALM, OFSFTP, OFSPFT, OFSADIH and OFSDF u2022 Data Mapping of staging and reporting, EDW to OFSAA, T2T development u2022 Perform other duties, as needed in support of the overall Data Warehouse implementation u2022 Working closely with finance to evaluate monthly business requirements, participate in efficient development, delivery, and deployments u2022 Understanding of the banku2019s financial statements and how the attributes of those financials interact together Basic Qualifications: u2022 3-5 years supporting OFSAA 8.1.0 and OFSAA 8.1.2 u2022 Experience in OFSAA patching, monitoring, and performance tuning u2022 Erwin Data Modelling Experience Required u2022 Basic Unix/Linux scripting experience u2022 ETL, PL/SQL programming experience u2022 SQL Developer, Toad experience u2022 Bachelor's degree u2022 5+ years of Data Warehouse experience u2022 5+ years of application development and implementation experience Preferred Qualifications: u2022 5+ years of financial services/banking experience u2022 Experience in merging models from different OFSAA instances u2022 Zena Enterprise Job Scheduling knowledge u2022 Strong understanding of bank terminology and finance related topics u2022 Ability to work independently and multitask within a collaborative work environment u2022 Excellent troubleshooting, organizational and analytical skills u2022 Willingness and aptitude for continuous improvement u2022 Do the right thing attitude while being a strong team player u2022 Strong communication and collaboration skills, focus on customer service Skills ofsaa, edw, patching, data modeling Top Skills Details ofsaa,edw,patching,data modeling Additional Skills & Qualifications Screening Questions ONLY over the phone What are the ALM, FTP, & PFT modules used for in financial institutions? What steps would you take to plan to patch or upgrade an environment? How would you perform a model merge? Issues you may encounter and how to resolve? How would you integrate OFSAA batches into an external scheduler? Developer What are the different types of batches? How would you configure a T2T? How would you debug and resolve a T2T failure? How would you integrate OFSAA batches into an external scheduler? RTR By replying to this email, I am giving consent to TEKsystems to represent me for the requisition noted below. I understand that only one staffing partner may represent me per requisition at (Client). In the event I am submitted by more than one staffing partner for this requisition, I understand that the timestamp of this e-mail and the timestamp of my resume submittal by the staffing partner determines which staffing provider represents me. Requisition title: Programmer Analyst: IV (Lead) Experience Level Expert Level Job Type & Location This is a Contract to Hire position based out of Columbus, OH. Pay and Benefits The pay range for this position is $55.00 - $70.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: u2022 Medical, dental & vision u2022 Critical Illness, Accident, and Hospital u2022 401(k) Retirement Plan u2013 Pre-tax and Roth post-tax contributions available u2022 Life Insurance (Voluntary Life & AD&D for the employee and dependents) u2022 Short and long-term disability u2022 Health Spending Account (HSA) u2022 Transportation benefits u2022 Employee Assistance Program u2022 Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a fully remote position. Application Deadline This position is anticipated to close on May 8, 2026. h4>About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. About TEKsystems and TEKsystems Global Services Weu2019re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Weu2019re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Weu2019re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Weu2019re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at . The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Created: 2026-05-06