Power BI ETL Tester

Test Lead – ETL, BI & Database Testing

Location: Hybrid
Experience: 7–12 years

About Cognizant

Cognizant is a leading global professional services company, helping organizations modernize technology, reimagine processes, and transform customer experiences. With deep expertise in data, AI, and digital engineering, we deliver innovative solutions that drive measurable business outcomes.

Role Overview

We are seeking a highly experienced Test Lead to drive quality assurance for ETL, Business Intelligence (BI), and database systems.

In this role, you will lead testing strategy, execution, and governance to ensure data accuracy, system reliability, and high-quality deliverables. You will collaborate with cross-functional teams and stakeholders to establish best practices, improve testing frameworks, and deliver robust data-driven solutions in a hybrid work environment.

Key Responsibilities

Test Strategy & Execution

• Lead the design and execution of comprehensive test plans for ETL processes, BI systems, and database platforms
• Ensure data accuracy, integrity, and system reliability across all testing phases
• Oversee end-to-end validation of data pipelines and reporting systems

ETL, BI & Data Validation

• Perform ETL validation to verify data transformations and alignment with business requirements
• Conduct BI validation to ensure reporting accuracy and analytics reliability
• Validate data integrity using SQL and database testing techniques

Informatica Testing

• Provide subject matter expertise in Informatica testing
• Validate data integration workflows, mappings, and transformations

Metrics, Reporting & Governance

• Develop and maintain test metrics, dashboards, and reporting frameworks
• Track progress, identify risks, and recommend improvements
• Ensure compliance with regulatory and organizational standards

Defect Management & Quality Improvement

• Collaborate with development teams to identify, track, and resolve defects
• Drive continuous improvement initiatives in testing methodologies and processes
• Promote best practices to improve testing efficiency and effectiveness

Stakeholder Collaboration

• Work closely with business stakeholders to understand testing requirements and priorities
• Provide actionable insights to support data-driven decision-making
• Communicate testing results clearly through structured reports and presentations

Documentation & Knowledge Sharing

• Document test cases, results, and validation reports
• Maintain clear records of test execution and outcomes
• Lead knowledge-sharing sessions and training to enhance team capabilities

Hybrid Collaboration

• Facilitate effective collaboration across on-site and remote teams
• Ensure seamless communication and coordination across distributed environments

Required Qualifications

• Strong expertise in ETL, BI, and database testing in enterprise environments
• Proven experience with test metrics, reporting, and quality governance frameworks
• Hands-on expertise in Informatica testing
• Advanced knowledge of ETL validation and data transformation testing
• Strong experience with SQL and database validation techniques
• Experience validating BI tools and reporting systems
• Excellent problem-solving and analytical skills
• Strong communication and stakeholder management capabilities

Preferred Qualifications

• Domain experience in research and development or data-intensive industries
• Familiarity with data governance and regulatory compliance standards
• Exposure to automation tools and modern QA frameworks
• Experience working in hybrid or distributed team environments
• Demonstrated ability to drive continuous process improvements

Compensation

• Base Salary Range: $100,000 – $115,000 per year
• Final compensation is based on experience, skills, and location
• Eligible for performance-based bonuses and incentive compensation

Benefits

Cognizant offers a comprehensive benefits package designed to support your overall well-being and career growth:

• Health & Wellness: Medical, dental, and vision insurance
• Financial Security: 401(k) with company match, life insurance, disability coverage
• Time Off: Generous PTO, paid holidays, and parental leave
• Learning & Development: Training programs, certifications, and career advancement opportunities
• Flexible Work Model: Hybrid work environment supporting work-life balance
• Employee Programs: Wellness initiatives, employee resource groups, and recognition programs

Why Join Cognizant?

• Work on enterprise-scale data and analytics platforms
• Collaborate with global teams and industry-leading clients
• Grow your career in a high-impact, data-driven environment
• Be part of a culture focused on innovation, inclusion, and excellence