Data Warehouse QA Analyst — ETL & SQL Validation

Infinite Computer Solutions; New Jersey; On-site; USD 90,000 - 130,000; Full time

Job summary

Infinite Computer Solutions in New Jersey is seeking a Quality Assurance Analyst for an Enterprise Data Warehouse project. You will validate data quality, accuracy, and reliability across ETL processes, source-to-target mappings, and reporting outputs using SQL, Informatica, Cognos, and Tableau.

The role emphasizes end-to-end testing, data reconciliation, regression testing, and collaboration with developers and business users to ensure release readiness, data governance.

Qualifications

• 5+ years of experience in software quality assurance, data warehouse testing, ETL testing, or a related technical role.
• Strong experience testing enterprise data warehouse and data-integration solutions.
• Advanced SQL skills with the ability to independently query and analyze large datasets.
• Experience validating ETL transformations and source-to-target mappings.
• Experience performing data reconciliation and identifying discrepancies across multiple data sources.
• Understanding of dimensional data models, fact and dimension tables, relational databases, and data warehousing concepts.
• Experience with ETL tools such as Informatica PowerCenter or comparable technologies.
• Experience with Oracle or other enterprise relational database platforms.
• Experience developing and executing regression, integration, and end-to-end test scenarios.
• Experience documenting and managing defects using tools such as Azure DevOps, Jira, or similar platforms.
• Ability to analyze complex data issues and distinguish data-quality problems from application, ETL, configuration, and source-system defects.
• Strong written and verbal communication skills.

Responsibilities

• Develop and execute test plans, test scenarios, test cases, and test scripts for EDW change requests, enhancements, defect fixes, and releases.
• Perform end-to-end testing of ETL processes, including validation from source systems through staging, operational data stores, dimensional models, fact tables, and reporting layers.
• Validate source-to-target mappings and confirm that transformation and business rules are implemented correctly.
• Perform data reconciliation using SQL to compare source and target record counts, totals, key data elements, and transformation results.
• Validate data completeness, accuracy, consistency, referential integrity, and duplicate handling.
• Perform functional, integration, system, regression, and production-validation testing.
• Test Informatica workflows, mappings, sessions, dependencies, and batch-processing results.
• Validate database changes, including tables, views, stored procedures, indexes, and data-model modifications.
• Verify reporting and analytics outputs in tools such as Cognos and Tableau against underlying EDW data.
• Develop reusable regression test suites for critical EDW processing.
• Identify, document, and track defects through resolution and retesting.
• Provide clear evidence supporting test results and release readiness.
• Participate in requirements and technical-design reviews to identify testability issues and potential defects early in the development lifecycle.
• Work with development teams to perform root-cause analysis of data discrepancies and processing failures.
• Support User Acceptance Testing (UAT) by assisting business users with test scenarios, test data, and defect analysis.
• Participate in release-readiness reviews and provide QA status, outstanding defects, risks, and recommendations.
• Perform post-deployment validation following production releases.
• Maintain QA documentation and testing evidence in accordance with project and client standards.

Skills

Advanced SQL

ETL testing

Data warehouse testing

Regression testing

Analytical skills

Education

Graduate

Tools

Informatica PowerCenter

Azure DevOps

Jira

Cognos/Tableau

Job description

Infinite Computer Solutions in New Jersey is seeking a Quality Assurance Analyst for an Enterprise Data Warehouse project. You will validate data quality, accuracy, and reliability across ETL processes, source-to-target mappings, and reporting outputs using SQL, Informatica, Cognos, and Tableau.

The role emphasizes end-to-end testing, data reconciliation, regression testing, and collaboration with developers and business users to ensure release readiness, data governance.