Lead ETL Automation Engineer

Perficient

10 - 15 years

20 - 30 Lacs

hyderabad chennai bengaluru

Posted:-1 days ago| Platform:

Apply

Skills Required

testing etl sql lead

Work Mode

Hybrid

Job Type

Full Time

Job Description

Key responsibilities

Validate ETL mappings, transformations, and data flows endtoend across source, staging, and target systems.
Design and execute test cases for functional, regression, data integrity, and reconciliation testing.
Write and run complex SQL queries to verify data volumes, joins, aggregations, NULLs, duplicates, and referential integrity.
Create test data, compare extracts, and verify incremental loads and historical data (CDC) scenarios.
Log, triage, and follow up on data defects with engineering and data owners; verify fixes and retest.
Support automation of repetitive validation checks using scripts (Shell/Python) or SQL automation where possible.
Participate in release activities, UAT, and provide clear test evidence and data validation artifacts.

Required skills & experience

Strong handson experience in ETL/data validation and SQL (joins, window functions, groupings, subqueries, CTEs).
Experience with relational databases (Oracle, SQL Server, MySQL, or PostgreSQL) and data warehousing concepts.
Solid test design skills: test cases, test data, defect reporting (JIRA or similar).
Good analytical and problemsolving skills with attention to data accuracy and edge cases.

Good to have

Scripting knowledge (Shell, Python) to automate validation steps or data prep.
Familiarity with ETL tools (Informatica, Talend, SSIS) or cloud ETL (AWS Glue, Azure Data Factory).
Exposure to automation testing frameworks or SQL-based testing tools.

More Jobs at Perficient

Lead Technical Consultant [Devops]

Maharashtra

10 - 15 yrs

INR 15 - 30 Lacs

Senior Salesforce Marketing cloud

Bangalore Rural, Karnataka, India

Experience: Not specified

Salary: Not disclosed

API Integration (PAN India, Remote)

Pune, Maharashtra, India

3.0 - 3.0 yrs

Salary: Not disclosed

.NET Fullstack Lead Developer (Pune, Nagpur)

Pune, Maharashtra, India

8.0 - 8.0 yrs

Salary: Not disclosed

Senior NLP Analyst

Maharashtra

5.0 - 10.0 yrs

INR 10 - 20 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.