Core Responsibilities
1. Integration & Pipeline Re-architecting Decommission Legacy SQL Layers: Analyze and phase out existing intermediate SQL relational databases currently functioning as staging layers between source systems and Salesforce.
Establish Direct Connections: Architect, develop, and deploy robust direct APIs (REST/SOAP) and event-driven patterns to connect upstream source systems directly to Salesforce.
Middleware Management: Configure and maintain integration platforms or middleware (e.g., MuleSoft, Dell Boomi, Celigo, or Azure Data Factory) to manage traffic, data orchestration, and transformation rules.
2. Data Governance & Architecture Data Mapping & Transformation: Rewrite complex SQL stored procedures, views, and ETL logic into scalable Apex, middleware logic, or declarative Salesforce flows.
Large Data Volume (LDV) Strategy: Design data models within Salesforce that handle high volumes without degrading system performance, incorporating indexing and custom skinning where necessary.
Error Handling & Reconciliation: Build end-to-end exception logging and data reconciliation mechanisms to identify and resolve synchronization failures automatically.
3. Platform Development & Optimization Custom Development: Write clean, asynchronous, and well-tested Apex code, Triggers, and Lightning Web Components (LWC) when custom programmatic solutions are needed for data intake.
Governor Limits Optimization: Guard the Salesforce environment against API throttling, row-locking issues, and governor limit breaches by implementing optimal batching and queuing strategies.
Required Skills
Preferred Skills
