Informatica Etl Tester

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.
• Strong 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 removed]