ETL Tester

Job Summary

The ETL Tester is responsible for designing, developing, and maintaining automated test frameworks and tools for Data Engineering and Data Warehouse applications. The role ensures comprehensive testing coverage, contributing to the quality and performance of data pipelines, ETL processes, and data transformations.

Responsibilities

• Design, develop, and maintain automated test frameworks, tools, and test cases for Data Engineering and Data Warehouse applications.
• Collaborate with cross-functional teams including developers, data engineers, and analysts to ensure comprehensive testing coverage.
• Conduct thorough testing of Data Warehouse (DWH) data pipelines, ETL processes, and data transformations using Big Data technologies.
• Validate the accuracy, completeness, and performance of data storage and retrieval systems.
• Identify, document, and track software defects, and work closely with development teams for resolution.
• Participate in code reviews, design discussions, and QA meetings to contribute to product quality.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 3–5 years of experience in software testing and development, focused on data-intensive applications.
• Proven experience in testing DWH data pipelines and ETL processes.
• Strong skills in SQL.
• Preferred automation skills in Python or any other scripting language.
• Experience with scripting languages such as Bash or Shell.
• Hands-on experience with Big Data technologies such as Spark, Hive, and Impala.
• Experience with large-scale datasets and distributed data processing frameworks (e.g., Hadoop, Spark).
• Understanding of Data Warehouse methodologies and ETL tools.
• Excellent problem-solving and debugging skills.
• Strong communication and collaboration skills.
• Familiarity with data integration tools like Apache NiFi is a plus.
• Eagerness to learn and contribute to a growing team.

Preferred Skills

• Familiarity with data integration tools like Apache NiFi.
• Experience in automating other testing processes is a plus.

Experience

• 3+ years of relevant experience in software testing with a focus on data-intensive applications.

Environment

• Work is primarily in-office with some flexibility for remote work as needed. The position is based in Pune.