Project descriptionWorking 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.ResponsibilitiesAnalyse and document test data, results, and recommendations.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 Data Bricks.Conduct smoke, integration, regression, and other tests on products under development and released.Collaborate with developers, business analysts, and users to understand testing needs and identify opportunities for automation and testing.Ensure that automated test scripts are created, maintained, and executed to meet all data project deliverables and testing requirements.Create test and training data.Support integrated testing.Contribute to the continuous improvement of test quality by undertaking reviews and recommending improvements.SkillsMust haveBachelor's Degree in IT, Business, Computer Science, or a related fieldSoftware Quality Assurance professional with 5+ years' experienceExtensive experience with ETL concepts & technologies, data migration testing, data warehouse testing, and BI reportingExtensive experience in data automation using PythonHigh proficiency in writing complex SQL queries in Azure Data Bricks to read data from source databases hosted in Azure and compare with target databasesProficiency in relational database models, SQL queries, XML data modelsExtensive experience with software test automation tools and working in fast-paced Agile environmentsGood knowledge of testing lifecycle processesExperience with Atlassian tools (Jira and Confluence) and integrating them into automation testing frameworksGood communication and presentation skillsExperience in Waterfall and Agile environmentsNice to haveExperience with Azure Data Factory for pipeline execution and analysisExperience with Azure Data Bricks to access data from Azure Data LakesExperience with Azure NotebooksExperience with Cosmos DBExperience in creating end-to-end CI/CD solutions using tools such as Azure DevOps, Docker, and containerization toolsISTQB CertificationExperience in the finance industry is highly desirable