Testing Associate

Requirement Understanding: Collaborate with cross-functional teams, including data engineers, ETL developers, business analysts, and product owners, to understand project requirements and work with the QA lead to define a comprehensive test strategy and plan.

Test Case Design: Create detailed test cases and test scenarios for ELT processes, data transformations, and reporting within Matillion and Power BI.

Data Validation: Verify the accuracy, consistency, and completeness of data transformations within Matillion and Snowflake, ensuring that data adheres to expected standards and business rules.

ELT Process Testing: Execute ELT processes in Matillion, monitor data extraction, loading, and transformations, and validate that data is correctly processed and loaded into Snowflake.

Data Quality Testing: Perform data quality checks to identify data anomalies, discrepancies, or missing values and report any issues to the development team.

Regression Testing: Test and validate changes and updates to Matillion ETL workflows, Snowflake data models, and Power BI reports to ensure that they do not introduce new issues or regressions.

Integration Testing: Verify the seamless integration between Matillion, Snowflake, and Power BI, ensuring that data flows smoothly from source to reporting based on different stages’ integration testing.

Power BI Testing: Validate the accuracy and functionality of reports and dashboards created in Power BI, including data visualization and interactive features along with the Business Team.

Data Security Testing (wherever applicable): Assess data access controls, encryption, and security measures in Snowflake, Matillion, and Power BI to ensure that sensitive data is protected.

Performance Testing (wherever applicable): Evaluate the performance of ELT processes and report generation in terms of speed, scalability, and resource utilization, identifying areas for optimization.

Error Handling Testing: Test error-handling mechanisms in ETL workflows and report generation to ensure that errors are properly captured, logged, and handled.

Test Data Management: Manage test data sets and environments, ensuring data privacy and compliance with data regulations.

JIRA Integration: Use JIRA for test case management, defect tracking, and collaboration with development teams. Create and manage test-related issues and workflows in JIRA.

Documentation: Maintain detailed documentation of test cases, test results, and any issues discovered during testing, including steps to reproduce problems in Confluence and SharePoint.

Collaboration: Collaborate closely with development teams to prioritize and address issues and ensure that fixes are properly tested and validated.

Regression Test Automation (Not Compulsory at this moment but having Automation Experience is a value add): If applicable, automate regression test cases using test automation tools and test automation frameworks to streamline testing processes and improve efficiency. FYI, test automation tool(s) and framework(s) specifications are not yet finalized at client end.

Reporting: Work with QA lead to generate test reports, summarizing the day-to-day test execution results, including any defects found, and communicate these reports to relevant stakeholders.

Continuous Improvement: Provide feedback on the quality and reliability of data processes and reports, suggesting improvements and best practices to enhance data testing procedures.