Description

Validate data integrity and quality across data warehouse and data lake environments.

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 to recommend organizational solutions.
• Perform requirement analysis, defect tracking, test reporting, and root cause analysis.
• Integrate automation code with DevOps pipelines for CI/CD using tools like Jenkins.

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.
• Ability to work within Agile/Scrum methodologies.
• Strong skills in defect tracking and partnering with developers to resolve QA findings.

Preferred Skills

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

Key Skills

Education

Any Graduate