Data Testing

WRKLYF Tech Pvt Ltd; Bengaluru; In loco; INR 600.000 - 1.200.000; Tempo pieno

Descrizione del lavoro

Zoho in Bengaluru is seeking a seasoned ETL and data warehouse testing specialist to ensure data integrity across pipelines. You will validate ETL jobs, write and review SQL queries, and coordinate with data engineers on complex source-to-target mappings.

The role requires hands-on experience with Oracle/SQL Server/MySQL/PostgreSQL and ETL tools such as Informatica, DataStage, Talend, or SSIS. Familiarity with cloud platforms is a plus.

Competenze

• Experience in ETL and data warehouse testing.
• Strong SQL skills with joins, subqueries, functions and aggregations.
• Hands-on testing across Oracle, SQL Server, MySQL or PostgreSQL.
• Familiarity with ETL tools like Informatica, Ab Initio, Talend, DataStage or SSIS.
• Knowledge of data warehousing concepts (facts, dimensions, star/snowflake).
• Experience validating source-to-target mappings (STTM).

Conoscenze

ETL Testing

Data Warehouse Testing

SQL

Star Schema

Snowflake Schema

STTM

Strumenti

Informatica

Ab Initio

Talend

DataStage

SSIS

Unix/Linux

Python

Shell scripting

ETL automation framework

Descrizione del lavoro

• Strong experience in ETL Testing / Data Warehouse Testing
• Excellent knowledge of SQL (joins, subqueries, functions, aggregations)
• Hands-on experience in Database Testing (Oracle / SQL Server / MySQL / PostgreSQL)
• Understanding of ETL tools such as Informatica, Ab Initio, Talend, DataStage, SSIS, or similar
• Knowledge of data warehousing concepts (facts, dimensions, star/snowflake schema)
• Experience in validating source-to-target mappings (STTM)

Good to Have

• Experience with Big Data / Cloud data platforms (AWS, Azure, Snowflake, Redshift, BigQuery)
• Knowledge of Unix/Linux commands
• Experience in Automation for ETL testing (Python, Shell, or any ETL automation framework)