ETL Automation Testing

ITC Infotech; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

ITC Infotech Bengaluru is seeking an experienced ETL Testing Engineer to join our data quality initiative. You will leverage Python automation to develop robust test scripts and validate complex ETL workflows across data warehouses and lakes.

The ideal candidate has 6+ years in ETL/data testing, strong SQL skills, and hands-on experience with Informatica, Talend or SSIS, plus exposure to PySpark and cloud platforms. Agile environment and collaboration with data teams are key.

Qualifications

• 6+ years of experience in ETL/Data Testing.
• Hands-on ETL tool experience: Informatica, Talend, SSIS.
• Strong Python automation scripting and SQL skills.
• Experience with data warehousing and data lake validation.

Responsibilities

• Validate ETL workflows and data transformations.
• Develop automated test scripts using Python.
• Perform source-to-target data validation and reconciliation.
• Execute functional, regression, and integration testing.
• Collaborate with Data Engineers and Business teams to ensure data quality.

Skills

ETL Testing

Python automation

SQL

Data Validation

Data Warehousing

Tools

Informatica

Talend

SSIS

PySpark

Azure/AWS

CI/CD

JIRA

Job description

Experience: 6-12 Years

Preferred: Immediate To 15 days

Job Description: We are looking for an experienced ETL Testing Engineer with strong expertise in Python Automation and Data Validation. The candidate should have hands-on experience in ETL testing, SQL, data warehousing, and automation framework development.

Key Skills:

• 6+ years of experience in ETL/Data Testing
• Strong knowledge of Python automation scripting
• Expertise in SQL and database testing
• Experience in Data Warehouse/Data Lake validation
• Hands-on experience with ETL tools (Informatica, Talend, SSIS, etc.)
• Knowledge of PySpark, Azure/AWS, and CI/CD is a plus
• Experience with Agile methodology and defect management tools (JIRA)

Responsibilities:

• Validate ETL workflows and data transformations
• Develop automated test scripts using Python
• Perform source-to-target data validation and reconciliation
• Execute functional, regression, and integration testing
• Collaborate with Data Engineers and Business teams to ensure data quality