Opening For Test engineer with ETL And Power BI

Tekskills Inc.; Dadri; On-site; INR 600,000 - 900,000; Full time

Job summary

Tekskills Inc. in India seeks an ETL and Power BI Tester specialized in Azure Data Factory, Python, and Pytest.

You will design and automate tests for ETL pipelines deployed to Azure, validating data flows, transformations, and system behaviors using Python and Pytest within CI/CD pipelines. Responsibilities include writing test plans and cases, validating data mappings with SQL queries, performing data profiling, and maintaining the test automation framework to ensure reliable, high-quality

Qualifications

• Experience designing and executing tests for Azure Data Factory ETL pipelines.
• Strong SQL skills for validating data mappings and profiling.
• Proficiency in Python and Pytest for automation within CI/CD.

Responsibilities

• 1. Design and develop and execute manual and automated test cases for Azure Data Factory ETL pipelines using python and pytest.
• 2. Validate the data transformations, data mappings, and data integrity through SQL queries and data profiling.
• 3. Automate functional, regression, and perfomance tests of ETL workflows to ensure pipeline reliability.
• 4. Collaborate with data engineers, analysts and developers to understand ETL and POWER BI Specifications and data flow requirements
• 5. Document Test plans, Test Cases, defects, and provide the timely feedback on issues.
• 6. Maintain Test automation frameworks, leveraging Pytest fixtures and libraries such as to validate Azure data factory activities.

Skills

ETL testing

Azure Data Factory

Python

Pytest

Data profiling

SQL queries

CI/CD

Test automation

Tools

Azure DevOps

Power BI

Job description

As an ETL And Power BI Tester specializing in Azure Data Factory(ADF), Python, and Pytest will be responsible for ensuring the accuracy, integrity, and performance of ETL Pipelines deployed into Azure cloud environments. Role will involve developing and automating comprehensive test cases to validate the data flows, transformations, and system behaviours using python scripting and Pytest framework, integrated into CI/CD pipelines for Automated quality assurance.

Roles and Responsibilities:

1. 1. Design and develop and execute manual and automated test cases for Azure Data Factory ETL pipelines using python and pytest.
2. 2. Validate the data transformations, data mappings, and data integrity through SQL queries and data profiling.
3. 3. Automate functional, regression, and perfomance tests of ETL workflows to ensure pipeline reliability.
4. 4. Collaborate with data engineers, analysts and developers to understand ETL and POWER BI Specifications and data flow requirements
5. 5. Document Test plans, Test Cases, defects, and provide the timely feedback on issues.
6. 6. Maintain Test automation frameworks, leveraging Pytest fixtures and libraries such as to validate Azure data factory activities.