Job Description

QA ETL Testing Lead

Location: Smithfield, RI

Key Responsibilities:

Perform Functional, SIT, and E2E testing of UI front-end applications, including regression suite design and execution.
Conduct ETL testing using tools like iCEDQ, covering:
- ETL transformation validation
- Source data and business rule validation
- Referential integrity and data reconciliation
- BI report validation and UAT vs QA comparisons
Execute API testing using RestAssured, SOAPUI, and similar tools.
Develop and run custom SQL scripts for RDBMS (MS SQL, Sybase) testing:
- Debug stored procedures
- Validate complex business logic using advanced SQL
(Optional) Test ETL pipelines in Informatica, including transformation logic and data quality checks.
(Optional) Validate Power BI reports against source queries and BRD documents, including GUI and security checks.

Mandatory Required Experience :

Testing the UI front end, identify key test cases and scenarios for regression suite - Functional, SIT, E2E
Testing through record & play references - Functional, SIT, E2E
API Testing using RestAssured, SOAPUI and similar tools.
Custom Script development and testing - RDBMS ( MS SQL,Sybase)
Need to have the below concepts-
a) It is essential to understand the logic within stored procedures and possess the ability to debug them effectively to identify the root cause of issues
b)Should have a strong grasp of advanced SQL concepts and be capable of writing customizable scripts to validate complex business logic effectively..

Good to have Experience :

Leveraging iCEDQ and similar tools.
Need to have the below concepts-
a)ETL Transformation Test
b)Source Data Validation
c)Business Validation Rule
d)Referential Integrity Check
e)Data Migration Reconciliation
f)BI Report Validation
g)UAT VS QA

Test the ETL Jobs and Pipelines - Informatic
Need to have the below concepts-
a)Transformation Logic Validation (Aggregations, Joins & Filters)
b)Data Quality Checks
Testing Power BI reports
a)data validation(Against the Source queries/SP)
b)GUI
c)Validating the reports against the BRD Documents.(Font Size,Security -Masking,Labeling e.t.c)

Job Tags

Contract work,

Similar Jobs

Wren Kitchens

Sales Representative Job at Wren Kitchens

About The Company Wren Kitchens' Biggest Leap Yet: Join us as we bring our unique showroom experience to your local The Home Depot store! Established in 2009, Wren Kitchens are proud to be Europes Number One Kitchen Retail Specialist and have more than 100 showrooms...

Schwartz Mazda

Automotive Sales Professional Job at Schwartz Mazda

...Job Type: Full-TimeCompensation: Base + Commission + Bonuses About Schwartz Mazda Schwartz Mazda is a family-owned dealership with over 106 years of experience serving Monmouth County and the Tri-State Area. We take pride in offering outstanding...

Steady Vision

Web Developer Job at Steady Vision

...We are digital marketing agency seeking a web developer who exhibits strong attention to detail and thrives in a dynamic environment. We... ...with any of the following systems: ExpressionEngine, HubSpot, Magento, Shopify, SquareSpace, WordPress. Experience with any of the...

CRH

Truck/Trailer Mechanic Job at CRH

...aggregates for one of Nebraskas very first concrete paving projects. Position Overview The Diesel Mechanic is responsible for maintaining diesel trucks and equipment operations by completing inspections and preventive maintenance requirements, correcting...

ETS Vision

Full Time Optometrist- Successful Twin Cities optometric practice seeks an Optical Manager - earn up to $80,000 yearly Job at ETS Vision

...Optometric franchise in Maple Grove, MN seeks a full-time Store Manager. This position offers the Manager the opportunity to work in... ...requires some evenings and alternate weekends. The practice has been the #1 volume store of all 700+ locations since opening...

QA ETL Testing Lead Job at Noblesoft Technologies, Smithfield, RI

aVVkVUN2T0lENFdVM0hHRmE3TE5FSUJPTUE9PQ==