OFSAA (Oracle Financial Services Analytical Applications) Developer/SME

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 bank's BI applications and is the source of truth for the bank's 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: Configuration, development, patching/upgrades, and customization of the following modules: OFSAAI, OFSALM, OFSFTP, OFSPFT, OFSADIH and OFSDF Data Mapping of staging and reporting, EDW to OFSAA, T2T development Perform other duties, as needed in support of the overall Data Warehouse implementation Working closely with finance to evaluate monthly business requirements, participate in efficient development, delivery, and deployments Understanding of the bank's financial statements and how the attributes of those financials interact together

3-5 years supporting OFSAA 8.1.0 and OFSAA 8.1.2 Experience in OFSAA patching, monitoring, and performance tuning Erwin Data Modelling Experience Required Basic Unix/Linux scripting experience ETL, PL/SQL programming experience SQL Developer, Toad experience Bachelor's degree 5+ years of Data Warehouse experience 5+ years of application development and implementation experience

Preferred Qualifications: 5+ years of financial services/banking experience Experience in merging models from different OFSAA instances Zena Enterprise Job Scheduling knowledge Strong understanding of bank terminology and finance related topics Ability to work independently and multitask within a collaborative work environment Excellent troubleshooting, organizational and analytical skills Willingness and aptitude for continuous improvement Do the right thing attitude while being a strong team player Strong communication and collaboration skills, focus on customer service Skills ofsaa, edw, patching, data modeling Top Skills Details ofsaa,edw,patching,data modeling

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: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a fully remote position.

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 We're 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. We're 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. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're 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 TEKsystems.com.