Job Details
- Job Title : QA ETL Testing Lead
- Job ID : 2736989
- Position Type : Full-time
- Location : Smithfield, RI (Onsite)
Base Pay Range
$65,000.00 / yr - $133,100.00 / yr
HCLTech is looking for a highly talented and self-motivated QA ETL Testing Lead to join it in advancing the technological world through innovation and creativity.
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 validationReferential integrity and data reconciliationBI report validation and UAT vs QA comparisonsExecute 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, E2ETesting through record & play references - Functional, SIT, E2EAPI Testing using RestAssured, SOAPUI and similar tools.Custom Script development and testing - MS SQL, SybaseIt is essential to understand the logic within stored procedures and possess the ability to debug them effectively to identify the root cause of issuesShould 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.ETL Transformation TestSource Data ValidationBusiness Validation RuleReferential Integrity CheckBI Report ValidationUAT vs QATransformation Logic Validation (Aggregations, Joins & Filters)Data Quality ChecksTest the ETL Jobs and Pipelines - InformaticaTesting Power BI reportsData validation against the Source queries / SPGUI validationValidating the reports against the BRD Documents (Font Size, Security - Masking, Labeling, etc.)Pay and Benefits
Pay Range Minimum : $65,000 per year
Pay Range Maximum : $133,100 per year
Equal Opportunity
HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and / or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@ for investigation.
Compensation and Benefits
A candidates pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies : medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year
Seniority level
Mid-Senior levelEmployment type
Full-timeJob function
Information Technology and FinanceIndustries
IT Services and IT Consulting#J-18808-Ljbffr