Offshore Data Integration QA (SFMC / IICS / Veeva)

Job Description – Offshore Data  Integration QA (SFMC / IICS / Veeva)

We are seeking a highly skilled QA Engineer with strong expertise in ETL, APIs, and data validation to support end-to-end testing of marketing data integrations. The ideal candidate will have hands-on experience with Salesforce Marketing Cloud (SFMC), Informatica IICS, Veeva Vault, and API-based workflows, ensuring accuracy and reliability across complex data pipelines.

Key Responsibilities

Validate end-to-end data workflows from web forms → IICS APIs → Veeva Vault → Salesforce Marketing Cloud.

Perform API mapping, testing, and data verification using Postman and automation scripts.

Execute ETL QA for data ingestion, transformation, and synchronization processes.

Develop and execute SQL queries to perform data reconciliation and validation across multiple environments.

Test data integration between Veeva Vault objects (e.g., CRM-like entities) and downstream marketing systems.

Ensure data consistency, completeness, and accuracy across all stages of the integration flow.

Collaborate with development and operations teams to identify issues, define test strategies, and validate fixes.

Maintain and execute regression, smoke, and performance test cases as part of deployment cycles.

Document testing processes, data mappings, and test outcomes clearly for audit and compliance.

Required Skills & Experience

Strong SQL expertise – writing complex joins, transformations, and data validation queries.

Proven experience in ETL testing, especially with Informatica IICS or similar tools.

Solid understanding of REST APIs and hands-on experience with Postman for API QA.

Experience with Salesforce Marketing Cloud (SFMC) data structures (Data Extensions, Journeys, Automations).

Familiarity with Veeva Vault or CRM-like systems for object and metadata validation.

Deep knowledge of data flow design, API payloads, and data synchronization testing.

Strong analytical, documentation, and troubleshooting skills.

Experience working in Agile / Scrum environments.

Excellent communication and collaboration abilities across technical and business teams.

Nice to Have

Experience with ETL tools like Talend, SSIS, or DataStage.

Familiarity with Salesforce SOQL and Redshift / PostgreSQL.

Exposure to marketing data models or pharma / healthcare ecosystems.

Experience in automating API / ETL validation or using QA management tools (QASE, HP ALM, etc.).