Lead Salesforce Data Cloud Quality Assurance Engineer

Job Description : About the Role :

We are looking for a Salesforce Data Cloud QA Engineer with strong hands-on experience in data validation, ETL/data-pipeline testing, Salesforce testing, and SQL-based data reconciliation. The role focuses on validating end-to-end data movement and transformation across multiple source systems into Salesforce Data Cloud.

Salesforce Data Cloud Testing :

• Perform hands-on testing of Salesforce Data Cloud capabilities and data flows.

• Validate data ingestion from multiple source systems into Data Cloud.

• Validate Data Streams, DLOs, DMOs, mappings, transformations, and data harmonization.

• Verify that source data is correctly transformed and represented within Salesforce Data Cloud.

• Validate end-to-end data journeys from source systems through Data Cloud to downstream activation.

Data Validation & ETL Testing :

• Design and execute ETL/data-pipeline test scenarios.

• Perform source-to-target validation and reconciliation using strong SQL skills.

• Validate record counts, field-level mappings, data types, transformation rules, null/default handling, aggregations, business rules, and duplicate records.

• Validate incremental and full data loads.

• Test data refresh, synchronization, and failure/recovery scenarios.

• Identify data discrepancies and trace issues across the data pipeline.

SQL & Source-to-Target Reconciliation :

• Develop complex SQL queries to validate data across source and target systems.

• Perform reconciliation at record, field, aggregate, and business-rule levels.

• Validate data completeness, accuracy, consistency, and integrity.

• Analyze large datasets and identify data anomalies.

• Create reusable SQL validation queries for regression testing.

Data Streams, DLO & DMO Validation :

• Validate Salesforce Data Cloud Data Streams and ingestion processes.

• Validate DLO and DMO mappings.

• Verify relationships between data objects.

• Validate transformations and calculated fields.

• Verify data harmonization across multiple source systems.

• Test mapping changes and their downstream impact.

Identity Resolution & Unified Profiles :

• Validate Identity Resolution rules and matching logic.

• Test duplicate and profile-matching scenarios across multiple source systems.

• Validate exact matches, partial matches, conflicting attributes, missing identifiers, duplicate profiles, false matches, and multiple-source customer records.

• Validate creation and maintenance of Unified Customer Profiles.

• Verify that the correct customer information is consolidated across systems.

Calculated Insights & Business Rules :

• Validate Calculated Insights against business requirements.

• Test aggregations, calculations, filters, and derived attributes.

• Validate rule-based scoring and scoring thresholds.

• Verify business-rule implementation and boundary conditions.

• Perform positive, negative, and boundary-value testing.

• Validate changes to calculations and their downstream impact.

Audience Segmentation & Activation Testing :

• Validate audience/segment creation based on defined business rules.

• Verify segment inclusion and exclusion criteria.

• Test boundary and negative scenarios for segmentation.

• Validate audience counts and member profiles against expected results.

• Validate activation outputs to downstream systems.

• Verify that the correct profiles/data are sent to target platforms.

API & Integration Testing :

• Perform API and integration testing across source systems, Salesforce Data Cloud, and downstream platforms.

• Validate request/response payloads, status codes, authentication, data mapping, and error handling.

• Test synchronous and asynchronous integrations.

• Validate retry, timeout, duplicate, and failure/recovery scenarios.

Required Skills :

• Salesforce Data Cloud

• Strong SQL

• ETL / Data Pipeline Testing

• Data Warehousing and Data Testing

• Source-to-target reconciliation

• Data quality and validation

• Data Streams, DLOs and DMOs

• Identity Resolution and Unified Profiles

• Calculated Insights and segmentation testing

• API Testing

• Integration Testing

• Strong defect analysis and troubleshooting

Preferred Skills :

• Snowflake

• Salesforce Financial Services Cloud (FSC)

• Marketing Cloud Engagement

• Salesforce Personalization

• Financial services / mortgage domain experience

• Automation testing and CI/CD experience

Education :

• Bachelors degree in Computer Science, Information Technology, Engineering, or a related discipline