Etl Tester

Minimum Required Experience : 5 years

Full Time

**Skills**:

- SQL- Sparksql- python- JavaScript- CI/CD- Azuresql- Language - Java- INFORMATICA- AzuredevopsDescription
- Should be able to handle both manual and automation testing.
- Understand the existing system landscape from a functional/ business and systemic standpoint.
- Interact with product management, project management and development teams to develop a strong understanding of the data existing landscape
- Should be able to identify business requirements including data sources, target systems, transforma
- tions required, business rules required to be applied and existing data model from the mapping document.
- Should be able to test complex SQL scripts including Spark SQL
- Develop and lead the automation strategy/effort and generate scripts to perform automated testing cy
- cles using Selenium and Python
- Develop test plans covering test scenarios, test cases and execution, strategies, and procedures for val
- idating data pipelines, data storage, and ETL processes in Azure environments and On prem Should be able to do Python scripting using Pandas and such libraries for data comparisons Should be able to create frameworks for test data automation using Python Pip/anaconda. Should have experience in tools like - QuerySurge, ETL validator, Informatica Data validator, etc.
- Proficiency in writing automated test scripts in languages such as Java, Python, or JavaScript Managing Code repositories (Git Actions/Azure Pipelines), implementing Continuous testing tool (Git Actions/Azure Pipelines)
- Integrate automated tests into CI/CD pipelines using tools like Azure DevOps.
- Create, maintain, and execute automated test scripts to validate Azure data services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, etc.
- Automate data validation and integrity tests for data ingestion, transformation, and storage.
- Identify, log, and track defects identified through automated testing.
- Work closely with developers to provide clear and detailed bug reports, reproduce issues, and validate fixes.
- Design data quality checks and validation criteria for Azure data services.
- Develop monitoring solutions to proactively detect and resolve data issues.
- Set up alerts to identify data quality issues in real time and ensure prompt resolution
- Identify, report, and track defects related to data quality and performance.
- Work closely with developers, product managers, business analysts, and QA team members to under
- stand features, requirements, and test coverage expectations.
- Participate in agile ceremonies like sprint planning, retrospectives, and stand-up meetings to ensure testing alignment with development cycles.
- Collaborate with data engineering teams to resolve identified issues and prevent regressions.
- Execute regression test and investigate test failures
- Have to work in Agile -SCRUM environment
- Have to be good in Data Analysis.
- Should have excellent SQL skills and clear understanding on data life cycle
- Should have experience in Python scripting and using Pandas and such libraries for data comparisons Should have experience in creating/using frameworks for test data automation using Python Pip/anaconda.
- Should have experience in tools like - QuerySurge, ETL validator, Informatica Data validator, etc.
- Proficiency in writing automated test scripts in languages such as Java, Python, or JavaScript Managing Code repositories (Git Actions/Azure Pipelines), implementing Continuous testing tools (Git Actions/Azure Pipelines)
- Should have worked as a data automation tester in ETL projects involving multiple layers/stages of database processing with various kinds of sources/targets like files, Oracle, SQL Server, and Webservices. Delta Lake etc....
- Good interpersonal, communication, and organizational skills
- The ability to work and team effectively with team and management personnel across geographies Flexibility to adjust to multiple demands, shifting priorities, ambiguity, and rapid change should be proficient in database and data warehouse testing
- Experience in Agile/ Devops
- Experience in data migration testing