HCL Unica Product _ Sr. QA Engineer / Data Tester (ETL + Data Testing)_F2F Interview 10th Jan_Pune (Hinjawadi)

Greetings from "HCL Software"

"HCL Software”: -

About Unica Product: -

Imp Note: Are you available for a F2F Interview on Saturday (10th Jan) In Pune HCL Software office?

Location/Venue: - Mekong 2nd Floor, Embassy TechZone, Hinjewadi Rajiv Gandhi Infotech Park, Hinjawadi Phase 2, Pune, Maharashtra 411033.

Qualifications: -

We are looking for a Sr. QA Engineer / Data Tester (ETL + Data Testing) with 4+ Yrs experience in our Unica Product team who possess the following skills: -

Role Context: -

Ensure quality assurance for data platforms and ETL pipelines through black-box and white-box testing, with strong coverage across integration testing, performance testing, and ETL automation testing. The tester will create test plans, test cases, and scripts, and work closely with data engineers, architects, and BAs to validate transformation correctness, integrity, and operational readiness.

Must Have: -

• Strong SQL skills to validate transformations, aggregates, and reconciliation rules.

• Proven experience testing ETL pipelines and data transformations (batch and/or near real-time).

• Hands-on experience with:

• Integration testing across data layers and pipelines

• Performance testing for ETL jobs (volume, runtime, regression analysis)

• Black-box and white-box testing methodologies

• Experience creating test plans, test scripts, and executing structured test cycles.

• Exposure to ETL testing automation approaches:

• SQL-based automation harness, dbt tests, Great Expectations, or comparable framework-based validation.

• Understanding of SCD/CDC, incremental loads, dependencies, and reprocessing/backfills.

• Delivery/DevOps fundamentals: Git usage, CI/CD familiarity for automated test execution, environment promotions.

• Non-technical: strong attention to detail, documentation discipline, stakeholder communication, ability to work with engineers to reproduce issues.

Key Responsibilities

• Perform

  black-box testing

  (validating outputs against requirements without internal logic dependency).
• Perform

  white-box testing

  (validating transformation logic, joins, filters, dependencies, and code paths).
• Design and execute

  integration testing

  across multi-source ingestion, transformation layers, and downstream consumption.
• Execute

  performance testing

  for ETL workloads: runtime benchmarking, volume testing, concurrency/load impact, and regression detection.
• Prepare and maintain test artifacts: test strategy, test plan, test cases, test scripts, and traceability matrix.
• Implement

  ETL automation testing

  for regression suites and repeatable validations (SQL harness, frameworks, CI-driven execution).
• Validate data quality: completeness, uniqueness, consistency, referential integrity, business rule correctness.
• Perform reconciliation testing: source-to-target counts/sums, delta validations, incremental loads, and backfill correctness.
• Support release readiness: UAT support, defect triage, RCA collaboration, and sign-off.

Good To Have: -

• Python for automation scripting (pytest-based validation, framework extension).
• Experience with orchestration tools (Airflow) and validating DAG behaviors (retries, SLAs, backfills).
• Observability exposure: log analysis, monitoring dashboards, alert validation.
• Knowledge of test data management strategies (synthetic datasets, masking, controlled fixtures).
• Exposure to cloud data platforms and warehouses (AWS/Azure/GCP + Snowflake/BigQuery/Redshift etc.).
• Familiarity with API testing if pipelines expose data services.