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

Jobs

Interviews

Home
>
Jobs in chennai
>
CGI
>
ETL Testing with Python

ETL Testing with Python

CGI

5 - 10 years

4 - 8 Lacs

chennai

Posted:1 day ago| Platform:

Apply

Skills Required

etl informatica testing python talend data bricks hive continuous integration pyspark ci/cd data warehousing sql etl tool spark jenkins hadoop pytest automation testing airflow microsoft azure sql querying nosql etl testing pandas ssis aws

Work Mode

Work from Office

Job Type

Full Time

Job Description

Experience: 5-12 Years
Location: Bangalore Employment Type: Full-time Job Summary: We are looking for 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 should have strong expertise in SQL querying, ETL validation, Python scripting, and test automation to ensure data accuracy, completeness, and performance. Technical Skills Required: - ETL Testing: Strong experience in testing Informatica, Talend, SSIS, Databricks, or similar ETL tools. - SQL: Advanced SQL skills (joins, aggregations, subqueries, stored procedures). - Python: Proficiency in Python for test automation (Pandas, PySpark, PyTest). - Databases: Hands-on experience with RDBMS (Oracle, SQL Server, PostgreSQL) & NoSQL (MongoDB, Cassandra). - Big Data Testing (Good to Have): Hadoop, Hive, Spark, Kafka. - Testing Tools: Knowledge of Selenium, Airflow, Great Expectations, or similar frameworks. - Version Control: Git, GitHub/GitLab. - CI/CD: Jenkins, Azure DevOps, or similar. Soft Skills: - Strong analytical and problem-solving skills. - Ability to work in Agile/Scrum environments. - Good communication skills for cross-functional collaboration. #LI-AD11

Your future duties and responsibilities:

- Develop and execute ETL test cases to validate data extraction, transformation, and loading processes.
- Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems. - Automate ETL testing workflows using Python, PyTest, or other testing frameworks. - Perform data reconciliation, schema validation, and data quality checks. - Identify and report data anomalies, performance bottlenecks, and defects. - Work closely with Data Engineers, Analysts, and Business Teams to understand data requirements. - Design and maintain test data sets for validation. - Implement CI/CD pipelines for automated ETL testing (Jenkins, GitLab CI, etc.). - Document test results, defects, and validation reports.

Required qualifications to be successful in this role:

- Experience with cloud platforms (AWS, Azure).
- Knowledge of Data Warehousing concepts (Star Schema, Snowflake Schema). - Certification in ETL Testing, SQL, or Python is a plus.

Skills:

Data Warehousing
MS SQL Server
Python

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

Search

Profile

Upskill and Grow with AI

ETL Testing with Python