Assure data integrity, model correctness, performance and usability across pipelines, semantic models and reports spanning Salesforce/Fabric/Oracle, including near-real-time refresh SLAs (5–10 mins).
Responsibilities
Author test strategy covering transformation accuracy, reconciliation (Salesforce ↔ Oracle), security (RLS/OLS), lineage, performance and accessibility.
Build automated data tests (SQL assertions, expectations), regression packs for DAX/measures and dataset-level contracts.
Execute SIT/UAT, manage defects/traceability; validate deployment pipelines and release readiness.
Leverage Power Platform where appropriate (e.g., Power Automate for defect routing/alerts).
Essential experience
Testing data/BI platforms with mixed SaaS/ERP sources; strong SQL and test data design.
Test management/reporting tools; understanding of privacy and access controls.
Desirable
Great Expectations (or similar), performance testing; ISTQB.
Skills Required Salesforce, Power Automate, Power Platform, Oracle, Dax, Sql