Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Employer? Claim Account for FREE

SE - Mentor

Compare

3.6

based on 52 Reviews

2 SE - Mentor ETL Tester Jobs

ETL Tester

SE-Mentor Solutions (P) Ltd

3.6

based on 52 Reviews

4-5 years

Thiruvananthapuram

1 vacancy

ETL Tester

SE - Mentor

posted 2mon ago

Job Role Insights

Flexible timing

Key skills for the job

Data Analytics Python Automation Testing Project Management Javascript Informatica

+ 4 more

Job Description

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.

2-5 years of experience in core ETL and Data testing with proficiency in manual and automation testing Ability to apply business and functional knowledge, to define testing strategy, test approach and test case design.
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

Employment Type: Full Time, Permanent

Read full job description

Prepare for ETL Tester roles with real interview advice