QA ETL Tester

Perficient; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Perficient is seeking an ETL QA Engineer / ETL Tester to validate end-to-end data pipelines across on-premises and cloud environments. The role emphasizes data quality, test automation, and strong expertise in Informatica ETL, SQL, Python/PySpark, and AWS services.

The candidate will design and execute ETL test strategies, perform data validation, and collaborate with Data Engineers, Analysts, and Product Owners in an Agile setup.

Qualifications

• 5+ years of ETL and data warehouse testing experience.
• Hands-on with Informatica PowerCenter/Cloud.
• Proficient in SQL, data validation, and data reconciliation.
• Experience with Python/PySpark for automation.
• Knowledge of AWS data services and Unix/Linux environments.

Responsibilities

• Design and execute ETL test strategies and plans.
• Validate Informatica workflows and data migrations.
• Perform source-to-target data validation and reconciliation.
• Develop automated test scripts in Python/PySpark.
• Run API tests and validate data exchange.
• Create test reports and quality metrics.
• Collaborate with data engineers and analysts.
• Participate in Agile ceremonies.
• Identify defects and coordinate resolutions.

Skills

ETL Testing

Data Warehouse Testing

SQL

Python

PySpark

API Testing

Jenkins

GitHub

Unix/Linux

ICEDQ/QuerySurge

Education

Bachelor's Degree in Computer Science, Information Technology, Engineering, or related discipline

Tools

Informatica PowerCenter

Informatica Cloud

Postman

Swagger

Snowflake

Databricks

Redshift

AWS S3

Job description

Job Description ETL QA Engineer / ETL Tester

Experience: 5+ Years

Location: Bangalore/Chennai/Hyderabad/Nagpur/Pune

Employment Type: Full-Time

Job Summary

We are looking for a highly skilled ETL QA Engineer / ETL Tester with strong expertise in data validation, ETL testing, cloud technologies, and test automation. The ideal candidate should have hands‑on experience with Informatica ETL, AWS Services, SQL, ICEDQ/QuerySurge, Python/PySpark, API Testing, Jenkins, GitHub, and Unix/Linux environments. The candidate will be responsible for validating end‑to‑end data pipelines, ensuring data quality, and automating testing processes for enterprise‑scale data platforms.

Key Responsibilities

• Design, develop, and execute ETL test strategies, test plans, and test cases.
• Validate ETL workflows built using Informatica and other data integration tools.
• Perform source-to-target data validation and reconciliation.
• Test data transformations, aggregation rules, business logic, and data quality checks.
• Write complex SQL queries for backend data validation and analysis.
• Execute API testing to validate data exchange between applications and data platforms.
• Develop and maintain automated test scripts using Python/PySpark.
• Utilize ICEDQ/QuerySurge for data quality validation and ETL test automation.
• Validate AWS-based data pipelines and cloud data warehouse environments.
• Perform functional, integration, system, regression, and end-to-end testing.
• Collaborate with Developers, Data Engineers, Business Analysts, and Product Owners.
• Participate in Agile ceremonies and contribute to sprint deliverables.
• Analyze defects, perform root cause analysis, and coordinate issue resolution.
• Generate test execution reports, quality metrics, and test closure reports.

Mandatory Skills

ETL & Data Testing

• Strong experience in ETL Testing and Data Warehouse Testing.
• Hands‑on experience with Informatica PowerCenter/Informatica Cloud.
• Experience validating data migration and data transformation processes.
• Expertise in source-to-target mapping validation.

Database & SQL

• Strong SQL skills with hands‑on experience in:
  • Joins
  • Stored Procedures
  • Functions
  • Complex Queries
  • Data Reconciliation
  • Data Profiling

Cloud Technologies

• Experience with AWS services such as:
  • S3
  • Glue
  • Redshift
  • Lambda
  • EMR
  • Athena

Testing & Automation

• Hands‑on experience with:
  • ICEDQ
  • QuerySurge
  • Data Quality Automation Tools
• Strong understanding of:
  • Test Design Techniques
  • Test Planning
  • Defect Management
  • Test Execution

Programming

• Experience with Python and PySpark for:
  • Data Validation
  • Test Automation
  • Data Quality Checks
  • Data Comparison Frameworks

API Testing

• Hands‑on experience with REST API testing.
• Knowledge of Postman, Swagger, and API validation techniques.

DevOps & Version Control

• Experience with:
  • Jenkins
  • GitHub
  • CI/CD Pipelines
  • Automated Test Execution

Operating Systems

• Strong Unix/Linux command-line knowledge.
• Experience in shell scripting and log analysis.

Preferred Skills

• Knowledge of Software Design and SDLC/STLC processes.
• Experience with Agile/Scrum methodology.
• Exposure to Snowflake, Databricks, or Big Data platforms.
• Familiarity with Jira or Azure DevOps.
• Experience working in cloud migration projects.
• Understanding of Data Governance and Data Quality frameworks.

Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or related discipline.
• 5+ years of experience in ETL/Data Warehouse Testing.
• Excellent analytical, troubleshooting, and communication skills