HamburgerMenu
hirist

Job Description

We are looking for an experienced ETL Tester with strong expertise in data warehouse testing, ETL validation, and database testing.

The ideal candidate should have hands-on experience in validating data pipelines, performing data reconciliation, and ensuring data accuracy, completeness, and consistency across source and target systems.

Key Responsibilities:

- Design, develop, and execute test cases for ETL processes, data migration, and data warehouse applications.

- Validate data extraction, transformation, and loading processes across multiple source and target systems.

- Perform source - to - target data validation and reconciliation to ensure data accuracy and completeness.

- Write and execute complex SQL queries to validate data transformations, business rules, and data integrity.

- Perform backend testing, database testing, and data quality validation.

- Identify, analyse, and report data discrepancies, defects, and inconsistencies.

- Validate data mapping documents and transformation logic against business requirements.

- Perform functional, regression, integration, and end - to - end testing of ETL workflows.

- Collaborate with developers, data engineers, business analysts, and stakeholders to resolve data - related issues.

- Prepare test plans, test scenarios, test cases, and test execution reports.

- Participate in defect triage meetings and ensure timely resolution of identified issues.

Required Skills & Qualifications:

- 5 - 8 years of experience in ETL Testing, Data Warehouse Testing, or Database Testing.

- Strong hands - on experience in ETL testing methodologies and data validation.

- Advanced SQL skills, including complex queries, joins, subqueries, and stored procedures.

- Experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or equivalent.

- Good understanding of data warehousing concepts, data modelling, and database architecture.

- Experience in source - to - target validation, data reconciliation, and data quality testing.

- Knowledge of relational databases such as Oracle, SQL Server, or PostgreSQL.

- Experience in defect management and test management tools such as Jira, HP ALM, or equivalent.

- Strong analytical, problem - solving, and debugging skills.

- Ability to work closely with cross - functional teams in an Agile environment.

Preferred Skills:

- Exposure to cloud - based data platforms such as AWS, Azure, or GCP.

- Familiarity with big data testing and technologies such as Hadoop or Spark.

- Knowledge of data pipeline validation and automation testing frameworks.

- Understanding of Agile and Scrum methodologies

info-icon

Did you find something suspicious?

Similar jobs that you might be interested in

Loading chat...