Job Overview
Location
Smithfield, Rhode Island
Ready to Apply?
Take the Next Step in Your Career
Join CYNET SYSTEMS and advance your career in other-general
Apply for This Position
Click the button above to apply on our website
Job Description
Job Description:
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-
- 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
- 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-
- ETL Transformation Test.
- Source Data Validation.
- Business Validation Rule.
- Referential Integrity Check.
- Data Migration Reconciliation.
- BI Report Validation.
- UAT VS QA.
- Test the ETL Jobs and Pipelines - Informatica.
Need to Have:
- Transformation Logic Validation (Aggregations, Joins & Filters).
- Data Quality Checks.
Testing Power BI Reports:
- Data validation(Against the Source queries/SP).
- GUI.
- Validating the reports against the BRD Documents.(Font Size,Security -Masking,Labeling e.t.c).
Don't Miss This Opportunity!
CYNET SYSTEMS is actively hiring for this QA ETL Test Engineer position
Apply Now