QA Engineer (Snowflake and Salesforce)

Mastek; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Mastek is seeking a QA Engineer to validate data pipelines on a Snowflake-based platform and support automated testing. You will ensure data quality across ingestion, transformation, and consumption layers, while collaborating with data engineering and product teams.

The role requires 5–10 years of QA experience with Snowflake, SQL proficiency, and experience in test automation for data platforms. Salesforce Service Cloud integrations knowledge is a plus.

Qualifications

• 5–10 years of QA experience in data platforms.
• Hands-on Snowflake testing and data validation.
• Strong SQL for data verification across sources.
• Experience with end-to-end data pipeline testing.
• Experience with Salesforce Service Cloud data integrations.
• Knowledge of data governance and security testing.

Responsibilities

• Perform end-to-end testing of data pipelines, including ingestion, transformation, and consumption on Snowflake.
• Design, develop, and execute test cases for data validation and quality checks.
• Validate data accuracy, completeness, and consistency across sources and targets.
• Develop and maintain automated tests for data pipelines and workflows.
• Write and optimize complex SQL queries to verify transformations and integrity.
• Collaborate with data engineers, developers, and stakeholders to define test strategies.
• Identify, document, and track defects; ensure timely resolution with teams.
• Perform regression testing for changes in pipelines, schemas, configurations.
• Validate integrations between Snowflake and Salesforce Service Cloud.
• Contribute to QA process improvements and coverage.

Skills

Analytical skills

SQL skills

Test automation

Data validation

Education

Bachelor’s degree in CS/IT/Engineering

Tools

Snowflake

Salesforce Service Cloud

Python-based test frameworks

Job description

QA Engineer

Expected Work Experience

5 to 10 Years

Job Location

India

Job Summary

The QA Engineer Data Platform will be responsible for validating data pipelines, ensuring data quality, and supporting automated testing across a Snowflake-based data platform. The role involves end-to-end pipeline testing, test automation, and close collaboration with data engineering and product teams. Candidate must have relevant experience of 5 to 10 Years.

Key Responsibilities

• Perform end-to-end testing of data pipelines, including ingestion, transformation, and consumption layers on the Snowflake data platform.
• Design, develop, and execute comprehensive test cases and test scenarios for data validation and data quality checks.
• Validate data accuracy, completeness, and consistency across multiple data sources and target systems.
• Develop and maintain automated tests for data pipelines and data workflows using appropriate test automation frameworks and tools.
• Write and optimize complex SQL queries to validate business rules, transformations, and data integrity in Snowflake and related systems.
• Collaborate with data engineers, developers, and business stakeholders to understand data requirements and define test strategies and acceptance criteria.
• Identify, document, and track defects, and work with engineering teams to ensure timely resolution.
• Perform regression testing for changes in data pipelines, schemas, and configurations to ensure stability and reliability.
• Validate integrations between Snowflake and Salesforce Service Cloud, ensuring data flows and mappings are accurate and reliable.
• Contribute to continuous improvement of QA processes, test automation coverage, and quality standards for the data platform.
• Support root cause analysis for data issues and production defects, and help implement preventive measures.
• Ensure adherence to best practices for data security, compliance, and governance in testing activities.

Other Capabilities

• Strong analytical and problem-solving skills with attention to detail in data validation and issue analysis.
• Ability to work effectively in a contractor capacity within cross-functional and distributed teams.
• Good communication skills to clearly articulate test results, defects, and data quality issues to technical and non-technical stakeholders.
• Proactive mindset with the ability to work independently and manage priorities in a fast-paced environment.
• Adaptability to work with evolving data platforms, tools, and processes in Data Automation & AI initiatives.

Qualifications and Skills

• 5 to 10 years of experience in QA, with a focus on data platform testing and data validation.
• Hands-on experience with Snowflake, including testing data models, transformations, and performance aspects.
• Strong SQL skills for writing complex queries, joins, aggregations, and validations across large datasets.
• Experience in end-to-end pipeline testing, including ETL/ELT processes and data workflows.
• Proven experience in test automation for data platforms, using relevant frameworks and tools (e.g., Python-based frameworks, SQL automation, or data testing tools).
• Experience working with Salesforce Service Cloud, including validation of data integrations, mappings, and synchronization between systems.
• Familiarity with Data Automation & AI concepts and their impact on data quality and testing approaches.
• Understanding of data warehousing concepts, data modeling, and BI/reporting validations.
• Experience with defect tracking and test management tools.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent industry experience.