QA Engineer - ETL

ECS ME; Dubai; On-site; AED 183,621 - 257,069; Full time

Job summary

ECS ME is seeking a Database Tester in Dubai. The ideal candidate will have experience in testing using Amazon Redshift and Oracle, with advanced SQL knowledge. Responsibilities include planning and executing data quality tests on data warehouses and BI dashboards, building test scripts with SQL and Python, and participating in agile development processes. The role requires a thorough understanding of data quality assurance and the ability to provide detailed reports to stakeholders.

Qualifications

• Experience in database testing using Amazon Redshift and Oracle.
• Advanced SQL knowledge is essential.
• Experience with testing reports and BI dashboards is required.

Responsibilities

• Plan and execute data quality test cases on data warehouse and ETL.
• Build test scripts using SQL and Python for complex datasets.
• Execute test cases, analyze results, and pinpoint defects.
• Engage in agile methodologies with sprint planning and retrospectives.
• Provide comprehensive test execution reports to stakeholders.

Skills

Database testing using Amazon Redshift

Advanced SQL knowledge

Testing bulk data with advanced SQLs

Testing reports and BI dashboards

Tools

Python

Job description

Qualifications

• Experience in database testing using Amazon Redshift, Oracle
• Advanced SQL knowledge
• Experience in testing bulk data with advanced SQLs, Python Scripts.
• Experience in testing reports and BI dashboards

Responsibilities

• Responsible to plan and execute data quality test cases on data warehouse, ETL, reports and BI dashboards.
• Build test scripts using SQL, Python scripts 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.