Kindly share only local profiles with in the range.
Kindly share who are local to Texas .
Kindly share who can share stamped visa copy , i94 with ppn , local id proof only
Job Title/Role ETL, Test Data Lead
San Antonio, TX, 78288/
Plano, TX, 75024
$50-55/hr on c2c
10+yrs
Mandatory required skills: ETL , TEST, LEAD,Informatica PowerCenter, dbt (Data Build Tool), SQL, Snowflake, Git, JIRA, RDBMS , MAINFRAME , FILTERS ,
Preferred/Desired skills Test Automation, Functional Testing
Please share the Detailed Job Description
Responsibilities
1. QA Strategy and Planning
• Define QA strategy for a hybrid ETL stack involving Informatica, and dbt for transformation/modeling.
• Analyze STTMs (Source-to-Target 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 staging/ODS 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 Validation & Reconciliation
• 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 Management & Reporting
• 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.
• Coordinate test data provisioning and masking with data stewards.
• Participate in scrum ceremonies, sprint planning, and retrospectives.
• Represent QA during PI Planning and system demos (SAFe).
Regards
Pavan
VDart Inc
Ph: (470) 251-2584 Ext:1866
Email: Pavankumar.s@vdartinc.com
Website: https://vdart.com
Confidentiality Notice
The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xrecnet/CAGf9M08Wbq6b6-fUu11WozjhvidnGGHNm%3D2A%2BnYdD0qJYGCf7A%40mail.gmail.com.
No comments:
Post a Comment