Data Warehouse BI Testing E2

Tata Consultancy Services; Bengaluru, Mumbai, Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services is seeking a seasoned Data Warehouse BI Testing professional to join our team across Mumbai, Chennai, Bangalore, and Hyderabad. The role focuses on validating data flows, data quality, and BI reports within complex data environments.

Ideal candidates have 6-8 years of experience, hands-on Informatica PowerCenter, strong SQL skills, and solid understanding of SDLC/STLC and Agile practices. Excellent communication and stakeholder collaboration are essential for success.

Qualifications

• 6-8 years of experience in Data Warehouse, ETL, and BI Testing.
• Hands-on experience with Informatica PowerCenter.
• Proficient in writing complex SQL queries.
• Good understanding of SDLC, STLC, and Agile methodologies.
• Excellent analytical and troubleshooting skills.
• Strong communication and stakeholder management skills.

Responsibilities

• Perform end-to-end Data Warehouse and BI testing across projects.
• Leverage Informatica PowerCenter for data integration testing.
• Write and execute complex SQL queries to validate data integrity.
• Apply SDLC, STLC and Agile methodologies to testing lifecycle.
• Analyze issues, troubleshoot root causes, and propose fixes.
• Communicate effectively with stakeholders and manage expectations.

Skills

Data Warehouse

ETL Testing

BI Testing

Informatica PowerCenter

SQL queries

SDLC/STLC

Agile methodologies

Analytical thinking

Stakeholder management

Communication skills

Tools

Informatica PowerCenter

Job description

Overview

Role: Data Warehouse BI Testing E2

Experience: 6-8 yrs

Location: Mumbai, Chennai, Bangalore, Hyderabad

Responsibilities

• 6-8 years of experience in Data Warehouse, ETL, and BI Testing.
• Strong hands-on experience with Informatica PowerCenter.
• Extensive experience in writing and executing complex SQL queries.
• Good understanding of SDLC, STLC, and Agile methodologies.
• Excellent analytical and troubleshooting skills.
• Strong communication and stakeholder management skills.