Salesforce Data Synchronization
- Tech Stack: Salesforce, php, Mysql, Salesforce Dataloader, dataloader.io, Salesforce Import/ Export Wizard, Aurora and Eventbrite API
Bulk Data import/export (CSV/Excel) from databases like TAM into Salesforce. Understanding Database structure, Mapping database tables and columns with Salesforce objects and fields, importing data including tasks, activities and files.
Auto synchronization between SQL and salesforce data using core PHP, SQL and creating cron jobs in php.
Maintenance of core functionality of the projects previously built code and building new classes and objects according to the requirements of the project. Maintain the API calls inside and outside of the organization with php code and AWS servers.
Roles and responsibilities include creation of processes between Mysql and Salesforce and creating campaigns, workflows, process builder etc along with management of users and their profiles, assigning permission to users.
Maintenance of data and core functionalities using apex and looking after the dependencies for including new classes and objects, Maintaining workflow rules and validations.
Creation of queries to filter data form Database, create mapping, write php scripts to import data to salesforce.