Description

Validate data integrity and quality across data warehouse and data lake environments using complex SQL and automation.

Responsibilities

• Implement QA standard processes for data warehouse and data lake quality assurance.
• Write complex SQL queries to perform deep data analysis and validation.
• Conduct proof of concept exercises on Snowflake-compatible automation tools.
• Integrate automation code with DevOps pipelines for CI/CD using Jenkins.
• Perform requirement analysis, defect tracking, test reporting, and root cause analysis.

Required Skills

• 5+ years of experience in ETL testing and data validation.
• Expertise in writing complex SQL queries and performing data analysis.
• Proficiency in Python, Unix, and Shell scripting.
• Experience with Snowflake, SnowSQL, and Oracle databases.
• Direct experience with ETL testing in cloud environments (AWS/Azure).
• Practical knowledge of Relational Database Management Systems (RDBMS).
• Experience with test automation tools and implementing Test Driven Development.

Preferred Skills

• Experience with reporting tools such as Tableau or Power BI.
• Familiarity with Selenium automation frameworks (Java-based).

Key Skills

Education

Any Graduate