ETL Testing

Candidate needs to have exposure as a Developer, Support Engineer & Testing.
Candidate must have knowledge on either platforms like Informatica, Ab Initio, DataStage OR custom code using Python
Design and execute test plans for ETL processes, ensuring data accuracy, completeness, and integrity.
Develop automated test scripts using Python or R for data validation and reconciliation.
Perform source-to-target data verification, transformation logic testing, and regression testing.
Collaborate with data engineers and analysts to understand business requirements and data flows.
Identify data anomalies and work with development teams to resolve issues.
Maintain test documentation, including test cases, test results, and defect logs.
Participate in performance testing and optimization of data pipelines.

Required Skills & Qualifications:
Strong experience in ETL testing across various data sources and targets.
Proficiency in Python or R for scripting and automation.
Solid understanding of SQL and relational databases.
Familiarity with data warehousing concepts and tools (e.g., Power BI, QlikView, Informatica, Talend, SSIS).
Experience with test management tools (e.g., JIRA, TestRail).
Knowledge of data profiling, data quality frameworks, and validation techniques.
Excellent analytical and communication skills.