ETL Tester (Data Projects)

Employment Type: Contract – 3 Months

Location: Hyderabad / Chennai

Experience: 3–5 Years

Job Summary

BigTapp is seeking an experienced ETL Tester to support enterprise Data and Data Warehousing projects. The ideal candidate should have strong hands-on experience in ETL testing, SQL, data validation, reconciliation, source-to-target mapping, data quality, and profiling, with exposure to ETL tools such as Informatica IICS/IDMC, Informatica PowerCenter, or Databricks. The role will involve validating data pipelines, ensuring data accuracy and completeness, and working closely with Developers, Data Engineers, and Business teams.

Mandatory Skills

Strong hands-on experience in ETL/Data Testing with strong SQL skills
Experience with data validation and reconciliation across source and target systems
Strong understanding of Source-to-Target Mapping (STTM) validation
Experience in data quality checks and data profiling
Positive understanding of Data Warehousing concepts
Experience working with ETL tools,



preferably Informatica IICS/IDMC or Informatica PowerCenter
Ability to validate ETL transformations, business rules, aggregations, and data loads
Basic scripting knowledge, preferably Python
Strong analytical and problem-solving skills

Key Responsibilities

Analyze business and technical requirements and prepare ETL test scenarios and test cases
Validate source-to-target mappings and transformation rules
Execute SQL queries to validate data accuracy, completeness, and consistency
Perform data reconciliation between source and target systems
Validate ETL workflows, mappings, transformations, and data loads using Informatica or other ETL tools
Perform data quality checks and profiling to identify missing, duplicate, or inconsistent data
Execute functional, integration, regression, and data validation testing
Identify, document, and track defects and coordinate with development teams for resolution
Support test data preparation, test execution, de

📌 QA Tester (Chennai)
🏢 Bigtapp Analytics
📍 Chennai