Looking to advance your career in Artificial Intelligence Testing, ETL Validation, and Data Quality Engineering? Here’s an exciting opportunity from CGI, one of the world’s leading IT consulting and digital transformation companies.
CGI is actively hiring experienced Functional AI Testers with strong expertise in ETL Testing, SQL, Python Scripting, and Functional Testing for its Pune office. If you have hands-on experience validating complex data pipelines and ensuring the quality of enterprise data applications, this role offers an excellent opportunity to work on next-generation AI-enabled solutions while collaborating with global teams.
๐ Position Details
๐ข Position: Functional AI Tester (ETL Testing)
๐ Job ID: Not Mentioned
๐ Location: Pune
๐ผ Experience Required: 5+ Years
โก Notice Period: Immediate / Early Joiners Preferred
๐ข Work Model: Not Specified
๐งช Domain: AI Testing | ETL Testing | Data Quality Engineering
๐ ๏ธ Skills Required
โ
ETL Testing
โ
Functional Testing
โ
SQL Query Writing
โ
Python Scripting
โ
Data Validation
โ
AI Application Testing
โ
Database Testing
โ
Test Case Design
โ
Defect Tracking
โ
Root Cause Analysis
โ
SDLC & STLC
โ
Agile Methodology
โ
Analytical & Problem-Solving Skills
โ
Communication Skills
๐ Position Overview
CGI is looking for experienced Functional AI Testers who can validate enterprise ETL applications and AI-enabled data solutions. The selected candidate will be responsible for ensuring data accuracy, validating business logic, testing data transformation pipelines, writing optimized SQL queries, and supporting high-quality software releases. This role is ideal for professionals who enjoy solving complex data validation challenges, working with modern AI-driven systems, and collaborating with cross-functional engineering teams. Candidates with strong ETL Testing experience, Python scripting knowledge, and excellent analytical abilities will be well-positioned for success in this opportunity.
๐ฏ Key Responsibilities
๐น Perform end-to-end Functional Testing for ETL and Data applications.
๐น Validate source-to-target data transformation.
๐น Write and optimize SQL queries for backend validation.
๐น Develop Python scripts for test automation and data verification.
๐น Design comprehensive test cases and test scenarios.
๐น Execute Regression, Functional, Integration, and System Testing.
๐น Identify, document, prioritize, and retest software defects.
๐น Work closely with developers, business analysts, and data engineers.
๐น Validate AI-enabled business workflows and data outputs.
๐น Prepare execution reports and quality metrics.
๐น Participate in Agile sprint planning, reviews, and retrospectives.
๐น Ensure software quality throughout the SDLC lifecycle.
๐ข About the Company
CGI is one of the world’s largest independent IT and business consulting services organizations, serving clients across banking, healthcare, manufacturing, telecommunications, government, insurance, retail, automotive, and many other industries. With decades of experience in delivering digital transformation solutions, CGI specializes in software engineering, cloud computing, cybersecurity, artificial intelligence, business consulting, enterprise applications, and data analytics. Employees at CGI work on large-scale international projects while benefiting from continuous learning, collaborative culture, and long-term career growth opportunities.
๐ Why This Opportunity is Valuable
Working at CGI provides exposure to enterprise-grade projects involving AI, cloud technologies, advanced analytics, and modern testing methodologies. Professionals gain opportunities to work with global clients, enhance technical expertise, collaborate with experienced architects, and contribute to mission-critical business applications. The company also promotes continuous learning, certifications, and structured career development.
๐ Why This Role is Good for Freshers
Although this specific opening requires 5+ years of experience, it serves as an excellent career target for aspiring QA professionals. Freshers can prepare by learning Manual Testing, SQL, ETL concepts, Python programming, API Testing, Agile methodologies, and database validation. Building projects in these areas, earning relevant certifications, and gaining practical experience through internships can significantly improve the chances of qualifying for similar roles in the future.
๐ฐ Expected Salary Range
๐ต Estimated Salary: โน10 LPA โ โน20 LPA
(Actual compensation depends on experience, interview performance, technical expertise, location, and internal company policies.)
๐ Expected Interview Rounds
1๏ธโฃ Resume Shortlisting
2๏ธโฃ HR Screening
3๏ธโฃ Technical Round โ ETL Testing & SQL
4๏ธโฃ Python Scripting Assessment
5๏ธโฃ Functional Testing Scenario Discussion
6๏ธโฃ Managerial / Project Discussion
7๏ธโฃ HR & Salary Negotiation
8๏ธโฃ Offer Release
๐ Preparation Tips
โ Revise ETL Testing concepts thoroughly.
โ Practice SQL joins, subqueries, window functions, and aggregations.
โ Strengthen Python scripting fundamentals.
โ Review Functional Testing methodologies.
โ Understand Data Warehousing concepts.
โ Learn ETL workflows and validation strategies.
โ Practice defect reporting using JIRA.
โ Revise SDLC, STLC, and Agile concepts.
โ Prepare real-time testing scenarios from previous projects.
โ Be ready to explain challenging bugs you have identified and resolved.
๐ Resume Tips
โ Keep your resume within 2 pages.
โ Highlight ETL Testing experience prominently.
โ Mention SQL proficiency with project examples.
โ Include Python automation or scripting experience.
โ Showcase measurable achievements whenever possible.
โ Mention testing tools, databases, and frameworks used.
โ Add certifications relevant to Testing, SQL, Python, or Cloud.
โ Clearly mention notice period and current location.
โ Ensure there are no grammatical or formatting errors.
โ Customize your resume according to the job description.
๐ฏ Technical Skills Recruiters Will Look For
โ
ETL Testing
โ
SQL
โ
Python
โ
Functional Testing
โ
Data Validation
โ
Backend Testing
โ
Regression Testing
โ
Integration Testing
โ
Defect Lifecycle Management
โ
Test Planning
โ
Agile Testing
โ
Analytical Thinking
โ
Communication Skills
โ
Team Collaboration
โ Frequently Asked Questions (FAQs)
Q1. Who can apply for this role?
Candidates with 5+ years of relevant experience in ETL Testing, SQL, Python, and Functional Testing.
Q2. Is this a remote position?
The opening is for Pune. The work model has not been specified in the job description.
Q3. Are immediate joiners preferred?
Yes. Immediate or early joiners will receive preference.
Q4. Is Python mandatory?
Yes. Hands-on Python scripting experience is one of the required skills.
Q5. Is ETL Testing mandatory?
Yes. Strong ETL Testing experience is one of the primary requirements.
Q6. Will AI Testing experience be beneficial?
Yes. Experience validating AI-enabled applications and data-driven systems will be an advantage.
Q7. What database skills are expected?
Candidates should have strong SQL query-writing and backend validation skills.
Q8. Is this suitable for freshers?
No. This particular opening requires experienced professionals with at least 5 years of relevant experience.
๐ฉ How to Apply
๐ง Email Your Resume: meghna.chauhan@cgi.com
๐ Suggested Subject Line: Application for Functional AI Tester (ETL Testing) โ Pune
โ ๏ธ Immediate and Early Joiners are preferred.
๐ Share this opportunity with experienced ETL Testing and AI Testing professionals in your network.
