Salesforce Data Cloud QA

Role overview

We are seeking a detail-oriented Salesforce Data Cloud QA Engineer to drive end-to-end quality assurance across our enterprise customer data platform (CDP).

In this role, you will be responsible for validating data ingestion pipelines, data lake objects (DLOs), data model objects (DMOs), identity resolution rules, unified profile accuracy, segment creation, and downstream activation targets. The ideal candidate combines hands-on Salesforce QA methodology with strong big data testing skills, complex SQL querying abilities, and deep familiarity with data architecture principles.

Key responsibilities

• Design and execute test plans to validate real-time and batch data ingestion streams into Salesforce Data Cloud from disparate sources (Salesforce Core CRM, MuleSoft, S3, Google Cloud Storage, Snowflake, Web/Mobile SDKs, and REST Ingestion APIs).
• Verify mapping logic from Data Lake Objects (DLOs) to Customer 360 Data Model Objects (DMOs), ensuring data types, schema alignment, transformations, and custom attributes strictly follow specifications.
• Validate Identity Resolution rulesets (Exact vs. Fuzzy Match, Reconciliation Rules, Consolidated Profiles).
• Verify that disparate customer records merge correctly into accurate Unified Individuals and Unified Contacts without unintended over-consolidation or data loss.
• Use Data Explorer and execute complex Data Cloud SQL (SOQL/ANSI SQL) queries inside Query Workspace to validate record counts, field-level data integrity, null/duplicate checks, and transformation accuracy.
• Test Calculated Insights (CI) metrics (e.g., Customer Lifetime Value, recency/frequency metrics) and validate business logic inside Segment Builder to guarantee accurate membership counts prior to activation.
• Validate activation flows to downstream destinations (Salesforce Marketing Cloud, Engagement, CRM core objects, S3, or external webhooks), ensuring target payloads contain accurate fields and attributes.
• Document and track defects in Jira or Azure DevOps, collaborating closely with Data Cloud Engineers, Salesforce Solution Architects, and Marketing Operations teams to resolve data discrepancies promptly.

Required skills

• Atleast 8+ years in Salesforce Quality Assurance testing, with at least 1–2 years explicitly focused on Salesforce Data Cloud (formerly CDP / Customer Data Platform) or large-scale enterprise data pipeline QA.
• Hands-on experience testing Data Ingestion, Data Mapping (DLO to DMO), Identity Resolution, Calculated Insights, and Activation workflows.
• Strong proficiency in SQL (ANSI SQL / SOQL) for querying data tables, performing joins, validating schema metrics, and executing data reconciliation checks.
• Working knowledge of Salesforce Core (Sales/Service Cloud), standard object models, and platform security controls.
• Proven experience using Jira, Xray, TestRail, or Azure DevOps for test case execution, coverage tracking, and defect management.

Preferred skills

• Salesforce Certified Data Cloud Consultant (Strongly Preferred)
• Salesforce Certified Administrator
• Experience with API testing tools like Postman to test Ingestion and Streaming APIs.
• Exposure to big data platforms (Snowflake, AWS Redshift, Databricks) or ETL/ELT pipeline testing.
• Automated data testing capability using Python or automated framework extensions.