ETL Testing Engineer- SQL - Python

3 - 8 years

3 - 7 Lacs

Posted:1 day ago| Platform: Naukri logo

Apply

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

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

kochi, bengaluru, thiruvananthapuram

pune, bengaluru, mumbai (all areas)

hyderabad, chennai, bengaluru