職務内容
Test lead
職務概要
-
勤務地： Texas
-
プロジェクトロール： Test lead
-
スキル： Informatica Data Validation
- 二次的なスキル：
- Data Build Tool (DBT)
- Snowflake
-
募集人数： 1
-
給与レンジの下限： $64000
-
給与レンジの上限： $130900
職務内容：
| Test Lead Job Summary To plan, deploy and manage the testing effort/work plans for the project [module] to meet the client /internal requirements as per the quality standards prescribed.
|
| 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. |
報酬と福利厚生
A candidate’s 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.
免責事項
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@hcltech.com for investigation.