Responsibilities:

- Test Planning and Strategy: Collaborate with data engineers, data analysts, and business stakeholders to understand ETL requirements and create test strategies and plans.
- Test Case Development: Design, write, and execute detailed test cases and test scripts to validate data extraction, transformation, and loading processes.
- Data Validation: Conduct source-to-target data validation to ensure data accuracy and consistency, and identify potential data quality issues.
- Regression Testing: Perform regression tests on ETL processes after changes or updates to ensure that new changes do not affect existing functionalities.
- Automation: Develop and implement test automation frameworks to streamline testing for ETL processes using tools such as SQL, Python, or other scripting languages.
- Performance Testing: Assess ETL job performance and identify areas for optimization to ensure data processing meets required timeframes.
- Defect Tracking: Document, track, and report defects and issues found during testing, working closely with development teams to resolve them.
- Documentation:



Maintain comprehensive documentation for all testing phases, including requirements, test scripts, and defect tracking.

Requirements:

- Technical Expertise: Proficiency in SQL, data querying, and database testing; familiarity with ETL tools such as Informatica, Talend, SSIS, or similar platforms.
- Scripting Knowledge: Hands-on experience with test automation tools or scripting languages like Python, Shell scripting, or other related tools.
- Data Warehousing Knowledge: Robust understanding of data warehousing concepts, data integration, and ETL processes.
- Analytical Skills: Excellent problem-solving skills, with a keen eye for detail to identify data inconsistencies and errors.
- Tools: Familiarity with tools like JIRA, HP ALM, or any other test management tool for tracking testing progress and defect status.
- Soft Skills: Good communication skills to liaise with development and business teams, attention to detail, and the ability to work in a collaborative environment.

📌 Infosys_ ETL Testing_ Chennai/Bangaluru/Hyderabad/Pune/Noida
🏢 Glauben Technologies
📍 Pune