ETL Tester

Required: SQL, ETL Testing, ETL

Role Description:
The Senior Data / ETL Tester is responsible for validating data integration, transformation, and loading processes to ensure accuracy, consistency, and reliability of data across analytics platforms. This role involves designing test strategies, executing test cases, and collaborating with data engineering teams to maintain high-quality data solutions.

Key Responsibilities:
Test Planning & Strategy: o Develop comprehensive test plans and strategies for ETL processes and data pipelines.
Identify test scenarios for data extraction, transformation, and loading.
Test Execution: o Perform functional, integration, and regression testing for ETL workflows.
Validate data accuracy, completeness, and business rule implementation.
Automation & Tools: Implement automated testing for data validation using SQL, Python, or ETL testing frameworks.
Utilize tools like Informatica, Talend, or DBT for ETL testing.
Defect Management: Log and track defects using tools like JIRA or Azure DevOps.
Collaborate with data engineers and developers for issue resolution.
Reporting & Documentation: Prepare detailed test reports and metrics for stakeholders.
Maintain documentation for test cases, scripts, and results.
Collaboration: Work closely with data architects, engineers, and business analysts.
Ensure alignment with project timelines and quality standards.

Required Skills & Qualifications:
Strong experience in testing ETL processes and data pipelines.
Proficiency in SQL for data validation and analysis.
Familiarity with ETL tools (Informatica, Talend, DBT) and data warehousing concepts.
Knowledge of automation frameworks and scripting languages (Python, Shell).
Understanding of data governance and compliance standards.
Excellent analytical and communication skills