Etl Tester

HCLTech; Nagpur District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

HCLTech in Nagpur is seeking an ETL Testing Engineer with 3-5 years of hands-on experience in Data Warehouse/ETL Testing and cloud migration projects. You will validate data migration from on-premise systems to cloud-based platforms, ensuring data accuracy, completeness and quality throughout the migration lifecycle.

Responsibilities include end-to-end ETL testing, data validation, complex SQL testing, and collaborating with data engineers, developers and business users.

Qualifications

• 3-5 years of ETL testing experience in data warehousing environments
• Strong SQL validation skills and data quality focus
• Experience with cloud migration projects and data migration validation

Responsibilities

• Perform end-to-end testing of ETL and Data Migration workflows.
• Validate source-to-target data mappings, transformation logic, and business rules.
• Create test scenarios, test cases, test data, and execute test plans.
• Perform data validation, reconciliation, and data quality testing.
• Write complex SQL queries to compare and validate large datasets.
• Validate batch loads, incremental loads, and historical data migrations.
• Perform functional, integration, system, regression, and UAT testing.
• Log, track, and retest defects using defect management tools.

Skills

ETL Testing

SQL

Data Warehouse

Cloud Migration

Tools

Defect Tracking Tools

Job description

Experience-3-5 years

Job Role-ETL Testing

Location-Nagpur(Work from Office)

Role & responsibilities

We are looking for a skilled ETL Testing Engineer with 3-4 years of experience in Data Warehouse/ETL Testing, Cloud Migration projects, and strong SQL validation skills. The candidate will be responsible for validating data migration from legacy/ on-premise platforms to cloud-based data platforms, ensuring data accuracy, completeness, and quality throughout the migration lifecycle.

Key Responsibilities

• Perform end-to-end testing of ETL and Data Migration workflows.
• Validate source-to-target data mappings, transformation logic, and business rules.
• Create test scenarios, test cases, test data, and execute test plans.
• Perform data validation, reconciliation, and data quality testing.
• Write complex SQL queries to compare and validate large datasets.
• Validate batch loads, incremental loads, and historical data migrations.
• Perform functional, integration, system, regression, and UAT testing.
• Analyze requirements, source-to-target mapping documents, and technical specifications.
• Log, track, and retest defects using defect management tools.
• Collaborate with developers, data engineers, architects, and business users during testing cycles.
• Support migration cutover activities and parallel run validations.