Database Tester

Watershed Consulting; Johannesburg; On-site; ZAR 350,000 - 550,000; Full time

Job summary

Watershed Consulting in Johannesburg, Gauteng, South Africa invites a Database Tester to ensure data accuracy across source and target systems, using strong SQL and data-validation skills.

The role focuses on ETL testing, data warehousing concepts, testing data pipelines, and collaborating with data engineering teams on large datasets and cloud platforms.

Onsite position with emphasis on quality assurance and reporting, suitable for candidates with 6+ years experience and a relevant IT degree.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 6+ years of experience in data testing or QA.
• Strong SQL and data validation skills for data reconciliation.
• Understanding of ETL testing and data warehousing concepts.

Responsibilities

• Perform data validation and reconciliation testing to ensure data accuracy and completeness.
• Conduct functional, integration, and end-to-end testing of data workflows and ETL processes.
• Use SQL and database querying for direct data verification and troubleshooting.
• Apply ETL testing and data warehousing concepts to verify transformation logic and mappings.
• Test data pipelines and transformations for large datasets using Big Data technologies where applicable.
• Identify and document data quality issues, inconsistencies, and defects across systems.
• Collaborate with development and data engineering teams to reproduce and resolve data-related problems.
• Prepare clear test reports, defect descriptions, and verification evidence.
• Keep current with best practices and emerging tools in database testing and Big Data.

Skills

SQL

Data validation

ETL testing

Data warehousing

Big Data

Hadoop

Spark

Hive

AWS

GCP

Problem solving

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Hadoop

Spark

Hive

AWS

Azure

GCP

Job description

Database Tester Watershed Consulting•Johannesburg, Gauteng, South Africa

Job Title

Database Tester (Onsite position)

Description

As a Database Tester, you will play a crucial role in maintaining the accuracy and integrity of our data.

You will use strong SQL and database-querying expertise to validate and reconcile data across source and target systems. With a good understanding of ETL testing and data warehousing concepts, you will identify data quality issues, validate complex transformations, and test data pipelines

. Experience with Big Data technologies and cloud platforms will be advantageous when working with large-scale datasets and distributed environments.

Responsibilities

• Perform data validation and reconciliation testing to ensure data accuracy and completeness.
• Conduct functional, integration, and end-to-end testing of data workflows and ETL processes.
• Use SQL and database querying for direct data verification and troubleshooting.
• Apply ETL testing and data warehousing concepts to verify transformation logic and mappings.
• Test data pipelines and transformations for large datasets using Big Data technologies where applicable.
• Identify and document data quality issues, inconsistencies, and defects across systems.
• Collaborate with development and data engineering teams to reproduce and resolve data-related problems.
• Prepare clear test reports, defect descriptions, and verification evidence.
• Keep current with best practices and emerging tools in database testing and Big Data.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.years
• Experience in Years: 6 +
• Strong SQL and database-querying skills for data validation and reconciliation.
• Practical understanding of ETL testing and data warehousing principles.
• Experience with Big Data technologies (Hadoop, Spark, Hive) is highly desirable.
• Experience testing data pipelines and working with large datasets.
• Familiarity with cloud platforms such as AWS, Azure, or GCP is an advantage.
• Excellent problem-solving, analytical skills, and attention to detail.
• Strong verbal and written communication skills for cross-functional collaboration.
• Ability to learn new technologies quickly and work independently.

Skills

• SQL
• ETL testing
• Data warehousing
• Data validation
• Hadoop
• Spark
• Hive
• AWS
• GCP
• Problem solving
• Communication

Job Title

Database Tester (Onsite position)

Description

As a Database Tester, you will play a crucial role in maintaining the accuracy and integrity of our data.

You will use strong SQL and database-querying expertise to validate and reconcile data across source and target systems. With a good understanding of ETL testing and data warehousing concepts, you will identify data quality issues, validate complex transformations, and test data pipelines

. Experience with Big Data technologies and cloud platforms will be advantageous when working with large-scale datasets and distributed environments.

Responsibilities

• Perform data validation and reconciliation testing to ensure data accuracy and completeness.
• Conduct functional, integration, and end-to-end testing of data workflows and ETL processes.
• Use SQL and database querying for direct data verification and troubleshooting.
• Apply ETL testing and data warehousing concepts to verify transformation logic and mappings.
• Test data pipelines and transformations for large datasets using Big Data technologies where applicable.
• Identify and document data quality issues, inconsistencies, and defects across systems.
• Collaborate with development and data engineering teams to reproduce and resolve data-related problems.
• Prepare clear test reports, defect descriptions, and verification evidence.
• Keep current with best practices and emerging tools in database testing and Big Data.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.years
• Experience in Years: 6 +
• Strong SQL and database-querying skills for data validation and reconciliation.
• Practical understanding of ETL testing and data warehousing principles.
• Experience with Big Data technologies (Hadoop, Spark, Hive) is highly desirable.
• Experience testing data pipelines and working with large datasets.
• Familiarity with cloud platforms such as AWS, Azure, or GCP is an advantage.
• Excellent problem-solving, analytical skills, and attention to detail.
• Strong verbal and written communication skills for cross-functional collaboration.
• Ability to learn new technologies quickly and work independently.

Skills

• SQL
• Database querying
• ETL testing
• Data warehousing
• Data validation
• Data reconciliation
• Data pipeline testing
• Hadoop
• Spark
• Hive
• Big Data
• AWS
• Azure
• GCP
• Data quality
• Data modelling
• Problem solving
• Communication

. Skillset Required: SQL, Database querying, ETL testing, Data warehousing, Data validation, Data reconciliation, Data pipeline testing

Design and govern enterprise data architecture, defining the strategic data models, platforms, standards and governance framworks that enable trusted, secure and scalable data solutions across the

A multinational manufacturing holding company that produces specialty coatings, sealants, and building materials for both industrial and consumer markets, is seeking a CMDB Manager who will be resp

Security Analyst (Penetration Testing).Location: Remote (South Africa) | Ideally Gauteng.Redherd is a specialist cybersecurity recruitment and advisory firm working globally with security consultan

Shift Schedule & Work Setup:- US Eastern/Central Timezone- 100% Remote – work from the comfort of your home- Applicants should be equipment ready (laptop, headset, etc.Job Summary:We're looki

A leader in alternative risk and insurance solutions, is looking for a senior Data Architect to design and drive modern, enterprise-scale Azure data platforms.Architect and deliver scalable Azure d

Key Responsibilities- Install, configure, and maintain DB2 and/or DATACOM environments.Monitor database performance and availability.Perform database upgrades and maintenance.Support backup, reco

We are seeking an experienced Lead Automation Tester to own end-to-end quality assurance across our banking and financial technology platforms.Reporting into engineering leadership, this role direc

Develop and maintain Celonis data models, transformations, and dashboards.Create Process Data Models (PDMs) and optimize data pipelines.Design KPIs, analyses, and visualizations using Celonis tools

This is a 6 – month contract with our client in the Fintech industry.Our client is seeking an AI Data Architect to design, govern, and evolve their end-to-end enterprise artificial intelligence lan