Job description

Job Summary

Data Prowess is looking for a seasoned Data Test Analyst with deep expertise in ETL testing and Informatica PowerCenter. You will play a critical role in validating data pipelines, ensuring data integrity, and collaborating with cross-functional teams to support data quality initiatives.

Key Responsibilities
- ETL Testing: Validate ETL workflows, data transformations, and data loads using Informatica PowerCenter.
- Data Validation: Conduct source-to-target data validation to ensure accuracy and completeness.
- Test Strategy & Planning: Create test plans, test cases, and test scripts based on business requirements.
- SQL & Database Testing: Write and execute complex SQL queries for validating data in Oracle, SQL Server, MySQL, etc.
- Defect Management: Identify and log defects; track and manage through tools like JIRA, HP ALM, or TestRail.
- Validation (IDQ) to automate ETL test processes.
- Collaboration: Work with developers, BAs, and QA teams to investigate issues and uphold data quality.




- Performance Testing: Identify and report performance bottlenecks in ETL jobs; suggest optimization strategies.

Required Skills & Experience
- 7+ years of experience in ETL/Informatica Testing.
- Expertise in Informatica PowerCenter and ETL validation.

Strong SQL knowledge with the ability to handle complex queries, joins, indexing, and performance tuning.
- Proficiency in test case design, execution, and defect tracking.
- Solid understanding of data warehousing and BI reporting tools.
- Experience with Agile methodologies and tools like JIRA, Confluence, or Azure DevOps.
- Solid analytical, debugging, and communication skills. Preferred Skills
- Experience with cloud-based ETL platforms
- Familiarity with ETL testing automation frameworks.
- Exposure to big data technologies

Mail Id : [email protected]

📌 Informatica Etl Tester (Bengaluru)
🏢 Data Prowess
📍 Bengaluru