Lead II - SFDC ETL Tester
UST Global · Thiruvananthapuram · onsite · Posted 34d ago
Undisclosed10–12 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Title: Salesforce ETL Tester
Experience Range
- 10 to 12 Years of Salesforce experience
- Strong expertise in Salesforce Data Architecture, Data Quality, Data Governance, and Deduplication Strategies
Hiring Location
- Chennai / Trivandrum / Kochi / Bangalore / Pune / Noida / Gurgaon / Kolkata
Must-Have Skills
- Salesforce Sales Cloud
- Salesforce Health Cloud
- Salesforce Data Quality Management
- Salesforce Data Architecture
- Salesforce Data Governance
- Data Deduplication & Merge Strategies
- Salesforce Account, Lead, Contact & Opportunity Data Models
- Salesforce Record Relationships & Security Model
- SOQL
- Salesforce Apex & Batch Apex
- Workflow Automation & Flows
- Data Validation
- REST APIs
- Real-Time & Batch Integrations
- Data Analysis & Root Cause Analysis
- Matching, Scoring & Survivorship Rules
- Technical Documentation & Executive Reporting
- Stakeholder Management
Good-to-Have Skills
- ETL Tools (Informatica, MuleSoft, Talend, SSIS)
- IBM InfoSphere MDM
- MuleSoft Integration
- Salesforce Platform Events
- Data Migration & Data Cleansing
- Master Data Management (MDM)
- Integration Architecture
- Enterprise Data Governance Frameworks
- Salesforce Data Architect Certification
- Salesforce Application/System Architect Certification
Job Description
Role Overview
We are seeking a highly experienced Salesforce Data Quality & Deduplication Lead to drive enterprise-wide data quality initiatives across Salesforce Sales Cloud and Health Cloud environments. The ideal candidate will have deep expertise in Salesforce data models, governance frameworks, duplicate management, data remediation strategies, and integration architectures.
This role will be responsible for assessing current-state data quality challenges, defining remediation and prevention strategies, and delivering executive-level recommendations to improve data accuracy, consistency, and reliability across the Salesforce ecosystem.
Key Responsibilities
- Lead Salesforce data quality and deduplication initiatives across Sales Cloud and Health Cloud.
- Analyze existing Salesforce data and identify duplicate trends, root causes, and business impact.
- Design and implement matching, scoring, survivorship, and merge strategies.
- Develop comprehensive data governance and quality frameworks.
- Perform Salesforce data cleansing, normalization, enrichment, and remediation activities.
- Design scalable solutions using Salesforce native capabilities, Apex, and integration platforms.
- Collaborate with business stakeholders, architects, and development teams to define optimal remediation approaches.
- Evaluate and recommend data synchronization and integration strategies.
- Support real-time and batch integrations with enterprise systems.
- Develop and optimize SOQL queries for data analysis and validation.
- Create technical documentation, architecture recommendations, and implementation roadmaps.
- Present findings and recommendations to technical and executive leadership teams.
Key Deliverables
Data Assessment & Analysis
- Comprehensive Salesforce Data Quality Assessment Report
- Current-State Analysis
- Duplicate Trend Analysis
- Root Cause Identification
- Business Impact Assessment
Data Remediation Strategy
- Historical Data Cleanup Approach
- Matching Rules Framework
- Scoring Rules Design
- Survivorship Logic Definition
- Merge Strategy Recommendations
Future-State Operating Model
- Duplicate Prevention Framework
- Ongoing Data Quality Governance Model
- Daily Merge Processing Framework
- Monitoring & Reporting Strategy
Solution Architecture Recommendations
- Salesforce Native Data Quality Capabilities
- Apex-Based Deduplication Solutions
- ETL & Batch Processing Approaches
- Event-Driven & Integration Publishing Mechanisms
- Integration Architecture Recommendations
Implementation Planning
- Effort Estimation
- Risk Assessment
- Implementation Roadmap
- Documentation for Business & Technical Stakeholders
Required Qualifications
- 10+ years of Salesforce Sales Cloud and/or Health Cloud experience.
- Strong background in Salesforce Data Architecture, Data Quality, and Data Governance.
- Deep understanding of Salesforce Account, Contact, Lead, Opportunity, and custom object data models.
- Advanced proficiency in SOQL.
- Hands-on experience with Salesforce Apex and Batch Apex.
- Experience in data cleansing, migration, deduplication, and data remediation programs.
- Strong understanding of Salesforce security, sharing, and data relationships.
- Experience defining matching rules, merge logic, and survivorship frameworks.
- Experience with REST API integrations and enterprise integration patterns.
- Ability to independently perform data analysis and provide actionable recommendations.
- Strong communication and stakeholder management skills.
Preferred Qualifications
- Salesforce Certified Data Architect
- Salesforce Application Architect or System Architect Certification
- Experience with Informatica, MuleSoft, Talend, SSIS, or similar ETL platforms
- IBM InfoSphere MDM experience
- Experience with enterprise MDM implementations
- Experience in healthcare or large-scale enterprise Salesforce environments
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
InformaticaAutomationTrend AnalysisSolution architectureMonitoringworkflowHealthcaresalesforcedata analysispublishing
About UST
UST Global
IT Services & Consulting
14.0k+
employees
1999
27 years old
Aliso Viejo, California
US
₹12.9L PA avg
Avg at UST
About
UST helps the world's best organizations succeed through digital transformation, crafting disruptive solutions and strategies bringing our clients vision to life.
Industries
IT Services & ConsultingManufacturing
Employee ratings
0 reviews
3.7/ 5
Employees rate it well for
Work-Life Balance38Company Culture37
Find them on