ETL Tester(SJ-IQ)

SE Mentor Solutions; Ernakulam; On-site; INR 900,000 - 1,300,000; Full time

Job summary

SE Mentor Solutions is seeking an ETL Tester to validate data sources and ensure accuracy of ETL processes. You will develop and execute SIT plans, review data models, and run queries to verify outcomes against expectations.

The role emphasizes Python automation for ETL testing and collaboration with development teams to resolve defects and ensure data quality. A strong foundation in ETL tools and data warehousing is expected.

Qualifications

• Bachelors or Masters in Computer Science, Engineering or related fields.
• Certifications such as CSTE or ISTQB are a plus.

Responsibilities

• Validate data sources and verify ETL extraction, transformation and loading.
• Create and execute SIT plans and test cases.
• Review data models, mappings and docs.
• Run database queries to verify results against expectations.
• Log defects and troubleshoot issues with Dev/QA teams.
• Collaborate with development teams to resolve defects.
• Leverage Python automation for ETL testing.

Skills

ETL Testing

SQL

Python

ADF

SSIS

Informatica

Ab Initio

Robot Framework

API Testing

Selenium

Java basics

PySpark

Data warehouse concepts

STLC/Defect management

Education

Bachelors/Masters in CS/Engineering/IS

ISTQB/CSTE certification

Tools

SQL tooling

HP ALM

Job description

We are seeking a skilled QC Resource to join our team. As
an ETL Tester, you will play a crucial role in ensuring the quality and accuracy of our data processing pipelines. Your responsibilities will include
validating data sources, executing test cases, troubleshooting defects, and
collaborating with development teams. If you have a strong background in ETL
testing, SQL, Python, and ADF, we’d love to hear from you!

Responsibilities

• ETL Testing:
• Validate data sources, ensuring accurate extraction, transformation, and loading processes.
• Create and execute System Integration Test (SIT) plans and test cases.
• Review data models, mappings, and architectural documentation.
• Run queries in the database to verify results against expectations.
• Troubleshoot erroneous results and log defects in HP Quality Center/ALM.
• Collaborate with development teams to resolve software-related defects.
• Strong knowledge on Python automation for ETL testing.
• Technical Skills:
• Proficiency in any ETL tools like SSIS,Informatica,Abinitio and ADF.
• Strong experience with SQL for data validation and comparison.
• Good experience on Python.
• Experience in using python automation for ETL testing.
• Understanding of Robot Framework or any BDD Framework and API Testing.
• Knowledge of both dimensional modeling and data warehouse concepts (star schemas, snowflakes, dimensions, facts).
• Exposure on testing concepts like STLC, Defect management, Test scenario/test case design etc.
• Exposure to risk frameworks and mitigation strategies.
• Exposure to SCD Concepts.
• Experience with Selenium, basics of java and pyspark is a plus.
• Qualifications:
• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or related fields.
• Certifications such as CSTE (Certified Software Tester) or ISTQB (International Software Testing Qualifications Board) is a plus.