Test Specialist - Cloud ETL, DW Automation
India
Apply now
Job Description
Test Specialist - Cloud ETL, DW Automation
Nagpur, Maharashtra

Job Summary

We are seeking a meticulous UI & ETL QA Tester with 5 to 7+ years of experience, strong SQL skills, UI Manual front end testing knowledge and experience in ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes. This role demands flexibility in working hours to facilitate effective communication with developers and project teams across various time zones.

Key Responsibilities

• Design, develop, and execute UI Front end manual test cases to validate the functionalities of the software.

• Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
• Write and execute complex SQL queries to perform data validation and back-end testing.
• Identify, report, and track defects systematically.
• Participate in project meetings and be available for discussions in US EST working hours as needed

• Clarify requirements when necessary and ensure comprehensive coverage of all requirements in the testing process.

Skill Requirements

Required Skills & Qualifications:

• Must-have: Strong SQL skills with hands-on experience in writing and optimizing complex queries

• Familiarity with data warehouses concept.

• Knowledge of Python.

• Experience in ETL Testing: Understanding of data extraction, transformation, and loading (ETL) processes.
• Experience with SQL DBMS Tools: Knowledge of database management systems such as Oracle, Denodo, Azure Databricks, SQL Server.

• Knowledge of Agile Methodologies and Defect Tracking Tools: Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA.

 

Other Requirements

1.Relevant certifications in Cloud Testing, Automation Testing, or ETL/DW automation would be a plus.
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, 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 December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.