AmeriSave Mortgage Corporation seeks a Software Develop Consultant specializing in Oracle software solutions. You will focus on integrating Oracle Data Integrator (ODI) packages into our broader Risk & Finance data architecture and developing analytics solutions with Oracle Analytics Cloud (OAC), supporting our mission to fight for everyone’s opportunity for a better financial future.
What You'll Do
- Work with Oracle software solutions including Oracle Data Integrator (ODI) and Oracle Analytics Cloud.
- Integrate Oracle Data Integrator (ODI) packages on OFSAA application into the broader Risk & Finance data, reporting & analytics architecture by developing interfaces in PL/SQL functions.
- Develop dashboards and reports using Oracle Analytics Cloud.
- Install and configure Oracle Analytics Cloud (OAC) in the Cloud using Remote Data Gateway.
- Design, develop and test analytics and reporting solutions that meet enterprise standards in Oracle Analytics Cloud.
- Create a reporting data model and build the semantic layer metadata for reporting using the OAC admin tool.
- Perform admin support to migrate the RPD, presentation catalog, customized configuration files, users, and application roles to higher environments.
- Develop ETL code using Oracle Data Integrator (ODI) and build mappings and packages to support Data Warehouse development.
- Analyze user requirements and, based on findings, create Requirements specification documents, system specification documents, and other SDLC-specific documents and own SDLC design reviews.
What We're Looking For
- A bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or a closely related field.
- A minimum of five (5) years of experience working as a Software Engineer or in a related position.
- Experience utilizing Data Warehousing concepts and dimensional modeling including dimensions, hierarchies, and attributes as they apply to OAC/BI analytical tools.
- Experience working with advanced PL/SQL functions, and troubleshooting, performance tuning, and working with stored procedures supporting a financial data warehouse.
- Experience utilizing OBIEE 12c, Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), Oracle (12c and 19c), Oracle Business Intelligence Enterprise Edition (v10.1.3.4.1, V11.1.1.5), or Oracle (10g,11g).
- Experience utilizing Informatica (v7.2,v8.6), SQL Server 2005, Windows XP or Windows 7.
- Experience working on complex data structures, dashboards, and ad hoc reporting to support warehouse development and reporting needs.
Technical Stack
- Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC), PL/SQL
- Oracle (12c, 19c, 10g, 11g)
- Oracle Business Intelligence Enterprise Edition (OBIEE 12c, v10.1.3.4.1, V11.1.1.5)
- Informatica (v7.2, v8.6), SQL Server 2005
- Windows XP, Windows 7
Benefits & Compensation
- Salary: $136,392.90
- Health, dental, vision and life insurance plans
- 401(k) Savings plan – with generous company matching contributions (up to 6%)
- Voya Retirement Plan – employer paid cash balance retirement plan (4%)
- Tuition reimbursement up to $5,250/year
- Paid time off – including 20 days paid time off, nine paid company holidays and a flexible Diversity Celebration Day
- Paid volunteer time — 40 hours per calendar year
Work Mode
This position is open to candidates anywhere in the continental United States.
Voya Financial is an equal-opportunity employer. Voya Financial provides equal opportunity to qualified individuals regardless of race, color, sex, national origin, citizenship status, religion, age, disability, veteran status, creed, marital status, sexual orientation, gender identity, genetic information, or any other status protected by state or local law.
