Position Description

Key Responsibilities

ETL & Data Testing

Validate data between source and target systems (DB2, Oracle, MySQL, etc.)

Perform data reconciliation, data completeness, and transformation validation

Write complex SQL queries for data validation and analysis

Test ETL pipelines across layers (Landing → Raw → Derived → Mart)

Identify and troubleshoot data discrepancies

Automation Testing (Python)

Develop and maintain automation frameworks using Python

Automate ETL validation (data comparison, counts, schema validation)

Integrate automation with CI/CD pipelines

Generate test execution reports and dashboards

UI Testing (Playwright)

Design and execute UI automation scripts using Python + Playwright

Validate data displayed in dashboards (e.g., Tableau or web portals)

Handle dynamic elements, filters, and UI validations

Perform cross browser testing

API Testing

Test REST APIs using tools like Postman / Python requests / REST Assured

Validate API responses, schema, and data consistency

Automate API test cases and integrate with frameworks

Perform negative and edge case testing

Performance Testing (JMeter)

Design and execute performance test plans using Apache JMeter

Conduct load, stress, and scalability testing

Analyze performance metrics (throughput, response time, error rate)

Identify bottlenecks and provide optimization suggestions

Required Skills

Strong experience in ETL Testing & Data Warehousing concepts

Proficiency in Python programming

Hands on experience with Playwright (UI Automation)

Strong SQL Skills (joins, Aggregations, Window Functions)

Experience in API testing and automation

Experience with Apache JMeter for performance testing





Knowledge of AWS services (S3, Glue, Athena, Redshift) is a plus

Familiarity with CI/CD tools (Jenkins, Git, etc.)

Positive to Have

Experience in cloud based ETL pipelines

Knowledge of data migration testing

Experience with Tableau or BI dashboards validation

Exposure to Agile/Scrum methodology

Your future duties and responsibilities

Required Qualifications To Be Successful In This Role

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.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

Come join our team—one of the largest IT and business consulting services firms in the world.

📌 Software Engineer AutomationTester (Bengaluru)
🏢 CGI
📍 Bengaluru