Senior Automation Test Lead - ETL, DW Automation

HCL Technologies Limited

India

Presencial

INR 1 200 000 - 1 800 000

Tempo integral

Há 11 dias

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

HCL Technologies Limited is seeking an ETL/Data Warehouse Test Engineer to validate end‑to‑end ETL pipelines built on Teradata and Informatica, ensuring data accuracy and performance. The role involves designing test strategies, building test cases, and automating regression suites, with close collaboration across development, data engineering and operations teams.

Experience with Control‑M for job scheduling and workflow monitoring is essential, along with strong SQL and data profiling skills.

Qualificações

  • Strong hands-on experience in ETL/Data Warehouse Testing.
  • Expertise in source‑to‑target mapping validation and data profiling.
  • Advanced SQL skills including joins, subqueries, window functions, and aggregations.

Responsabilidades

  • Analyse business requirements, data mappings and ETL design to define 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 via SQL queries.
  • Perform data profiling, reconciliation, and source‑to‑target validation across large datasets.
  • Log, track and retest defects using JIRA, Azure DevOps or HP ALM.
  • Collaborate with developers, analysts and stakeholders to ensure alignment with business expectations.

Conhecimentos

ETL testing
Data warehouse testing
STTM validation
Advanced SQL
ETL workflows
Control‑M scheduling

Ferramentas

JIRA
Azure DevOps
HP ALM
Git

Descrição da oferta de emprego

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


  • 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.

Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Data/ETL test lead
Data/ETL test lead

Fa Etvl Saasfaprod1 • Pune District

Presencial
INR 2 400 000 - 4 200 000
ETL Test Lead
ETL Test Lead

Data Semantics • Bengaluru

Presencial
INR 1 200 000 - 1 800 000
Senior ETL QA / ETL Testing
Senior ETL QA / ETL Testing

Vivantify • Índia

Teletrabalho
INR 2 800 000 - 4 000 000
Etl Testing Engineer
Etl Testing Engineer

Infosys • Chennai District, Bengaluru, Hyderabad

Presencial
INR 900 000 - 1 500 000
Senior ETL Test Engineer
Senior ETL Test Engineer

Luxoft • Bengaluru

Presencial
INR 2 600 000 - 4 200 000
ETL/Data QA Engineer
ETL/Data QA Engineer

Luxoft • Bengaluru

Presencial
INR 1 200 000 - 1 800 000
Software Test Engineer
Software Test Engineer

Infosys • Hyderabad, Pune District, Mumbai

Presencial
INR 900 000 - 1 800 000
ETL/Data QA Engineer
ETL/Data QA Engineer

Luxoft • Pune District

Presencial
INR 1 200 000 - 1 800 000
Senior ETL Test Engineer
Senior ETL Test Engineer

Luxoft • Chennai

Presencial
INR 1 800 000 - 2 800 000
ETL Testing with Bigquery
ETL Testing with Bigquery

enGen Global • Hyderabad, Chennai

Presencial
INR 1 200 000 - 1 600 000