Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: ETL Testing Engineer.
India Jobs Expertini

Urgent! ETL Testing Engineer Job Opening In Bengaluru – Now Hiring CGI

ETL Testing Engineer



Job description

Position Description:

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.

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

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

  • Required Skill Profession

    Computer Occupations



    Your Complete Job Search Toolkit

    ✨ Smart • Intelligent • Private • Secure

    Start Using Our Tools

    Join thousands of professionals who've advanced their careers with our platform

    Rate or Report This Job
    If you feel this job is inaccurate or spam kindly report to us using below form.
    Please Note: This is NOT a job application form.


      Unlock Your ETL Testing Potential: Insight & Career Growth Guide