Data Migration and integration Architect

As a Data Migration developer, your role involves executing and managing data migration projects within Salesforce environments. You will need expertise in data extraction, transformation, and loading (ETL) processes, with a specific focus on leveraging Informatica tools. Your primary responsibility will be to ensure the accurate, secure, and efficient migration of data while customizing Salesforce to align with business processes and objectives. Key Responsibilities: - Migrate & integrate data from different platforms into Salesforce. - Prepare data migration plan and handle kickouts/fallouts. - Develop procedures and scripts for data migration. - Ensure data integrity, deduplication, and performance optimization during migration. - Handle large-scale data migrations with bulk processing. - Perform data validation and reconciliation post-migration. - Develop, implement, and optimize stored procedures and functions using TSQL. - Perform SQL database partitioning and indexing procedures as required. - Understand and utilize Salesforce data model, objects, relationships, and architecture. - Create fast and efficient database queries, including joins with several tables. - Apply SQL optimization techniques. - Design, create, and maintain databases. - Familiarity with MuleSoft, Boomi, or similar integration platforms. - Experience in automating processes within Salesforce. Qualifications Required: - 4-5+ years of experience in data migration, specifically with Salesforce applications and handling sensitive data. - Proficiency in using ETL tools like Informatica (PowerCenter, Informatica Cloud), Boomi, or other data migration tools. - Experience with Salesforce data extraction, transformation, data import/export tools, SQL, ETL processes, and data integration methodologies. - Expertise in data migration tools and techniques, Salesforce APIs, and integration methods. - Strong understanding of Salesforce objects, custom objects, fields, and restrictions. - Strong understanding of SQL, data validation, and reconciliation. - Knowledge of Salesforce Certified Administrator, Salesforce Certified Platform Developer I or II is preferred. - Relevant certifications in data management, migration, or related areas are a plus.,