Quality Assurance Engineer

Mastek; Bengaluru; On-site; INR 2,000,000 - 3,800,000; Full time

Job summary

Mastek is seeking a QA Engineer Data Platform to validate data pipelines, ensure data quality, and support automated testing on 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 5 to 10 years of relevant experience. The ideal candidate will design comprehensive test cases, write optimized SQL queries, and validate data across multiple sources.

Qualifications

• 5–10 years of QA experience focused on data platforms and validation.
• Hands-on Snowflake testing across models, transformations and performance.
• Strong SQL skills for complex queries, joins, and validations.
• Experience with end-to-end ETL/ELT testing and data workflows.
• Proven test automation experience for data platforms.

Responsibilities

• Perform end-to-end testing of data pipelines (ingestion, transformation, consumption) on Snowflake.
• Design and execute test cases for data validation and data 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 validate rules and integrity.
• Collaborate with data engineers, developers, and business stakeholders on test strategies.
• Identify, document, and track defects; ensure timely resolution with teams.
• Perform regression testing for pipeline/schema/configuration changes.
• Validate integrations between Snowflake and Salesforce Service Cloud.
• Contribute to QA process improvements and testing standards.

Skills

QA experience

Data validation

Data quality checks

End-to-end testing

Test automation

Analytical thinking

Communication

Collaboration across teams

Education

Bachelor's degree in Computer Science/IT/Engineering or related field

Tools

Snowflake

Salesforce Service Cloud

Python-based test frameworks

SQL automation

SQL queries

Job description

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