Job Description

Company Profile:

We're 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. You'll help shape digital solutions for a global enterprise--from the ground up.

This is more than a job. It's 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? Let's 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

Bachelor's/master's 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

Together, as owners, let's turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll 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. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction.



Your work creates value. You'll 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.



You'll shape your career by joining a company built to grow and last. You'll 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 team--one of the largest IT and business consulting services firms in the world.