Data Quality Automation Engineer

2 weeks ago

Hyderabad, Telangana, India YO HR Consultancy Full time

Title - Data Quality Automation Engineer Snowflake

Location - Hyderabad

Experience -3 - 5 years

Role overview :

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 :

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

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

3) 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, and materialized views.

4) Build and Maintain a Cross-Platform Test Framework :

- Extend or integrate automation frameworks compatible with Oracle, SQL Server, and Snowflake.

- Apply data validation tools to verify transformation accuracy.

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

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

7) Support CI/CD and Test Automation in Production Pipelines :

- Integrate automated tests into CI/CD workflows.

- Validate data integrity during production releases, schema updates, and migrations.

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

9) Ensure Test Coverage, Reusability, and Documentation :

- Maintain reusable and version-controlled test suites across platforms.

- Document test strategies, data quality standards, and platform-specific Skills Required :

- 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, TestRail for test management, Snowflake QA automation features, and scripting/CI/CD tools to maintain system accuracy and efficiency.

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

(ref:hirist.tech)

  • Quality Engineer

    2 weeks ago

    Hyderabad, Telangana, India CONVERGIX Automation Solutions Full time ₹ 5,00,000 - ₹ 8,00,000 per year

    Role: Quality EngineerLocation Hyderabad, IndiaWe are seeking talented individuals to join our growing teamCONVERGIX Automation Solutions leverages the strengths, experience, and capabilities of our existing businesses, along with new talent, to transform and grow into the ultimate automation solutions trusted partner, capable of solving any industrial...

  • Test Automation Engineer

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time ₹ 5,00,000 - ₹ 10,00,000 per year

    Management and staff in Kofax's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Test Automation Engineer is a core, entry-level departmental role and appointees are expected to perform whole core...

  • Engineer Quality Assurance

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time ₹ 5,00,000 - ₹ 8,00,000 per year

    Management and staff in Tungsten Automation's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Engineer is a core, entry-level departmental role and appointees are expected to perform whole core departmental...

  • Quality Assurance Engineer

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time US$ 90,000 - US$ 1,20,000 per year

    Management and staff in Tungsten Automation's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Engineer is a core, entry-level departmental role and appointees are expected to perform whole core departmental...

  • Engineer Quality Assurance

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time

    Job DescriptionManagement and staff in Tungsten Automation&aposs Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Engineer is a core, entry-level departmental role and appointees are expected to perform...

  • Sr. Test Automation Engineer

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Management and staff in Tungsten Automation's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Sr. Test Automation Engineer requires that appointees are capable of making independent technical decisions on...

  • Associate Test Automation Engineer

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Management and staff in Tungsten Automation's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Associate Test Automation Engineer is treated as the beginner level position for this job family.Key...

  • Test Automation Engineer High Salary

    5 days ago

    Hyderabad, Telangana, India Tungsten Automation Full time

    Job DescriptionManagement and staff in Kofax's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. The position of Test Automation Engineer is a core, entry-level departmental role and appointees are expected to perform whole...

  • Quality Assurance Automation Engineer

    2 weeks ago

    Hyderabad, Telangana, India MindSource Technologies Full time

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

  • Principal Quality Assurance Engineer

    2 weeks ago

    Hyderabad, Telangana, India Tungsten Automation Full time US$ 1,00,000 - US$ 1,50,000 per year

    ResponsibilitiesManagement and staff in Tungsten Automation's Quality Assurance job family help the company to assure that its products and technology solutions are designed and built in accordance with company standards and customer requirements. Responsibilities of the Principal Engineer position include:Responsible for larger or more complex departmental...