Data QA Engineer (Python)

Luxoft; Pune District; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

Luxoft in Pune, India seeks an experienced QA Data Engineer to design and implement an automation framework for data warehousing validation and regression testing within Azure-based environments. You will analyze test data, document results, and collaborate with cross-functional teams to improve test coverage and quality.

The role emphasizes ETL testing, SQL proficiency, and automation, with exposure to Azure Data Factory, Data Bricks, Notebooks, and DevOps tools in an agile setting.

Qualifications

• Bachelor's degree in IT, Business, Computer Science, or related field.
• Software Quality Assurance professional with 8+ 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 level of proficiency in writing complex SQL queries in Azure Data Bricks to read data from source DB in Azure and compare with target DB.
• Proficiency in relational database models, SQL queries, XML data models.
• Extensive experience with software test automation tools in 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.

Responsibilities

• Analyze and document test data, results, and recommendations.
• Perform functional and non-functional testing for data validation between source and target DBs using Azure components (Azure Data Factory, Azure Notebooks, Azure Functions).
• 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 automation opportunities.
• Ensure automated test scripts are created, maintained, and executed to meet project deliverables, create test/train data, and support integrated testing.
• Contribute to continuous improvement of test quality through reviews and recommendations.

Skills

Python

SQL

ETL testing

Data warehousing

Automation testing

Azure data bricks

Azure Data Factory

Agile methodologies

Education

Bachelor's Degree in IT, Business, Computer Science, or a related field

ISTQB Certification

Tools

Jira

Confluence

Azure Notebooks

Cosmos DB

Azure DevOps

Docker

Job description

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 bricks, Azure Notebooks, Azure functions, 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

• Bachelor's Degree in IT, Business, Computer Science, or a related field
• Software Quality Assurance professional with 8+ years' experience
• Extensive experience with ETL concepts & technologies, Data migration testing, Data warehouse testing, and BI Reporting
• Extensive experience in data automation using Python
• 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
• 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 Databricks to access data from Azure Data Lakes
• Experience with Azure Notebooks
• Experience with Cosmos DB
• Experience in creating end-to-end CI/CD solutions using tools such as Azure DevOps, Docker, and containerization tools
• ISTQB Certification
• Experience in the finance industry is highly desirable