Job Description:

Role: ETL Test Engineer (Talend)

Experience: 3 to 5 years of experience in ETL Test Engineer

Notice Period: ASAP

Work Location: Gachibowli, Hyderabad

Duration: Permanent (Payroll will be under the client itself)

Work Mode: Hybrid (4 WFO & 1 WFH)

Job Qualification:

ETL Tools:Strong experience withTalend Data Integration(Open Studio or Enterprise).
Database/SQL:Advanced SQL skills (Oracle, Snowflake, SQL Server, or Redshift). Ability to write scripts to automate record count and checksum comparisons.
Talend Components:Familiarity withtLogCatcher,tStatCatcher,tSendMail, andtRunJob.
Scheduling Tools:Experience with Talend Administration Center (TAC or external schedulers like Control-M, Airflow, or Autosys.
Soft Skills:Strong analytical mindset to performRoot Cause Analysis (RCA)when a scheduled job fails.
Automation of data validation using Python scripting.

Role Overview:

We are looking for anETL Test Engineerwith strong experience inTalend Data Integration, data warehouse validation, job scheduling, and workflow validation. The candidate will be responsible for ensuring data accuracy, transformation correctness, performance efficiency, and stability of Talend jobs across environments.

Job Responsibilities:

1. ETL & Talend Job Validation

2.?Talend Workflow & Job Orchestration Testing

3. Talend Job Scheduling Validation

4. Talend Logs & Reports Validation

5. Performance & Volume Testing

6. Automation & CI/CD

7. Source IntegrationTesting (SFTP / API / Email)

Validate SFTP-based file ingestion (CSV, TXT, JSON, XML)
Validate REST API-based data ingestion workflows
Validate email-triggered or attachment-based file processing
Verify schema validation and error handling
Strong experience in validating SFTP-based file transfers and REST API-based data ingestion workflows, including payload validation and error handling.