Senior Automation Tester - Cloud ETL, DW Automation

Technology, Data & Digital · Data, AI & Analytics · Data Engineering · Data Analysis

In short

We are seeking a motivated Data Tester with 2-4 years of experience to support validation activities across data ingestion, data transformation, semantic layer, and reporting solutions. The role involves executing test cases, performing data validation, and ensuring data quality. This position is based in Lucknow, India.

Responsibilities

Perform source-to-target data validation.
Validate data movement across ingestion, transformation, and reporting layers.
Execute SQL queries to verify data accuracy and completeness.
Identify and document data discrepancies.
Validate data transformations and business rules.
Verify record counts, duplicates, null values, and data mappings.
Support regression testing during releases.
Validate dimensions, attributes, and measures.
Verify business-friendly data representations.
Test simple KPI calculations and aggregations.
Validate reports and dashboards.
Verify filters, drill-downs, and report outputs.
Compare report results with backend data.
Log defects with appropriate supporting evidence.
Retest fixes and verify resolutions.
Maintain test execution documentation.

Requirements

SQL (Intermediate)
ETL/Data Testing
Basic Data Warehouse Concepts
Test Case Preparation and Execution
Defect Tracking Tools (JIRA/Azure DevOps)
Analytical and Problem-Solving Skills
Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.

Desired Qualifications

Exposure to Power BI or other BI tools
Basic Python knowledge
Healthcare domain exposure

Benefits

Supercharge your potential.
Find your career.
Find your spark.
A place that knows that helping its customers stay on top starts by putting its people first.
Global technology company, home to more than 223,000 people across 60 countries.
Delivering industry-leading capabilities centered around digital, engineering, cloud and AI.
Work with clients across all major verticals.
Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.

Skills

SQLETL/Data TestingData Warehouse ConceptsTest Case Preparation and ExecutionJIRAAzure DevOpsPythonPower BI

#Automation Tester#Cloud ETL#DW Automation#Data & Semantic Layer Tester#Data Validation#ETL/ELT Testing#BI Testing#SQL#Python#Power BI#Healthcare

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website