ES ORACLE Cloud Lead

Hexaware Technologies

United States

about 1 month ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Business Analytics Applications Backup Devices Data Centers Data Profiling Project Management Software Oracle (Applications) Standard Sql Reverse Engineering Microsoft Fabric Data Management Crosswalk Oracle Cloud Infrastructure

+1 more

Databricks

Job description

Reverse-engineer the Yardi schema and APIs to document the general ledger, accounts payable, purchase order, invoice, journal, vendor, property and asset entities and their true relationships.
Reconstruct the procure-to-pay and record-to-report process flows end to end, including the commitment, accrual, and period-close behaviours that determine when a figure becomes reportable.
Model those flows into Gold-layer business containers linked to the Data Backbone, preserving the process context that raw extracts lose.
Produce source-to-target mappings from Bronze through Silver to Gold, documenting transformation logic, business rules, reconciliation points and known data-quality defects.
Define the Yardi contribution to DNA crosswalk keys (Project, Vendor, Cost Code, Asset, Entity) and resolve identifier conflicts against Procore and Oracle P6.
Define data-quality gates and confidence scoring for finance KPIs and steward them through certification with Finance data owners.Support pipeline development, automated transformation testing, and reconciliation of Gold outputs back to Yardi system-of-record balances.

Requirements

5+ years hands-on with Yardi (Voyager and/or Elevate) in a data, reporting, integration, or finance-systems capacity.
Demonstrated ability to reverse-engineer an ERP schema and produce an authoritative business-entity and process model.
Strong SQL and data-profiling skills against large, complex financial schemas.
Solid working understanding of core finance processes - procure-to-pay, general ledger, accruals, period close - and the ability to reconcile derived data back to the system of record.Experience producing source-to-target mapping specifications and data-quality rules for analytics platforms., * Experience with Yardi in a real-estate, data centre, or infrastructure operating environment.
Exposure to medallion / lakehouse architectures (Microsoft Fabric, Azure Databricks, OneLake).
Familiarity with Microsoft Purview or comparable catalog and lineage tooling.
Prior finance data-governance or master-data management experience.