ETL testing, SQL

We are seeking an ETL Test Engineer with expertise in ETL Testing coupled with Python automation skills, and experience in an Azure environment. The ideal candidate will have strong proficiency in SQL for data validation and be responsible for designing, developing, and executing comprehensive ETL test cases.

Key Responsibilities

• ETL Testing: Design, develop, and execute comprehensive ETL test cases and test plans to validate data extraction, transformation, and loading processes.
• SQL Proficiency: Utilize advanced SQL queries for extensive data validation, reconciliation, and integrity checks across various data sources and targets.
• Python Automation: Develop and maintain Python automation scripts for ETL testing, automating test scenarios and data validation processes.
• Azure Environment: Work with ETL processes and data solutions deployed on the Azure cloud platform.
• Test Case Development: Create detailed test scenarios, test cases, and test data for ETL processes.
• Defect Management: Identify, log, and track defects, working closely with development teams to ensure timely resolution.
• Reporting: Generate clear and concise test reports, communicating test results and quality metrics to stakeholders.
• Collaboration: Collaborate with data engineers, developers, and business analysts to understand data requirements and ensure data quality.

Required Skills and Experience

• Strong experience in ETL testing.
• Expertise in SQL for data querying and validation.
• Proficiency in Python automation for testing.
• Experience with Azure cloud environment.
• Ability to design and execute comprehensive ETL test cases.
• Strong analytical and problem-solving skills with attention to detail.

Mandatory Skills

• ETL testing
• SQL
• Automation
• Python

Desired Skills

• Experience working in Agile methodologies.
• Familiarity with other Cloud platforms or services.