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 US Youll help shape digital solutions for a global enterprise?from 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 bankingLets 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, 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 team?one of the largest IT and business consulting services firms in the world,