ETL tester

Hiring : W2 Candidates Only

Visa : Open to any visa type with valid work authorization in the USA

Key Responsibilities :

Validate ETL pipelines after data migration from legacy systems to new data warehouses or cloud platforms.

Test and verify Cognos reports for accuracy completeness formatting and compliance with defined business rules.

Develop and execute test plans test cases and scripts for both ETL and reporting validation.

Perform data reconciliation between source staging and target systems to ensure integrity and correctness.

Collaborate with data engineers and business analysts to understand reporting requirements and ETL transformations.

Identify log and track defects or discrepancies using JIRA.

Support the state team during User Acceptance Testing (UAT) for migrated data and reports.

Document testing activities results and provide summary reports and recommendations.

Ensure testing adheres to HIPAA CMS and state Medicaid compliance standards.

Required Skills and Experience :

8 years of experience in software testing preferably in Medicaid or healthcare data systems.

Knowledge of Medicaid data (eligibility enrollment claims encounters providers).

Hands-on experience validating ETL processes and data migration projects.

Strong experience testing Cognos reports

Proficiency in SQL for data validation and troubleshooting.

Familiarity with data warehouses staging and OLAP environments.

Experience with test management tools (JIRA Selenium etc ).

Strong analytical documentation and problem-solving skills.

Education

Bachelor s degree in computer science Information Systems or a related field

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1