Software Engineer AutomationTester

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.)

Good 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.