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.).