Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Quality Assurance Automation Engineer ETL/Datawarehouse Testing.
India Jobs Expertini

Urgent! Quality Assurance Automation Engineer - ETL/Datawarehouse Testing Job Opening In Hyderabad – Now Hiring Worksconsultancy

Quality Assurance Automation Engineer ETL/Datawarehouse Testing



Job description

<p><p><b>1) Design and Develop Automated Data Quality Tests :</b><br/></p><p><br/></p><p>- Build reusable automated tests to validate data ingestion, transformations, and loading across Oracle, SQL Server, and Snowflake.<br/></p><p><br/></p><p>- Verify data integrity, completeness, schema conformity, and business logic through all layers from raw landing zone to curated data products.</p><p><b><br/></b></p><p><b>2) Ensure End-to-End Data Pipeline Validation :</b><br/></p><p><br/></p><p>- Automate testing for ETL/ELT processes, including data staging, cleansing, fact and dimension population, and final consumption layers.<br/></p><p><br/></p><p>- Monitor transformations and data flows across platforms (Oracle ?

Snowflake, SQL Server ?

Snowflake, etc.).</p><p><b><br/></b></p><p><b>3) Leverage Snowflake-Specific Testing Capabilities :</b><br/></p><p><br/></p><p>- Utilize Snowflake's native SQL features (e.g., streams, tasks, time travel, variant types) in test development.<br/></p><p><br/></p><p>- Automate regression and functional testing for Snowflake data models, stored procedures, and materialized views.</p><p><b><br/></b></p><p><b>4) Build and Maintain a Cross-Platform Test Framework :</b><br/></p><p><br/></p><p>- Extend or integrate automation frameworks compatible with Oracle, SQL Server, and Snowflake.<br/></p><p><br/></p><p>- Apply data validation tools to verify transformation accuracy.</p><p><b><br/></b></p><p><b>5) Utilize TestRail for Test Case Management :</b><br/></p><p><br/></p><p>- Design, document, and maintain test cases and test plans in TestRail.<br/></p><p><br/></p><p>- Track execution, report defects, and ensure traceability across automated and manual test cases.</p><p><b><br/></b></p><p><b>6) Collaborate Across Data Engineering and Modeling Teams :</b><br/></p><p><br/></p><p>- Work with data engineers, modelers, and analysts to define test criteria for ingestion jobs, business logic, and reporting outputs.<br/></p><p><br/></p><p>- Provide early feedback on development tickets and participate in code reviews.</p><p><b><br/></b></p><p><b>7) Support CI/CD and Test Automation in Production Pipelines :</b><br/></p><p><br/></p><p>- Integrate automated tests into CI/CD workflows.<br/></p><p><br/></p><p>- Validate data integrity during production releases, schema updates, and Develop Monitoring and Alerting for Data Quality :</b><br/></p><p><br/></p><p>- Implement anomaly detection and alerting for critical pipelines (e.g., volume drops, schema drift, business rule violations).<br/></p><p><br/></p><p>- Create dashboards or automated reports for monitoring data quality trends.</p><p><b><br/></b></p><p><b>9) Ensure Test Coverage, Reusability, and Documentation :</b><br/></p><p><br/></p><p>- Maintain reusable and version-controlled test suites across platforms.<br/></p><p><br/></p><p>- Document test strategies, data quality standards, and platform-specific :</b><br/></p><p><br/></p><p>- Bachelors or Masters degree in computer science, Data Engineering, or a related :</b><br/></p><p><br/></p><p>- 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.<br/></p><p><br/></p><p>- Proven experience in leading small teams or mentoring junior Skills :</b><br/></p><p><br/></p><p>- Strong expertise in QA practices for data platforms, including designing automated quality frameworks, validating data pipelines, and risk-based testing.<br/></p><p><br/></p><p>- Proficiency in automated testing strategies, TestRail for test management, Snowflake QA automation features, and scripting/CI/CD tools to maintain system accuracy and efficiency.</p><br/></p> (ref:hirist.tech)


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Quality Assurance Potential: Insight & Career Growth Guide