Senior Automation Engineer

frenzoft; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A tech company in Chennai seeks an ETL Automation Engineer with strong expertise in Python for automation framework development and advanced SQL skills. The ideal candidate should have hands-on ETL testing experience, be able to design scalable data testing frameworks and validate complex data pipelines. Knowledge in tools like Informatica and basic Selenium is required. This position allows for immediate joining and is remote for interview purposes.

Qualifications

• Strong hands-on experience in ETL testing and data validation.
• Experience with data warehouses and data lakes.
• Basic Selenium knowledge for UI validation.

Responsibilities

• Design scalable data testing frameworks.
• Validate complex data pipelines.
• Collaborate closely with data engineering teams.

Skills

ETL testing

Python programming

SQL expertise

Data validation

Tools

Informatica

Talend

DataStage

SSIS

Oracle

SQL Server

PostgreSQL

MySQL

Snowflake

Redshift

Big Query

Job description

ETL Automation Engineer

Notice Period: Immediate to 1-week joiners.

Mandatory skills: ETL QA – Python Frameworks, SQL, BFSI

Mode of Interview: Virtual

Work Preference:

About the Role

We are seeking an expert ETL Automation Engineer with deep expertise in Python-based automation framework development, strong ETL testing experience, and advanced SQL skills. The ideal candidate will design scalable data testing frameworks, validate complex data pipelines, and collaborate closely with data engineering teams. Basic Selenium knowledge is required for limited UI validation and automation support.

Requirements

• Strong hands-on experience in ETL testing and data validation.
• Experience with data warehouses and data lakes.
• Knowledge of ETL tools such as Informatica, Talend, DataStage, SSIS, or similar
• Strong understanding of data transformations, mappings, and business rules
• Expert-level Python programming.
• Knowledge of Python testing frameworks (PyTest / unit test)
• Experience with logging, exception handling and reusable utilities
• Advanced SQL expertise.
• Hands-on experience with Oracle, SQL Server, PostgreSQL, MySQL, Snowflake, Redshift, or Big Query.
• Ability to tune and optimize SQL queries for large datasets.