Salesforce Data Engineer / Consultant

Job Description

Technical Expertise: Lead client SMEs through complex schema mapping and source-to-target validation, including automated reconciliation scripts across sandboxes and production cutovers. Expert in Automation Bypass strategies and Identity Resolution rules to prevent duplicate records and performance degradation during high-volume loads. Architect Zero Copy Federation via Salesforce Data Cloud (Data 360), mapping Databricks DLOs to Salesforce DMOs for 10–25 year historical datasets, while leading "Receiving Pipes" development using Bulk API 2.0 and scripting (Python, Node, or SFDX) to ingest 10 years of active and historical records.

Advanced Skills: Perform complex object mapping from flat legacy tables into normalized Salesforce objects (Accounts, Cases, custom Disaster objects) and define a hybrid schema bridging physically migrated (10-year) and Zero Copy historical (10–25 year) data. Configure Match and Reconsolidation rules to link survivor records across 15+ years of Databricks history to active Salesforce cases. Build Parent-to-Child load sequencing (e.g., Disaster before Case) and manage Bulk API 2.0 concurrency limits and batch failures to ensure efficient, reliable dry runs and cutovers.