Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in chennai
>
CGI
>
ETL Testing Engineer- SQL - Python

ETL Testing Engineer- SQL - Python

CGI

3 - 8 years

3 - 7 Lacs

chennai bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

python hive sql git selenium postgresql spark devops jenkins hadoop etl big data mongodb azure github sqlite airflow talend databricks sql server nosql pandas data quality cassandra kafka gitlab ssis informatica

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are seeking an experienced ETL/SQL/Python Testing Engineer to design, develop, and execute test cases for data pipelines, ETL processes, and database systems. The ideal candidate will possess strong expertise in SQL querying, ETL validation, Python scripting, and test automation to ensure data accuracy, completeness, and optimal performance.

Your future duties and responsibilities:

Develop and execute ETL test cases to validate data extraction, transformation, and loading processes
Perform ETL pipeline testing in an ADB (Azure Databricks) environment
Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems
Automate ETL testing workflows using Python, PyTest, or similar testing frameworks
Conduct data reconciliation, schema validation, and comprehensive data quality checks
Identify and report data anomalies, performance issues, and defects
Collaborate closely with Data Engineers, Analysts, and Business Teams to understand data requirements
Design and maintain test datasets for validation activities
Implement CI/CD pipelines for automated ETL testing (eg, Jenkins, GitLab CI)
Document test results, defects, and detailed validation reports

Required qualifications to be successful in this role:

ETL Testing: Strong hands-on experience with Informatica, Talend, SSIS, Databricks, or similar ETL tools
SQL: Advanced SQL skills including joins, aggregations, subqueries, and stored procedures
Python: Proficiency in Python for automation, including Pandas, PySpark, and PyTest
Databases: Experience with RDBMS (Oracle, SQL Server, PostgreSQL) and NoSQL databases (MongoDB, Cassandra)
Big Data (Good to Have): Experience with Hadoop, Hive, Spark, Kafka
Testing Tools: Familiarity with Selenium, Airflow, Great Expectations, or similar frameworks
Version Control: Git, GitHub/GitLab
CI/CD: Experience with Jenkins, Azure DevOps, or similar tools

Skills:

ETL
SQLite

More Jobs at CGI

Sap Abap Consultant

Bengaluru, Hyderabad

4 - 8 yrs

INR 12 - 19 Lacs

Junior position Software Engineer/Lead Java Fullstack

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

Lead Analyst - SAP ABAP

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

Power Bi Developer

Mumbai

5 - 8 yrs

INR 0 - 0 Lacs

Python Software Developer

Mumbai

5 - 8 yrs

INR 0 - 0 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

CGI

Information Technology and Consulting

Montreal

Login to

Please Verify Your Phone or Email

Confirm Action

ETL Testing Engineer- SQL - Python