Data Warehouse Tester

Role: Data Warehouse Tester Location: Remote Duration: Long term Position Overview: We are looking for a skilled Data Warehouse Tester with strong proficiency in SQL and foundational knowledge of Artificial Intelligence (AI) concepts. The role involves validating large-scale data systems, ensuring data accuracy, and leveraging AI-driven approaches to enhance testing efficiency and automation. Required Skills & Qualifications: Strong hands-on experience with SQL (complex queries, joins, stored procedures, performance tuning). Solid understanding of ETL processes, data warehousing concepts, and BI tools. Knowledge of AI/ML fundamentals and their application in data validation or automation. Experience with defect tracking and test management tools (e.g., JIRA, HP ALM). Excellent analytical, problem-solving, and communication skills. Key Responsibilities: Design, develop, and execute test plans, test cases, and scripts for data warehouse and ETL processes. Perform SQL-based testing to validate data transformations, integrity, and business rules. Conduct regression, functional, and performance testing across data warehouse environments. Collaborate with developers, analysts, and data engineers to identify and resolve defects. Apply AI techniques (e.g., machine learning models, predictive analytics) to optimize test coverage, detect anomalies, and improve data quality validation. Document test results, defects, and provide clear reporting to stakeholders. Ensure compliance with data governance, security, and quality standards. Preferred Qualifications: Exposure to cloud-based data platforms (AWS, Azure, Google Cloud Platform). Familiarity with AI frameworks (TensorFlow, PyTorch, Scikit-learn) for anomaly detection or automated testing. Knowledge of data modeling, dimensional schemas, and reporting tools. Experience with automation frameworks for data testing.