Data QA Automation Testing-Snowflake
4 days ago
Experience:
3 to 5 Years
Experience
- 3 to 5 years of experience in QA automation, with a strong focus on testing data pipelines, ETL/ELT processes, and data quality validation across platforms such as Oracle, SQL Server, and Snowflake.
- Proven experience in leading small teams or mentoring junior engineers.
Technical Skills
- Strong expertise in QA practices for data platforms, including designing automated quality frameworks, validating data pipelines, and risk-based testing.
Proficiency in automated testing strategies and tooling, with specific languages, frameworks, and CI/CD tools:
Languages: Python (pandas, sqlalchemy, pytest), SQL (ANSI SQL, T-SQL, PL/SQL), and familiarity with Java/Scala for Spark jobs where applicable.
- Data testing & validation frameworks: Great Expectations, Soda, Amazon Deequ, dbt tests, pytest (with fixtures for data), and custom SQL-based test suites.
- Data platforms & libraries: Snowflake (including Snowpark APIs, Streams, Tasks, Time Travel), Oracle, SQL Server, and experience validating transformations from source → Snowflake.
- ETL/Orchestration tools: Apache Airflow, Dagster, or equivalent job orchestrators; familiarity with tools like Informatica or Talend is a plus.
- CI/CD & Automation: Jenkins, GitLab CI/CD, GitHub Actions, or Azure DevOps for pipeline integration; containerization with Docker and familiarity with Kubernetes for test environments.
- Version control & collaboration: Git, GitHub/GitLab workflows, code review and merge request based validation.
Test management & monitoring: TestRail for test case management, plus reporting and dashboarding tools (e.g., Allure, Grafana) for data quality metrics and alerts.
Strong analytical and troubleshooting skills to quickly isolate defects and drive process improvements.
- Effective communication and collaboration skills to work closely with Product Owners, Delivery Coaches, Engineering, and business stakeholders.
We are looking for a detail-oriented and innovative QA Automation Engineer to design, develop, and execute automated testing solutions and comprehensive test plans for Source Systems and Business Data Products. The ideal candidate will have strong expertise in validating the integrity, accuracy, and consistency of enterprise data across multiple business domains.
This role is responsible for ensuring the quality of data processed through ETL pipelines and data modeling scripts across platforms such as Oracle, SQL Server, and Snowflake. The QA Automation Engineer will collaborate closely with data engineering, QA, and business teams to support scalable, reliable, and high-quality data delivery across the organization.
Key Responsibilities
Design and Develop Automated Data Quality Tests:
Build reusable automated tests to validate data ingestion, transformations, and loading across Oracle, SQL Server, and Snowflake.
Verify data integrity, completeness, schema conformity, and business logic through all layers — from raw landing zone to curated data products.
Ensure End-to-End Data Pipeline Validation:
Automate testing for ETL/ELT processes, including data staging, cleansing, fact and dimension population, and final consumption layers.
Monitor transformations and data flows across platforms (Oracle → Snowflake, SQL Server → Snowflake, etc.).
Leverage Snowflake-Specific Testing Capabilities:
Utilize Snowflake's native SQL features (e.g., streams, tasks, time travel, variant types) in test development.
Automate regression and functional testing for Snowflake data models, stored procedures, materialized views, and Snowpark-based transformations.
Build and Maintain a Cross-Platform Test Framework:
Extend or integrate automation frameworks compatible with Oracle, SQL Server, and Snowflake.
Apply data validation tools (e.g., Great Expectations, Soda, Deequ) to verify transformation accuracy and data quality rules.
Utilize TestRail for Test Case Management:
Design, document, and maintain test cases and test plans in TestRail.
Track execution, report defects, and ensure traceability across automated and manual test cases.
Collaborate Across Data Engineering and Modeling Teams:
Work with data engineers, modelers, and analysts to define test criteria for ingestion jobs, business logic, and reporting outputs.
Provide early feedback on development tickets and participate in code reviews.
Support CI/CD and Test Automation in Production Pipelines:
Integrate automated tests into CI/CD workflows using tools such as Jenkins, GitLab CI/CD, GitHub Actions, or Azure DevOps.
Ensure pipeline-based test execution for pull requests and releases, containerize test environments (Docker) where appropriate, and validate data integrity during production releases, schema updates, and migrations.
Develop Monitoring and Alerting for Data Quality:
Implement anomaly detection and alerting for critical pipelines (e.g., volume drops, schema drift, business rule violations).
Create dashboards or automated reports for monitoring data quality trends.
Ensure Test Coverage, Reusability, and Documentation:
Maintain reusable and version-controlled test suites across platforms.
- Document test strategies, data quality standards, and platform-specific practices.
Skills: qa automation,snowflake,data quality,etl,sql,oracle
-
QA Automation Engineer
4 days ago
Hyderabad, Telangana, India Informica Technoservices Full time ₹ 15,00,000 - ₹ 25,00,000 per yearRoles & ResponsibilitiesDesign, develop, and execute automated test scripts for QA validation.Perform data quality checks across platforms including Oracle, SQL Server, and Snowflake.Validate ETL/ELT processes to ensure accurate data migration and transformation.Collaborate with development and data engineering teams to identify, report, and resolve...
-
QA Automation Engineer
4 days ago
Hyderabad, Telangana, India helpgini Full time ₹ 8,00,000 - ₹ 12,00,000 per year*QA Automation Engineer*Department Information TechnologyExper:- 5 to 7 YearsCompensation (Yearly)INR(₹) 800,000 to 1,200,000Location:- HyderabadMandatory SkillsQA Automation, ETL/ELT Process, Oracle SQL, Snowflake Snowflake QA*Additional Skills**Job Description*Looking for a detail-oriented and innovative QA Automation Engineer to design, develop, and...
-
QA Automation Testing Engineer
4 days ago
Hyderabad, Telangana, India Vipany Management Consulting Full time ₹ 10,00,000 - ₹ 18,00,000 per yearWe are seeking a highly skilled QA Automation Engineer with 4 - 5 years of experience in building and maintaining scalable test automation frameworks. The ideal candidate will have strong expertise in TypeScript, Cypress, Selenium, and API & UI automation with a solid background in microservices architecture and CI/CD pipelines.You will play a key role in...
-
QA & Test Automation Engineer
2 hours ago
Hyderabad, Telangana, India Amgen Technology Private Limited Full time ₹ 4,00,000 - ₹ 8,00,000 per yearTest Automation Engineering Career CategoryInformation Systems Job Description Test Automation Engineer ABOUT AMGEN Amgen harnesses the best of biology and technology to fight the world's toughest diseases, and make people's lives easier, fuller and longer. We discover, develop, manufacture and deliver innovative medicines to help millions of...
-
Hyderabad, Telangana, India YO IT CONSULTING Full time ₹ 6,00,000 - ₹ 18,00,000 per yearTitle : Database QA Automation EngineerLocation : HyderabadExperience : 3-5 yearsWork Mode - 5 days (Work from office )Must Haves : - QA Automation - ETL/ELT Process - Oracle - SQL - Snowflake - Snowflake QARole Overview : We are looking for a detail-oriented and innovative QA Automation Engineer to design, develop, and execute automated testing...
-
Database Quality Assurance Automation Tester
2 days ago
Hyderabad, Telangana, India Yo Hr Consultancy Full time ₹ 15,00,000 - ₹ 25,00,000 per yearExperience : to 5 years of experience in QA automation, with a strong focus on testing data pipelines, ETL/ELT processes, and data quality validation across platforms such as Oracle, SQL Server, and Snowflake. - Proven experience in leading small teams or mentoring junior engineers. Technical Skills : - Strong expertise in QA practices for data...
-
Automation Testing
2 days ago
Hyderabad, Telangana, India NTT DATA Full time ₹ 20,00,000 - ₹ 25,00,000 per yearReq ID: 311362NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Automation Testing to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). Senior Quality Engineer - Remote How...
-
QA Automation Tester
2 days ago
Hyderabad, Telangana, India NTT DATA Global Delivery Services Ltd Full time ₹ 5,00,000 - ₹ 12,00,000 per yearQA Automation Tester Req ID: 331150 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a QA Automation Tester to join our team in Hyderabad, Karnātaka (IN-KA), India (IN). Who we...
-
Senior QA Automation Test Engineer
2 days ago
Hyderabad, Telangana, India Sage It Full time ₹ 6,00,000 - ₹ 18,00,000 per yearJob Title: Senior Automation Test EngineerLocation: [Hyderabad Remote / Hybrid]Employment Type: Full-timeJob Summary:We are seeking an experienced Senior Automation Test Engineer to lead and expand our automation testing efforts across core mortgage technology platforms. This is a hands-on role focused on designing and building test automation frameworks...
-
Senior QA Automation Test Engineer
4 days ago
Hyderabad, Telangana, India Servicebots Technologies Full time ₹ 6,00,000 - ₹ 18,00,000 per yearJob Description:We are looking for a skilled SDET/QA Automation Engineer with hands-on experience in automation testing frameworks and strong scripting abilities. The ideal candidate will be responsible for designing, developing, and maintaining automated test scripts to ensure the quality and reliability of our web and mobile applications.Key...