KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_80 β€’ 3-DAY_ACTIVE_POLICY

Software Engineer – Automation Tester

Company
Company CGI
Type
Opportunity Type Full-Time Job
Salary
Stipend / Salary 5.5 LPA
Location
Location Bangalore, Karnataka
Posted Date
Posted Date Yesterday
ETL Testing Data Warehousing Python Playwright SQL API Testing Automation Testing Apache JMeter CI/CD Git AWS Cloud ETL Data Migration Testing Tableau Agile Scrum
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated quantitative and logical reasoning problems to sharpen the skills needed for CGI's online aptitude test.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Insights and sample questions from previous candidates that help you understand CGI's interview pattern and expectations.
πŸ“–
Comprehensive Interview Prep Resources Open Resource β†—
A collection of coding, database, and automation topics essential for performing well in CGI technical rounds.
πŸ“–
Algorithm & Data Structure Problem Set Open Resource β†—
Practice problems to improve coding speed and problem‑solving ability, crucial for the technical assessment at CGI.

Graduates (B.Tech/B.E., M.Tech, MCA) in Computer Science, Information Technology, Electronics, or related streams; minimum 60% aggregate (or CGPA 6.0/10); batch years 2024‑2026; no active backlogs at the time of joining; strong programming fundamentals and analytical skills.

1
Round 1: Online Aptitude Test
2
Round 2: Technical Interview (coding, SQL, automation concepts)
3
Round 3: HR Interview
CGI is a global IT and business consulting services firm with a strong presence in India. Established over four decades ago, CGI delivers end‑to‑end solutions across industries such as banking, healthcare, manufacturing, and public sector. The company prides itself on a client‑centric approach, leveraging emerging technologies to drive digital transformation. In India, CGI operates multiple delivery centres, fostering a collaborative environment where fresh talent works alongside seasoned professionals on large‑scale projects for Fortune 500 clients. As a Software Engineer – Automation Tester at CGI Bangalore, you will be part of the Software Development/Engineering team that ensures the reliability and performance of data pipelines and user‑facing applications. The role is heavily focused on ETL testing, data validation, and building robust automation frameworks using Python. You will validate data movement between source systems like DB2, Oracle, and MySQL, perform reconciliation, and verify transformation logic across multiple layers of the data warehouse. In addition, you will create UI automation scripts with Playwright, conduct API testing using Postman or Python Requests, and execute performance tests with Apache JMeter. All automation artifacts will be integrated into CI/CD pipelines, enabling continuous quality assurance. Key Responsibilities: 1. Design, develop, and maintain Python‑based automation frameworks for ETL validation, UI, API, and performance testing. 2. Write complex SQL queries to compare source and target data, verify record counts, and ensure schema integrity. 3. Perform end‑to‑end data reconciliation across DB2, Oracle, MySQL, and cloud data stores. 4. Create Playwright scripts to automate dashboard validation, handle dynamic elements, and execute cross‑browser tests. 5. Conduct API testing using Postman, Python Requests, or REST Assured, validating response payloads and error handling. 6. Execute load, stress, and scalability tests with Apache JMeter and analyse performance metrics. 7. Integrate automated test suites with Jenkins/Azure DevOps pipelines for continuous testing. 8. Collaborate with data engineers, developers, and business analysts to understand requirements and provide testing feedback. 9. Document test cases, results, and defects in test management tools. 10. Participate in Agile ceremonies, contribute to sprint planning, and continuously improve testing processes. Tech Stack: Python, Playwright, SQL, DB2, Oracle, MySQL, Postman, REST Assured, Apache JMeter, Git, CI/CD (Jenkins/Azure DevOps), AWS (S3, Glue, Athena, Redshift) – good to have. Growth Path: Starting as an Automation Tester, you can progress to Senior Test Engineer, Test Lead, or specialize as a Data Quality Engineer. CGI encourages certifications (e.g., ISTQB, AWS) and offers rotational opportunities across domains, enabling a broad skill set and leadership exposure. Why Join CGI? You will work on mission‑critical data projects for global clients, gain hands‑on experience with cutting‑edge automation tools, and benefit from a culture that values learning, mentorship, and work‑life balance. The Bangalore centre offers a vibrant campus, regular tech talks, and a clear career progression roadmap.

CGI β€” QA & Automation Testing Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC πŸ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource β†—
COMPANY GUIDE 🎯
CGI Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for CGI and off-campus tech roles.

Open Resource β†—
MOCK TESTS & PAPERS πŸ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource β†—
CODING PRACTICE πŸ’»
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource β†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (ETL Testing, Data Warehousing, Python, Playwright, SQL, API Testing, Automation Testing, Apache JMeter, CI/CD, Git, AWS, Cloud ETL, Data Migration Testing, Tableau, Agile, Scrum) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
CGI Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between Implicit Wait, Explicit Wait, and Fluent Wait in Selenium? Answer β–Ό
Model Answer: Implicit Wait sets a global timeout for all element lookups. Explicit Wait pauses execution until a specific ExpectedCondition (e.g. elementToBeClickable) is met. Fluent Wait allows defining polling frequency and ignoring specific exceptions like NoSuchElementException.
Explain the Page Object Model (POM) and its advantages in Test Automation. Answer β–Ό
Model Answer: POM is a design pattern that creates an object repository for web UI elements. It separates test scripts from page locators, reducing code duplication and making maintenance easy when UI elements change.
How do you handle dynamic WebElements whose ID changes on page reload? Answer β–Ό
Model Answer: Use dynamic XPath methods like contains(), starts-with(), text(), or XPath axes (ancestor, following-sibling, parent) instead of brittle absolute paths.
What is the difference between @BeforeMethod and @BeforeClass in TestNG? Answer β–Ό
Model Answer: @BeforeClass runs once before the first test method in the current class, while @BeforeMethod executes before each individual test method.
How do you validate REST API response codes and JSON payload using Postman / RestAssured? Answer β–Ό
Model Answer: In RestAssured: given().when().get('/endpoint').then().assertThat().statusCode(200).body('status', equalTo('ACTIVE')).
Why do you want to join CGI as a Software Engineer – Automation Tester?
Preparation Tip: Highlight CGI's market reputation, recent tech innovations, and how your skills in ETL Testing directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software & Tech

View Category Feed β†—
CGI
Software Engineer – Automation Tester
Apply Apply Now β†—
Chat Chat with Kashii