22 days old

Sr. Developer

West Chester, PA 19380
  • Job Code

The OFSAA developer (Oracle Financial Services Analytical Applications) will be part of a development team implementing OFSAA solution using for our transformation project where we are looking to modernize the Risk Actuarial systems.

Must have (Technical)

- Configuration of the OFSAA solution.

- Understand business requirements and implement technical solution within OFSAA in an efficient way

- Research and solve the data related issues within the environment.

- Advising other assets engaged in the project on OFSAA configuration details.

- Experience in leading and developing data warehousing applications/ Costing applications in financial and banking domain.

- Expert of Oracle Financial Services Analytical Application toolset.

- Recommend enhancements in Oracle DB and tool based on implementation experience.

- Experienced in all phases of Software Development Life Cycle

- knowledge of Oracle 11g, SQL, PL SQL, Data Architecture, Unix Shell Scripting, advanced Performance tuning

- Experienced in OFSAA Data Foundation and GL Reconciliation Modules

- Experience in Unified Metadata Manager

o Import Model

o Data Management Tools: like T2Ts, File Extracts, Data Quality Framework

o Data Entry Forms and Queries; Excel uploads; Atomic Schema Uploads

o Business Metadata Management

o Metadata Archive/Restore

- Rules Framework; Configure Business rules in OFSAA.

- Metadata Browser

- Should have worked on sourcing data from multiple source systems using ODI/ Informatica/ OWB or other major ETL/ ELT tools.

- Exposure to DIH would be good to have

Must have (Operational)

- Production support of OFSAA, this includes batch runs and development requests to fix defects as required.

- Designs technology solutions by modeling requirements and applying standard application methodology best practices

- Thorough understanding of key business processes and ability to communicate and translate those needs to technical solutions

- Work closely with internal and external clients, technical resources and executives (Application Managers, Business Analysts, System Analysts and Development / Quality teams)

- Evaluate the risks and solutions before taking action, so that action plans are timely, realistic and positive

- Promote a collaborative Team environment that fosters creativity, innovation and high performance

- Responsible for meeting company's customer advocacy & satisfaction objectives

Who is our ideal candidate?

- 3-5+ years of Hands-on experience in OFSAA modules.

- 3+ years of expertise in developing forms with the help of OFSAA forms framework.

- 6+ years of experience writing and debugging complex SQL queries and Stored Procedures in Oracle database.

- 6+ years of experience working in the financial industry

- Excellent understanding of BFSI - Banking and Insurance domain

- Experience in Metadata browser, Rules Framework, data management tools.

- Expertise in configuring Business rules in OFSAA Modules.

- Expertise in building T2T (Table to Table) transformations in OFSAA.

- In-depth understanding of Dimensions, hierarchies and attributes as it applies to OFSAA profitability modules.

- In-depth understanding of Data Warehousing concepts and dimensional modeling.

- Strong analytical and troubleshooting skills


  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

Sr. Developer

Randstad Technologies
West Chester, PA 19380

Share this job

Sr. Developer

Randstad Technologies
West Chester, PA

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast