Sr OFSAA and Oracle Database

Charlotte, NC

Company Name :IBA Infotech LLC

Type : Contract

Primary Skills : SQL, PL/SQL, UNIX scripting

Location : Charlotte

CTC : DOE

Job Description:

Responsibilities include:

  • 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.

 

Required Qualifications

  • 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

 

Other Desired Qualifications

  • Understanding of batch processing and scheduling tools.
  • Familiarity with Oracle GL business suite and its processing.
  • Understanding of Java and .NET-related technologies.