ETL Tester

Aarushi Infotech; Chennai District; On-site; INR 1,200,000 - 1,700,000; Full time

Job summary

Aarushi Infotech in Chennai is seeking a seasoned QA professional to drive data warehouse and ETL testing efforts across BI reporting. You will validate data quality and develop robust test data sets for large data volumes.

You will design SQL-based validation, perform STM checks, and collaborate with BI and engineering teams within Agile sprint cycles. Proficiency with Jira/Confluence is expected, and experience with cloud-based data platforms is a plus.

Qualifications

• 4–8+ years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• BI applications and reporting validation.
• Strong SQL skills with complex queries.
• STM validation experience.
• ETL concepts and testing methodologies.
• Data validation, reconciliation, and data quality checks.
• Unix/Linux commands knowledge.
• Experience with Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Responsibilities

• Validate data quality and perform data validation checks across warehouses.
• Design and execute ETL test cases for Data Warehouse and BI reports.
• Validate BI reports and data reconciliations for accuracy.
• Write complex SQL queries for validations and data checks.
• Perform STM validation and ensure data lineage.
• Collaborate with Dev, BI, and business teams in Agile sprints.
• Prepare test data sets and manage large data volumes.
• Participate in sprint planning, backlog grooming, and releases.
• Utilize Jira, Confluence, Xray for test management and traceability.
• Use Unix/Linux commands in validation tasks.

Skills

Data Warehouse

ETL Testing

BI Reporting

SQL

STM Validation

ETL Concepts

Data Quality

Unix/Linux

RDBMS

API Testing

REST APIs

JSON

XML

Jira

Xray

Playwright

Selenium

JMeter

PowerCurve

Oracle

SQL Server

PostgreSQL

MySQL

Teradata

SIT/QA Standards

Tools

Jira

Confluence

Job description

Required Technical Skills

• 4–8+ years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Must Have

• 4–8+ years of hands-on experience in Software Testing / Quality Assurance.
• Strong experience in Data Warehouse and ETL Testing.
• Good exposure to Business Intelligence (BI) applications and reporting validation.
• Strong SQL skills with ability to write complex queries involving joins, subqueries, aggregations, and validations.
• Experience in Source-to-Target Mapping (STM) validation.
• Knowledge of ETL concepts and testing methodologies.
• Good understanding of data validation, reconciliation, and data quality checks.
• Working knowledge of Unix/Linux commands.
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.

Preferred Skills

• Exposure to ETL tools such as Informatica, DataStage, Talend, SSIS, Ab Initio, Azure Data Factory, or similar platforms.
• Knowledge of cloud-based data platforms such as Azure, AWS, or Google Cloud.
• Experience with Big Data technologies is an added advantage.

Project & Process Skills

Agile & DevOps

• Strong understanding of Agile Scrum methodologies.
• Good knowledge of DevOps processes and continuous testing practices.
• Experience participating in sprint planning, backlog grooming, and release activities.

Test Management Tools

Hands-on Experience With

• Jira
• Confluence (preferred)

Requirement Analysis

• Strong experience in requirement analysis and ambiguity identification.
• Ability to review business requirements and provide early feedback for quality improvements.
• Experience preparing test estimations and risk assessments.

Test Data Management

• Strong experience in identifying, creating, and maintaining test data.
• Ability to prepare mock data sets as required for testing scenarios.
• Experience handling large volumes of data for validation activities.

Stakeholder Management

• Excellent customer-facing and stakeholder communication skills.
• Experience collaborating with business users and cross-functional teams.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong analytical and problem-solving skills.

Soft Skills

• Excellent verbal and written communication skills.
• Strong analytical and critical thinking abilities.
• Detail-oriented with a focus on data accuracy and quality.
• Ability to work independently as well as within distributed teams.
• Strong collaboration and stakeholder management capabilities.
• Proactive approach towards identifying risks and quality improvements.

Skills: api testing (postman / rest apis),rest api,json,sql & database validation,xml,jira,xray,playwright,unix/linux,agile scrum,powercurve collections (pcc),oracle,swagger,selenium,jmeter