Data Migration and integration Architect

Job Description

Salesforce Data Migration and integration Developer1 Job Summary: The Data Migration developer s responsible for executing, and managing data migration projects within Salesforce environments. This role requires expertise in data extraction, transformation, and loading (ETL) processes, with a strong focus on leveraging Informatica tools. The specialist will ensure the accurate, secure, and efficient migration of data while customizing Salesforce to align with business processes and objectives. Required Skills: 4-5+ years of experience in data migration, with a focus on Salesforce applications and handling sensitive data. Proficiency in using ETL tools like Informatica (PowerCenter, Informatica Cloud), Boomi or other tools for data migration is required. Experience with Salesforce data extraction, transformation, data import/export tools, SQL, ETL processes, and data integration methodologies. Expertise in data migration tools and techniques, and familiarity with Salesforce APIs and integration methods. Migrate & integrate data from different platform into Salesforce. Prepare data migration plan and handle kickouts/fallouts. Develop procedures and script for data migration. Ability to ensure data integrity, deduplication, and performance optimization during migration. Experience handling large-scale data migrations with bulk processing. Knowledge of data validation and reconciliation post-migration. Development, implement and optimize stored procedures and functions using TSQL. Perform SQL database partitioning and indexing procedures as required to handle heavy traffic loads. Must have Strong understanding of the Salesforce data model, objects, relationships, and architecture Strong understanding of Salesforce objects (such as accounts, contacts, case, etc), custom objects, fields & restrictions. The ability to create fast and efficient database queries, including joins with several tables . Good knowledge on SQL optimization techniques. Experience in designing, creating and maintaining databases Familiarity with MuleSoft , Boomi or similar integration platforms, and experience automating processes within Salesforce. Preferred Qualifications: Salesforce Certified Administrator, Salesforce Certified Platform Developer I or II. Relevant certifications in data management, migration, or related areas.