Find your next job. Start today.

From the employer's own careers site

Senior Automation Test Lead - ETL, DW Automation

Date Posted: Oct 26, 2026
Apply on company website
Sign in to keep track of your applications.
Get jobs like this sent to you
Your own AI Job Agent checks every new job against your CV and sends only the ones that fit, on WhatsApp. ₹199 a month, GST included. Full refund if it does nothing.
Start my Job Agent on WhatsApp

Job Detail

  • location_on
    Location Madurai, Tamil Nadu, India
  • desktop_windows
    Job Type: Full Time/Permanent
  • schedule
    Shift:
  • analytics
    Career Level:
  • group
    Positions:
  • calendar_view_day
    Experience:
  • male
    Gender: No Preference
  • school
    Degree:
  • calendar_month
    Apply Before: Dec 30, 2026

Job Description

Job Summary

Role Overview

The role focuses on validating end‑to‑end ETL pipelines built on Teradata and Informatica, ensuring data accuracy, performance, and reliability across large‑scale data‑warehouse environments. The engineer will design test strategies, build test cases, automate regression suites, and work closely with development, data engineering, and operations teams. Experience with Control‑M for job scheduling and workflow monitoring is essential.

Key Responsibilities

Key Responsibilities

  • Analyse business requirements, data mappings, and ETL design documents to define comprehensive test strategies for data‑warehouse solutions.
  • Develop and execute functional, integration, system, and regression test cases for ETL workflows.
  • Validate data transformations, aggregations, and load processes using advanced SQL queries.
  • Perform source‑to‑target data validation, data profiling, and reconciliation across large datasets.
  • Perform data load using Informatica PowerCenter & BMC Control-M.
  • Monitor, validate and troubleshoot Control-M scheduled jobs, dependencies, and batch execution flows.
  • Log, track, and retest defects using tools like Zephyr & JIRA.
  • Closely collaborate with Developers, Business analysts, Data Analysts, and Business stakeholders to clarify requirements, resolve data issues, and ensure alignment with business expectations.
  • Build and maintain test automation frameworks for repetitive ETL validation tasks (Python, shell scripting, or SQL‑based automation).
  • Work with Git Version control, performing activities such as branch creation, pulling, pushing , merging code and conflict resolution.
  • Document test results, create defect reports, and maintain traceability across requirements, test cases, and execution cycles.
  • Support UAT cycles, production validation, and post‑deployment checks.

Skill Requirements

Required Skills and Experience

  • Strong hands-on experience in ETL/Data Warehouse Testing.
  • Expertise in source‑to‑target mapping (STTM) validation, data reconciliation, and data profiling.
  • Advanced SQL skills (Joins, subqueries, window functions, aggregations).
  • Solid experience with ETL workflows/pipelines, mappings, and transformations.
  • Working knowledge of job schedulers like Control-M, IBM Tivoli, etc., for job monitoring, and troubleshooting.
  • Familiarity with data modelling concepts (star schema, snowflake, SCDs).
  • Experience with defect management tools such as JIRA, Azure DevOps, or HP ALM.
  • Ability to analyse complex data flows and identify gaps or inconsistencies.
  • Strong communication skills and ability to work with cross‑functional teams.
  • The engineer is expected to operate effectively within Agile/Scrum teams, contributing to iterative delivery of data‑warehouse and ETL capabilities.

Preferred / Nice‑to‑Have

  • Experience with automation frameworks for ETL testing (Python, SQL automation).
  • Knowledge of Unix/Linux for log analysis and scripting.
  • Understanding of CI/CD pipelines for data engineering.
  • Banking/Financial services domain experience (Credit Risk, Regulatory Reporting, BASEL, IFRS)
  • Experience working in regulatory or data-intensive environments. 

Other Requirements

Required Skills and Experience

  • Strong hands-on experience in ETL/Data Warehouse Testing.
  • Expertise in source‑to‑target mapping (STTM) validation, data reconciliation, and data profiling.
  • Advanced SQL skills (Joins, subqueries, window functions, aggregations).
  • Solid experience with ETL workflows/pipelines, mappings, and transformations.
  • Working knowledge of job schedulers like Control-M, IBM Tivoli, etc., for job monitoring, and troubleshooting.
  • Familiarity with data modelling concepts (star schema, snowflake, SCDs).
  • Experience with defect management tools such as JIRA, Azure DevOps, or HP ALM.
  • Ability to analyse complex data flows and identify gaps or inconsistencies.
  • Strong communication skills and ability to work with cross‑functional teams.
  • The engineer is expected to operate effectively within Agile/Scrum teams, contributing to iterative delivery of data‑warehouse and ETL capabilities.

Preferred / Nice‑to‑Have

  • Experience with automation frameworks for ETL testing (Python, SQL automation).
  • Knowledge of Unix/Linux for log analysis and scripting.
  • Understanding of CI/CD pipelines for data engineering.
  • Banking/Financial services domain experience (Credit Risk, Regulatory Reporting, BASEL, IFRS)
  • Experience working in regulatory or data-intensive environments. 

Source: HCLTech careers — Read the original posting and apply

This role is listed by the employer on its own careers site. Kaam Ki Khoj does not process applications for it.

See how well you match this job

Make a free profile in a minute — no CV needed — and we score every job against it.

Make my profile

Already registered? Sign in

Company Overview

HCLTech
HCLTech · Noida, Uttar Pradesh, India
12,223 open roles

HCLTech is an employer in the IT/Computers - Software, Software Services sector with operations in India. This is a directory listing maintained by Kaam Ki Khoj so that candidates can find the organisation; it is not an official company page and Kaam... Read More

Apply safely

From the employer's own careers site. Kaam Ki Khoj reads this job from careers.hcltech.com. You apply there, on the employer's own website.

Applying is free. A genuine employer never asks you to pay: no registration fee, deposit, training fee or kit charge, and never your OTP or bank PIN. If anyone asks for money for this job, it is a scam.

How to spot a fake job · Check an offer free

Report this job

Related Jobs

One upload, every employer

Let the right employer find you

Upload your CV once — we read it, build your profile and put you in front of every employer hiring on Kaam Ki Khoj. No forms, no fees.

Upload your CV Browse jobs