QA Automation Engineer Department Information Technology Exper - 5 to 7 Years Compensation Yearly INR 800 000 to 1 200 000 Location - Hyderabad Mandatory Skills QA Automation ETL ELT Process Oracle SQL Snowflake Snowflake QA Additional Skills 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 robust 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 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 Education Bachelor s or Master s degree in computer science Data Engineering or a related field Experience 5 to 7 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 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 Soft Skills Excellent problem-solving and analytical skills Strong communication interpersonal skills to liaise effectively with clients and team members Demonstrated accountability ownership and a proactive approach to solving problems A proactive mindset with the ability to adapt to new technologies and frameworks Additional Information Interview process There are 3 Technical rounds in the interview process 2 Technical rounds- with internal team of Logic Pursuits 3rd Technical round- Client round Required Qualification Bachelor of Engineering - Bachelor of Technology B E B Tech Job Insights Important Tips to source better This is 5 days work from office role Preference will given to local candidates from Hyderabad Questionnaire Question1 Open to relocate to Hyderabad Desired answer yes Question2 Experience in data quality validation across platforms such as Oracle SQL Server and Snowflake Desired answer yes Question3 Experience in Scripting CI CD tools Desired answer yes Question4 Proficiency in TestRail for test management Desired answer yes Question5 Experience in Snowflake QA Automation Desired answer Minimum 5 years Email Resume - shilpig hr gmail com Whatsapp at - (phone hidden) https www linkedin com in shilpi-goel-56a79b15 Job Types Full-time Permanent Pay 800 000 00 - 1 200 000 00 per year Work Location In person Speak with the employer 91 (phone hidden)