Position: ETL Tester

Responsibilities:

• Perform ETL testing activities including test planning, test case design, test execution, defect management, and test reporting.
• Collaborate with cross-functional teams, including ETL developers, data engineers, and business analysts, to understand ETL requirements and identify testing needs.
• Design and execute comprehensive test scenarios and test cases to validate data transformations, data loading, and data integrity across various ETL processes.
• Develop and execute SQL queries to extract and validate data from source systems, data warehouses, and data marts.
• Analyze complex data sets and data mappings to identify anomalies, data quality issues, and inconsistencies.
• Identify, report, and track defects using defect tracking tools and participate in defect triage meetings to ensure timely resolution.
• Conduct root cause analysis of ETL-related issues and work closely with development teams to ensure effective resolution.
• Collaborate with the data engineering team to develop and maintain automated ETL testing scripts and tools to enhance testing efficiency and effectiveness.
• Participate in the review and improvement of ETL testing processes, methodologies, and best practices.
• Stay up-to-date with emerging ETL technologies, industry trends, and best practices to continuously improve ETL testing capabilities.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Minimum 5 years of experience in ETL testing, preferably in a similar role.
• Strong understanding of ETL testing concepts, methodologies, and best practices.
• Proficiency in writing and executing SQL queries to validate data transformations and data integrity.
• Experience with ETL testing tools and frameworks such as Informatica, Talend, or DataStage.
• Familiarity with data warehousing concepts, dimensional modeling, and data integration techniques.
• Strong analytical and problem-solving skills with the ability to troubleshoot and debug ETL-related issues.
• Knowledge of software development life cycle (SDLC) methodologies and testing processes.
• Certification in software testing, such as ISTQB, is a plus.
• Excellent attention to detail and ability to prioritize and manage multiple tasks in a fast-paced environment.

Application Process: To apply for the position of ETL Tester at Appzlogic, please send your updated resume to ayushi.gulati@appzlogic.com. Please include “ETL Tester Application” in the subject line of the email. We appreciate all applications, but only shortlisted candidates will be contacted for further consideration.