Greetings from "HCL Software"
"HCL Software”: - Is a Product Development Division of HCL Tech that operates its primary Software business. At HCL Software we develop, market, sell, and support over 20 product families in the areas of Customer Experience, Digital Solutions, Secure DevOps, Security & Automation.
About Unica Product: - HCL Unica is Cloud Native. Adopt the whole new HCL Unica—a cloud-native integrated marketing platform that can be deployed with the choice and flexibility to scale on any cloud & any environment (public, private, or hybrid) in minutes.
Qualifications: -
We are looking for a Sr. QA Engineer (ETL + Data Testing) with 5+ 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, and environment promotions.
- Non-technical: strong attention to detail, documentation discipline, stakeholder communication, and the ability to work with engineers to reproduce issues.
- 5 Days working from the Pune HCL Office.
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, and 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, and 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 is required if pipelines expose data services.