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

- 5+ 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.
- Robust analytical, debugging, and communication skills. Preferred Skills
- Experience with cloud-based ETL platforms
- Familiarity with ETL testing automation frameworks.
- Exposure to big data technologies

Interested candidates can share the uptaded resume to the Mail Id : [email protected]

Pay: ₹800,000.00 - ₹1,500,000.00 per year

Benefits:

- Health insurance

Work Location: In person

📌 ETL Terst Engineer Informatica (Bengaluru)
🏢 Data Prowess Private
📍 Bengaluru