NextHire Try for free

JobWorld

Posted 24 Jul 2025

Hadoop QA

Apply with NextHire Auto Apply fills in the application for you.
Team
CGI India Global Delivery Center
Posted
24 Jul 2025

About the role

Job Title: ETL Test Engineer – Python, SQL & Automation

Experience Required: 6+ Years

Location: Hyderabad, India

Job Type: Full-time / Permanent

Work Mode: [Onsite / Hybrid / Remote – specify as needed]

Job Summary:

We are seeking a highly skilled ETL Test Engineer with a strong background in ETL testing, SQL, Python scripting, and test automation. The ideal candidate will be responsible for validating data pipelines, ensuring data quality, and automating test processes for large-scale data environments.

Key Responsibilities:
  • Design and execute comprehensive ETL test cases, test scenarios, and test plans.
  • Perform data validation, data integrity, and data quality testing across source and target systems.
  • Write complex SQL queries to verify data accuracy and transformations.
  • Develop and maintain Python scripts to automate data validation and regression tests.
  • Work closely with data engineers and analysts to understand ETL workflows and business logic.
  • Automate repetitive test cases and integrate them into CI/CD pipelines.
  • Conduct root cause analysis of defects and ensure timely resolution.
  • Document test results, defects, and provide detailed reports to stakeholders.
Technical Skills Required:
  • ETL Testing – experience validating data flows, transformations, and load processes
  • SQL – strong hands-on experience writing and optimizing complex queries (Oracle, Teradata, or similar)
  • Python – experience with scripting for automation, data parsing, and validation
  • Automation Tools – experience with test automation frameworks (e.g., PyTest, Selenium, or custom frameworks)
  • Data Warehousing Concepts – understanding of star/snowflake schema, fact/dimension tables
  • Version Control – Git, Bitbucket
Qualifications:
  • Bachelor’s degree in Computer Science, Engineering, or related field
  • 6+ years of experience in ETL/data warehouse testing
  • Excellent understanding of QA methodologies, test planning, and defect management
  • Strong problem-solving, analytical, and communication skills
Nice to Have:
  • Experience with Big Data tools (Hadoop, Spark, Hive)
  • Knowledge of CI/CD pipelines (Jenkins, Azure DevOps)
  • Exposure to cloud data platforms (AWS, GCP, or Azure)
  • Experience with BI report validation (Tableau, Power BI)


85% of jobs are never posted

The AI Outreach Agent writes to recruiters and hiring managers at the companies you pick, from your own Gmail.

Try AI Outreach