Data QA Automation Engineer: Azure & DW Testing

Luxoft; Schweiz; Híbrido; USD 95.000 - 130.000; Jornada completa

Descripción de la vacante

Luxoft is seeking an experienced QA Automation/Testing specialist focused on data warehousing and ETL validation within a government/test framework. You will design and implement an automation framework, analyze test data, and collaborate with cross-functional teams to ensure data accuracy across source and target databases in Azure.

The ideal candidate has 8+ years in QA, strong SQL and Python skills, and hands-on experience with Azure Data Factory, Databricks, and related tools.

Formación

• Bachelor's Degree in IT, Computer Science, or related field.
• 8+ years in Software Quality Assurance.
• Extensive ETL, data migration, and data warehouse testing experience.
• Extensive experience with Python for data automation.
• Strong SQL skills in Azure Databricks to compare source vs target DBs.
• Proficiency with relational DB concepts, SQL, and XML data models.
• Experience with test automation tools in Agile environments.
• Familiarity with Atlassian tools Jira/Confluence and integration into test frameworks.
• Comfortable with Waterfall and Agile methodologies.

Responsabilidades

• Analyze and document test data, results, and recommendations.
• Perform functional and non-functional testing for data validation using Azure components.
• Conduct smoke, integration, regression, and other tests on products under development and released.
• Collaborate with developers, business analysts, and users to define testing needs and automation opportunities.
• Ensure automated test scripts are created, maintained, and executed to meet project deliverables and testing requirements.
• Contribute to continuous improvement of test quality via reviews and process improvements.

Conocimientos

ETL testing

Python scripting

SQL analytics

Azure Databricks

Data validation

Automation frameworks

Agile testing

Educación

Bachelor's Degree in IT/CS

Herramientas

Azure Data Factory

Azure Notebooks

Azure DevOps

Docker

Jira

Confluence

Cosmos DB

Descripción del empleo

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

• Analyze and document test data, results, and recommendations.
• Perform functional and non-functional testing for data validation between source and target DBs as per the business requirements using relevant Azure components such as Azure data bricks and Azure data factories.
• 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 project testing requirements.- Create test and training data.- Support integrated testing.
• Contribute to the continuous improvement of test quality by undertaking reviews and recommending improvements.

SKILLS

Must have

• 5+ years experience in data automation using Python, PySpark.
• Hands on experience in building customized Automation framework using Python, PySpark and SQL.
• Extensive experience with ETL concepts & technologies, Data migration testing, Data warehouse testing, and BI Reporting
• Hands on experience in working with CSV and JSON using PySpark.
• High level of Proficiency in writing complex SQL queries in Azure data bricks from Business requirements to read data from source DB hosted in Azure and compare it with the target DB
• Proficiency in relational database models, SQL queries, XML data models
• Extensive experience with software test automation tools and working in fast-paced Agile environments
• Experience with Azure Data Factory for pipeline execution and analysis
• Experience with Azure Databricks to access data from Azure Data Lakes
• Experience with Azure Notebooks
• Experience with Cosmos DB
• Experience in understanding in version control, CI/CD solutions using tools such as Azure DevOps.
• Experience in the Banking domain is highly desirable
• Bachelor's Degree in IT, Business, Computer Science, or a related field
• Good knowledge of testing lifecycle processes
• Experience with Atlassian tools (Jira and Confluence)
• Good communication and presentation skills
• Experience in Waterfall and Agile environments

Nice to have

• Experience with Azure Data Factory for pipeline execution and analysisExperience with Azure Databricks to access data from Azure Data Lakes• Experience with Azure Notebooks• Experience with Cosmos DB• ISTQB Certification• Experience in the finance industry is highly desirable