ETL Tester

Aarushi Infotech; Bengaluru; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Aarushi Infotech in Bengaluru seeks an experienced Software QA/Test Engineer specializing in Data Warehouse and ETL testing. You will validate BI reports, write complex SQL queries, and perform STM validations to ensure data quality across systems.

Ideal candidates have 4–8+ years in QA, hands-on experience with ETL tools, SQL databases, and strong collaboration skills in Agile environments. This role is based in Bengaluru and requires on-site work and cross-functional coordination.

Qualifications

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

Responsibilities

• Strong understanding of agile Scrum methodologies and DevOps processes.
• Collaborate with business users and cross-functional teams to ensure quality in sprints and releases.

Skills

SQL queries

Data Warehouse

ETL Testing

BI reporting validation

STM validation

Unix/Linux

Oracle

SQL Server

PostgreSQL

MySQL

Teradata

Tools

Jira

Confluence

Playwright

Selenium

JMeter

Swagger

XRay

Powercurve Collections (PCC)

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