SENIOR TEST LEAD
SENIOR TEST LEAD
Posted on :
12-08-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
12-08-2025
Job Description
Senior Test Lead
Job Summary
To develop comprehensive test plans based on project requirements and objectives in collaboration with project stakeholders to define testing scope goals and deliverables. (1.) Key Responsibilities
1. To participate in functional as well as technical discussions with the client /team to understand functional /design specifications highlight performance concerns inconsistencies ensure the appropriate test environments and infrastructures are in place/kept upto date.
2. To Identify opportunities for process improvement in testing methodologies /tools and Implement best practices to enhance the efficiency and effectiveness of the testing process.
3. To oversee the creation and execution of automated test scripts ensuring consistency and alignment with quality standards to minimize exposure.
4. To develop/guide and mentor QA engineers in the use of the testing framework enhancing their technical capabilities and increasing productivity.
Additional requirement :
Tech Stack: ETL testing Informatica PowerCenter dbt Data Build Tool SQL Snowflake Git JIRA
Responsibilities
1. QA Strategy and Planning
- Define QA strategy for a hybrid ETL stack involving Informatica and dbt for transformationmodeling.
- Analyze STTMs (SourcetoTarget Mapping documents) business rules and dbt model definitions to derive test scope.
- Plan and manage test phases across Program Increments (PIs) or releases: unit testing support system testing integration testing and UAT support.
2. Informatica-Specific QA Responsibilities
- Review and validate Informatica mappings workflows sessions and parameter files.
- Validate:
o Source data extraction (flat files RDBMS mainframes etc.)
o Data transformations via mappings (joins lookups aggregations filters etc.)
o Load strategies to stagingODS layers (insert/update strategies truncate/load CDC).
- Use SQL queries and data comparison tools to perform reconciliation and transformation validation.
- Validate job dependencies and control table mechanisms (if used).
- Monitor job runs via Informatica Monitor/Workflow logs and ensure correct execution paths.
3. dbt-Specific QA Responsibilities
- Validate dbt models tests and documentation in the analytics layer.
- Review and test:
o Model SQL logic for business rule accuracy and performance
o YAML files for correct metadata and testing configurations
o dbt tests (unique not null accepted values relationships custom tests)
- Execute dbt test suites using dbt test and investigate failures.
- Collaborate with analytics engineers to validate materialization strategies (table view incremental) and source freshness logic.
- Review generated SQL in target/compiled to ensure correct transformations.
4. Data ValidationReconciliation
- Perform full and sampled data validation across source staging ODS analytics data layers.
- Write complex SQL queries to compare record counts aggregates and field-level data across layers.
- Ensure data consistency and integrity using both manual validation and dbt tests.
- Validate PII masking and data obfuscation where applicable.
5. Automation and DevOps Integration
- Build and maintain reusable SQL-based test automation scripts for recurring validations.
- Integrate QA checks in CI/CD pipelines using git Actions.
- Monitor and validate Informatica batch schedules and dbt Cloud jobs (or CLI triggers).
- Contribute to QA dashboards and test reporting automation.
6. Defect ManagementReporting
- Log and track defects in JIRA categorize by layer (Informatica/dbt) and severity.
- Facilitate daily defect triage calls with data engineering teams.
- Provide detailed test execution status reports and test coverage metrics by data domain.
7. Coordination & Stakeholder Engagement
- Work closely with data engineers analytics engineers data modelers and product owners.
- Represent QA during PI Planning and system demos (SAFe)
To develop comprehensive test plans based on project requirements and objectives in collaboration with project stakeholders to define testing scope goals and deliverables. (1.) Key Responsibilities
1. To participate in functional as well as technical discussions with the client /team to understand functional /design specifications highlight performance concerns inconsistencies ensure the appropriate test environments and infrastructures are in place/kept upto date.
2. To Identify opportunities for process improvement in testing methodologies /tools and Implement best practices to enhance the efficiency and effectiveness of the testing process.
3. To oversee the creation and execution of automated test scripts ensuring consistency and alignment with quality standards to minimize exposure.
4. To develop/guide and mentor QA engineers in the use of the testing framework enhancing their technical capabilities and increasing productivity.
Additional requirement :
Tech Stack: ETL testing Informatica PowerCenter dbt Data Build Tool SQL Snowflake Git JIRA
Responsibilities
1. QA Strategy and Planning
- Define QA strategy for a hybrid ETL stack involving Informatica and dbt for transformationmodeling.
- Analyze STTMs (SourcetoTarget Mapping documents) business rules and dbt model definitions to derive test scope.
- Plan and manage test phases across Program Increments (PIs) or releases: unit testing support system testing integration testing and UAT support.
2. Informatica-Specific QA Responsibilities
- Review and validate Informatica mappings workflows sessions and parameter files.
- Validate:
o Source data extraction (flat files RDBMS mainframes etc.)
o Data transformations via mappings (joins lookups aggregations filters etc.)
o Load strategies to stagingODS layers (insert/update strategies truncate/load CDC).
- Use SQL queries and data comparison tools to perform reconciliation and transformation validation.
- Validate job dependencies and control table mechanisms (if used).
- Monitor job runs via Informatica Monitor/Workflow logs and ensure correct execution paths.
3. dbt-Specific QA Responsibilities
- Validate dbt models tests and documentation in the analytics layer.
- Review and test:
o Model SQL logic for business rule accuracy and performance
o YAML files for correct metadata and testing configurations
o dbt tests (unique not null accepted values relationships custom tests)
- Execute dbt test suites using dbt test and investigate failures.
- Collaborate with analytics engineers to validate materialization strategies (table view incremental) and source freshness logic.
- Review generated SQL in target/compiled to ensure correct transformations.
4. Data ValidationReconciliation
- Perform full and sampled data validation across source staging ODS analytics data layers.
- Write complex SQL queries to compare record counts aggregates and field-level data across layers.
- Ensure data consistency and integrity using both manual validation and dbt tests.
- Validate PII masking and data obfuscation where applicable.
5. Automation and DevOps Integration
- Build and maintain reusable SQL-based test automation scripts for recurring validations.
- Integrate QA checks in CI/CD pipelines using git Actions.
- Monitor and validate Informatica batch schedules and dbt Cloud jobs (or CLI triggers).
- Contribute to QA dashboards and test reporting automation.
6. Defect ManagementReporting
- Log and track defects in JIRA categorize by layer (Informatica/dbt) and severity.
- Facilitate daily defect triage calls with data engineering teams.
- Provide detailed test execution status reports and test coverage metrics by data domain.
7. Coordination & Stakeholder Engagement
- Work closely with data engineers analytics engineers data modelers and product owners.
- Represent QA during PI Planning and system demos (SAFe)
Employment Type
Full-time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
