ETL Data Tester

Your future duties and responsibilities

CGI is looking for experienced ETL Data Tester with a strong background in Hadoop, Teradata/Informatica, and solid SQL/HQL expertise. The ideal candidate will be responsible for validating complex data pipelines, ensuring data integrity, and supporting automation in the testing process.
Key Responsibilities: Perform end-to-end ETL data validation, data integrity, and data quality checks across Hadoop and Teradata/Informatica environments. Develop and execute SQL/HQL queries to verify data transformations and data flow across systems. Collaborate with data engineers and developers to understand business requirements and map them into test cases. Prepare detailed test plans, test cases, and defect reports. Work on Python-based test automation scripts for ETL validation (preferred). Identify, analyze, and troubleshoot data-related issues in ETL processes. Participate in Agile ceremonies and provide regular testing updates to stakeholders.

Required qualifications to be successful in this role

Minimum 5 years of experience in ETL Data Testing.
Hands-on experience with Hadoop and Teradata/Informatica. Strong SQL/HQL query writing and debugging skills. Knowledge of Python for automation or scripting. Good understanding of data warehousing concepts and ETL workflows. Excellent problem-solving, analytical, and communication skills.

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.