Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Test Lead-Lead Data Testing with Python & ETL @ CGI

Home > DBA / Data warehousing

 Test Lead-Lead Data Testing with Python & ETL

Job Description

Your future duties and responsibilities:

  • Lead end-to-end data and ETL testing efforts for large-scale data platforms and pipelines
  • Develop and maintain automated test frameworks and test scripts using Python for data validation and quality assurance
  • Perform data integrity, reconciliation, and regression testing across multiple systems and environments
  • Validate ETL workflows, mappings, and transformations in tools such as Informatica, Talend, DataStage, or PySpark-based pipelines
  • Work closely with data engineering teams to understand business logic, data flows, and transformation rules
  • Design and implement data quality metrics, monitoring dashboards, and issue tracking processes
  • Conduct root cause analysis for data anomalies and collaborate with development teams for resolution
  • Drive continuous improvement in testing strategy, automation coverage, and process efficiency
  • Mentor and guide junior QA engineers in testing methodologies, scripting, and automation frameworks
Required qualifications to be successful in this role:

  • Bachelors/masters degree in computer science, Information Technology, or related field
  • 8+ years of experience in data/ETL testing, with at least 2+ years in a lead role
  • Strong expertise in Python scripting for test automation and data validation
  • Hands-on experience with ETL tools such as Informatica, Talend, DataStage, or custom Spark/SQL-based ETL
  • Strong knowledge of SQL for complex queries, joins, aggregations, and validation
  • Experience testing data warehouses, data lakes, and big data ecosystems (Cloudera, AWS, Azure, GCP)
  • Familiarity with PySpark, Airflow, or other data orchestration tools is a plus
  • Exposure to CI/CD pipelines (Jenkins, Git, Docker) for automated test execution
  • Good understanding of data governance, data lineage, and data quality frameworks
  • Excellent analytical, debugging, and communication skills
  • Preferred Skills: Experience with API testing and data exchange formats (JSON, XML)
  • Familiarity with cloud-based data services (AWS Glue, Redshift, BigQuery, Snowflake)
  • Knowledge of Agile/Scrum methodologies
  • Experience with pytest, unittest, or other Python-based test frameworks
Skills:
  • Informatica
  • Oracle
  • Shell Script

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time

Contact Details:

Company: CGI
Location(s): Hyderabad

+ View Contactajax loader


Keyskills:   Data Testing regression testing sql docker git redshift spark gcp jenkins debugging bigquery etl big data azure snowflake python airflow talend data lineage regression data governance scrum agile aws informatica finance

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Azure Data Architect-Subcon

  • Birlasoft
  • 4 - 6 years
  • Bengaluru
  • 3 days ago
₹ Not Disclosed

ETL Tester - Senior Engineer

  • Iris Software
  • 6 - 8 years
  • Noida, Gurugram
  • 5 days ago
₹ Not Disclosed

Application Database Administrator-NoSQL Cloud Databases

  • IBM
  • 3 - 7 years
  • Mumbai
  • 8 days ago
₹ Not Disclosed

Senior SME - Unix & Linux (UL1)

  • Microland
  • 8 - 12 years
  • Pune
  • 8 days ago
₹ Not Disclosed

CGI

CGI Information Systems and Management Consultants