Data Warehouse QA Engineer - SQL, Python, Redshift

ECS; Dubai; On-site; AED 120,000 - 180,000; Full time

Job summary

ECS Dubai is seeking a data quality tester to ensure accuracy of data in the data warehouse, ETL, and BI dashboards. The role focuses on validating database integrity using Amazon Redshift and Oracle, with advanced SQL and Python scripting to verify bulk data loads.

The candidate will plan and execute test cases, generate detailed execution reports, and collaborate in an Agile team with sprint planning and daily stand-ups to drive improvements.

Qualifications

• Experience in database testing using Amazon Redshift, Oracle.
• Advanced SQL knowledge required.
• Testing bulk data with advanced SQLs and Python scripts.

Responsibilities

• Plan and execute data quality test cases on data warehouse, ETL, reports and BI dashboards.
• Build test scripts using SQL and Python to handle high volume and complex datasets.
• Execute test cases and analyze results to pinpoint defects and areas for enhancement.
• Engage in agile development methodologies, including sprint planning, daily stand-ups, and retrospective meetings.
• Provide comprehensive test execution reports to project stakeholders.

Skills

Advanced SQL

Tools

Amazon Redshift

Oracle

Python

Job description

ECS Dubai is seeking a data quality tester to ensure accuracy of data in the data warehouse, ETL, and BI dashboards. The role focuses on validating database integrity using Amazon Redshift and Oracle, with advanced SQL and Python scripting to verify bulk data loads.

The candidate will plan and execute test cases, generate detailed execution reports, and collaborate in an Agile team with sprint planning and daily stand-ups to drive improvements.