ETL/Data Warehouse Tester

Job Summary

The ETL/Data Warehouse Tester will play a critical role in ensuring the quality and accuracy of data within the ETL processes and data warehouse systems. This position is responsible for validating data transformations, executing test cases, and ensuring that BI reports and dashboards function correctly, ultimately contributing to the organization's data integrity and decision-making processes.

Responsibilities

• Execute and validate ETL processes using tools such as SSIS and IBM DataStage.
• Test and validate BI dashboards in Tableau, ensuring reports and visualizations are accurate and meet business requirements.
• Develop and run complex SQL queries for data validation and reconciliation tasks.
• Assess and verify source-to-target mappings (STTM) and transformation logic throughout the ETL lifecycle.
• Collaborate effectively with cross-functional teams in Agile/Scrum environments to enhance testing processes and capture requirements.
• Document testing procedures and present findings to stakeholders, ensuring transparency and communication of data quality.

Qualifications

• Experience: 3–8 years in ETL, Business Intelligence (BI), or Data Warehouse testing.
• Technical Skills:
  • Hands-on experience with ETL tools such as SSIS and IBM DataStage.
  • Strong SQL expertise for data validation, reconciliation, and executing complex queries.
  • Knowledge of Tableau BI dashboards for report validation.
  • Solid understanding of data warehouse concepts and data modeling.
• Soft Skills: Strong communication and collaboration skills, particularly within Agile/Scrum teams.

Preferred Skills

• Familiarity with data quality tools and data governance frameworks.
• Experience with automated testing tools and methodologies.

Experience

• A minimum of 3 years of relevant experience in ETL and Data Warehouse environments is required.