Create test scripts for data pipelines, Datamart, Reporting data and BI reports.
Implement continuous integration and continuous deployment (CI/CD) pipelines for automated testing.
Validate data accuracy, completeness, and consistency across data ingestion and data warehouse processes.
Write SQL queries for testing end to end data flow which can eventually be used in automation.
Conduct performance and load testing for data ingestion and data warehouse systems to ensure scalability and reliability.
Set up and maintain test environments, including data sets, configurations, and tools required for testing.
Generate test reports, metrics, and dashboards to provide visibility into test progress and quality status.
Document test cases, test scripts, and test results for future reference and audit purposes.
Continuously improve testing processes, tools, and methodologies to enhance test efficiency and effectiveness.
Ensure testing processes comply with data governance, security, and regulatory requirements.
Conduct security testing to identify and mitigate potential vulnerabilities in data systems.

Experience/Skills Required
6-10 years of extensive experience in BI Report Testing, ETL Testing, Data Analysis and Data Mart/Data Warehouse Testing.
Proficient in writing medium to complex SQL queries for test validation alongside development.
Salesforce Object Query Language (SOQL) and experienced with Salesforce CRM.
Deep knowledge in BI Reporting tools like Cognos, Power BI, etc.
Strong understanding of Test-Driven Development (TDD) and Behavior-Driven Development (BDD) methodologies.
Results-oriented and highly organized, capable of managing multiple priorities in a fast-paced agile environment.
Experience in Test Management and Defect Management, including test execution reporting, defect tracking, and regression testing for project releases.
Familiarity with CI/CD tools like Jenkins, Bamboo, or similar.
Exceptional written and verbal communication skills, with experience working across different geographical locations and time zones.