Job Description
<p><p><b>Experience : </b><br/><br/>- 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/><br/>- Proven experience in leading small teams or mentoring junior engineers.</p><br/><p><b>Technical Skills : </b><br/><br/>- Strong expertise in QA practices for data platforms, including designing automated quality frameworks, validating data pipelines, and risk-based testing.<br/><br/>- Proficiency in automated testing strategies, TestRail for test management, Snowflake QA automation features, and scripting/CI/CD tools to maintain system accuracy and efficiency.<br/><br/>- Strong analytical and troubleshooting skills to quickly isolate defects and drive process improvements.<br/><br/>- Effective communication and collaboration skills to work closely with Product Owners, Delivery Coaches, Engineering, and business stakeholders.</p><br/><p><b>Key Responsibilities :</b><br/><br/><b>Design and Develop Automated Data Quality Tests : </b><br/><br/>- Build reusable automated tests to validate data ingestion, transformations, and loading across Oracle, SQL Server, and Snowflake.<br/><br/>- Verify data integrity, completeness, schema conformity, and business logic through all layers from raw landing zone to curated data products.</p><br/><p><b>Ensure End-to-End Data Pipeline Validation : </b><br/><br/>- Automate testing for ETL/ELT processes, including data staging, cleansing, fact and dimension population, and final consumption layers.<br/><br/>- Monitor transformations and data flows across platforms (Oracle Snowflake, SQL Server Snowflake, etc.</p><br/><p><b>Leverage Snowflake-Specific Testing Capabilities : </b><br/><br/>- Utilize Snowflake's native SQL features (e.g., streams, tasks, time travel, variant types) in test development.<br/><br/>- Automate regression and functional testing for Snowflake data models, stored procedures, and materialized views.</p><br/><p><b>Build and Maintain a Cross-Platform Test Framework : </b><br/><br/>- Extend or integrate automation frameworks compatible with Oracle, SQL Server, and Snowflake.<br/><br/>- Apply data validation tools to verify transformation accuracy.</p><br/><p><b>Utilize TestRail for Test Case Management : </b><br/><br/>- Design, document, and maintain test cases and test plans in TestRail.<br/><br/>- Track execution, report defects, and ensure traceability across automated and manual test cases.</p><br/><p><b>Collaborate Across Data Engineering and Modeling Teams : </b><br/><br/>- Work with data engineers, modelers, and analysts to define test criteria for ingestion jobs, business logic, and reporting outputs.<br/><br/>- Provide early feedback on development tickets and participate in code reviews.</p><br/><p><b>Support CI/CD and Test Automation in Production Pipelines : </b><br/><br/>- Integrate automated tests into CI/CD workflows.<br/><br/>- Validate data integrity during production releases, schema updates, and migrations.</p><br/><p><b>Develop Monitoring and Alerting for Data Quality : </b><br/><br/>- Implement anomaly detection and alerting for critical pipelines (e.g., volume drops, schema drift, business rule violations).<br/><br/>- Create dashboards or automated reports for monitoring data quality trends.</p><br/><p><b>Ensure Test Coverage, Reusability, and Documentation : </b><br/><br/>- Maintain reusable and version-controlled test suites across platforms.<br/><br/>- Document test strategies, data quality standards, and platform-specific practices.</p><br/><p>Skills : oracle,data quality,sql (ref:hirist.tech)