ETL Testing Engineer

Job description

Position Description:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.

Job Title: ETL Testing Engineer
Experience: 3-8 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.

Your future duties and responsibilities:

- Develop and execute ETL test cases to validate data extraction, transformation, and loading processes.
- Has experience in ETL pipeline testing in ADB 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 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.

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.

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

What you can expect from us:

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.

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