Project description
Working within the client's test and government framework, you will be responsible for creating the automation framework to support all data warehousing progression and regression testing and fix the defects.
Responsibilities
1. Analyse and document test data, results, and recommendations.
2. Perform functional and non-functional testing for data validation between source and target databases as per business requirements, using relevant Azure components such as Azure Data Factory, Azure Notebooks, Azure Functions, and Azure Databricks.
3. Conduct smoke, integration, regression, and other tests on products under development and after release.
4. Collaborate with developers, business analysts, and users to understand testing needs and identify opportunities for automation and testing.
5. Ensure that automated test scripts are created, maintained, and executed to meet all data project deliverables and testing requirements.
6. Create test and training data.
7. Support integrated testing.
8. Contribute to the continuous improvement of test quality through reviews and recommendations.
Skills
Must have
* Bachelor's Degree in IT, Business, Computer Science, or a related field.
* Software Quality Assurance professional with 5+ years of experience.
* Extensive experience with ETL concepts & technologies, data migration testing, data warehouse testing, and BI reporting.
* Extensive experience in data automation using Python.
* High proficiency in writing complex SQL queries in Azure Data Bricks, from business requirements to read data from source databases hosted in Azure and compare with target databases.
* Proficiency in relational database models, SQL queries, and XML data models.
* Extensive experience with software test automation tools and working in fast-paced Agile environments.
* Good knowledge of testing lifecycle processes.
* Experience with Atlassian tools (Jira and Confluence) and integrating them into automation testing frameworks.
* Good communication and presentation skills.
* Experience in Waterfall and Agile environments.
Nice to have
* Experience with Azure Data Factory for pipeline execution and analysis.
* Experience with Azure Data Lake and Azure Databricks.
* Experience with Azure Notebooks.
* Experience with Cosmos DB.
* Experience in creating end-to-end CI/CD solutions using Azure DevOps, Docker, and containerization tools.
* ISTQB Certification.
* Experience in the finance industry is highly desirable.
#J-18808-Ljbffr