Senior Test Lead

Overview

On Site
$52 - $52
Contract - W2
Contract - 1 month(s)
No Travel Required

Skills

Senior Test Lead

Job Details

Job Description:
  • The QA Engineer will participate in technical and functional discussions, identify process improvement opportunities, oversee automated test script creation, and mentor QA engineers.
  • The role focuses on ensuring data accuracy, integrity, and quality across ETL processes involving Informatica and dbt.
Requirement/Must Have:
  • Strong experience in ETL testing with Informatica PowerCenter.
  • Experience with dbt (Data Build Tool).
  • Proficiency in SQL and Snowflake.
  • Experience with Git and JIRA.
Responsibilities:
  • Participate in functional and technical discussions with the client/team to understand design specifications, highlight performance concerns, and ensure test environments are maintained.
  • Identify opportunities for process improvement in testing methodologies and tools, implementing best practices.
  • Oversee the creation and execution of automated test scripts to align with quality standards.
  • Develop, guide, and mentor QA engineers in using the testing framework to enhance capabilities and productivity.
  • Define QA strategy for a hybrid ETL stack involving Informatica and dbt.
  • Analyze source-to-target mapping documents, business rules, and dbt model definitions to derive test scope.
  • Plan and manage test phases across releases, including unit testing, system testing, integration testing, and UAT support.
  • Review and validate Informatica mappings, workflows, sessions, and parameter files.
  • Validate source data extraction, data transformations, and load strategies to staging/ODS layers.
  • Use SQL queries and data comparison tools for reconciliation and transformation validation.
  • Validate job dependencies and control table mechanisms.
  • Monitor job runs via Informatica tools to ensure correct execution.
  • Validate dbt models, tests, and documentation in the analytics layer.
  • Review model SQL logic, YAML metadata, dbt test configurations, and execute dbt test suites.
  • Collaborate with analytics engineers to validate materialization strategies and source freshness logic.
  • Perform data validation and reconciliation across all data layers using complex SQL queries.
  • Ensure PII masking and data obfuscation where applicable.
  • Build and maintain reusable SQL-based test automation scripts.
  • Integrate QA checks into CI/CD pipelines.
  • Monitor Informatica batch schedules and dbt jobs.
  • Contribute to QA dashboards and automated reporting.
  • Log and track defects in JIRA, facilitate defect triage calls, and provide detailed test execution reports.
  • Coordinate with data engineers, analytics engineers, data modelers, and product owners.
  • Represent QA during PI Planning and system demos.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.