Test Lead-Lead Data Testing with Python & ETL

Position Description:

Company Profile:
Were Hiring at CGI for our GCC - Right Here in Hyderabad!
Join us at the intersection of technology finance and innovation. You will be working to support the PNC Financial Services Group one of the top-tier financial institutions in the U.S. Youll help shape digital solutions for a global enterprisefrom the ground up.
This is more than a job. Its your opportunity to:
Work on cutting-edge technologies
Collaborate with global teams
Build a career with purpose and impact
Ready to build the future of banking Lets talk.

Job Title: Test Lead-Lead Data Testing with Python & ETL
Position: Test Lead-Lead Data Testing with Python & ETL
Experience: 8 Years
Category: Testing
Main location: India Hyderabad
Shift Timings: General Shift
Employment Type: Full Time-Permanent
Position ID: J1025-0391

Job Summary:
CGI is looking for a highly skilled Lead Data Testing Engineer with strong expertise in ETL testing data validation and Python automation.
The ideal candidate will lead the data testing team ensure high-quality data pipelines and drive automation initiatives across data platforms.
This role involves close collaboration with data engineers analysts and business stakeholders to validate complex data transformations and integrations.

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.

#LI-SP40

Skills:

• Informatica
• Oracle
• Shell Script

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.