ETL Testing Engineer

3 - 9 years

0 Lacs

Posted:2 days ago| Platform: Indeed logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Category: Testing/Quality Assurance
Main location: India, Karnataka, Bangalore
Position ID: J0725-1442
Employment Type: Full Time

Position Description:

Position Description
Company Profile: Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com. Job Title: ETL Testing Engineer Position: Senior test engineer Experience: 3-9 Years Category: Quality assurance/Software Testing. Shift: 1-10 pm/UK Shift Main location: Chennai/Bangalore. Position ID: J0725-1442 Employment Type: Full Time Position Description: We are looking for an experienced DataStage tester to join our team. The ideal candidate should be passionate about coding and testing scalable and high-performance applications

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:

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.

Preferred Qualifications:
  • 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.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

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

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.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
CGI logo
CGI

Information Technology and Consulting

Montreal

RecommendedJobs for You

Bengaluru, Karnataka