Test Specialist (IN)

HCLTech

Fresher India Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a skilled ETL Tester to ensure data integrity and accuracy across enterprise data warehouse and analytics platforms. This role involves validating data movement, transformation logic, data quality, and reporting accuracy.

You will collaborate closely with development, business, and QA teams to understand requirements, create test scenarios, execute data validation, and identify defects, ensuring end-to-end data integrity from source to target systems.

Responsibilities

Analyze business requirements and design documents to define test scope. Prepare detailed test scenarios, test cases, and SQL validation scripts for ETL and data warehouse testing. Perform source-to-target data validation, checking transformation rules, joins, filters, and aggregations. Execute backend database testing with complex SQL queries and perform data quality checks. Validate various file formats and utilize Unix/Linux commands for file analysis. Identify, log, and track defects using tools like JIRA. Collaborate with cross-functional teams to resolve data issues and support end-to-end testing cycles. Prepare test execution reports and participate in Agile ceremonies.

Qualifications

Requires strong experience in ETL, data warehouse, database testing, and data migration validation. Proficiency in writing complex SQL queries for data validation and root cause analysis is essential. A solid understanding of ETL/ELT concepts, data warehouse architecture, and dimensional modeling is necessary. Experience with databases like Oracle, SQL Server, Teradata, Snowflake, or similar platforms. Familiarity with ETL tools such as Informatica, Azure Data Factory, or Talend. Experience validating batch jobs, file loads, data pipelines, and incremental loads. Working knowledge of Unix/Linux commands for file validation. Proficiency with test management and defect tracking tools like JIRA or Azure DevOps. Understanding of SDLC, STLC, and Agile methodologies.

Essential Skills

ETL testingData Warehouse TestingDatabase TestingData Migration ValidationSQLETL conceptsELT conceptsData Warehouse ArchitectureDimensional ModelingStaging LayersReporting LayersOracleSQL ServerTeradataSnowflakeRedshiftDB2MySQLInformaticaIBM DataStageAzure Data FactoryMatillionTalendBatch JobsFile LoadsData PipelinesIncremental LoadsScheduled WorkflowsUnix/Linux commandsJIRAALMqTestAzure DevOpsSpiraPlanSDLCSTLCAgile methodologyTest Lifecycle ProcessesQuality Assurance

Good to Have

AWSAzureGoogle Cloud PlatformAWS AthenaS3DatabricksBig DataHadoopHiveSparkPower BITableauOBIEEMicroStrategySAP BOBJPythonShell scripting

Highlights

  • Actively hiring

More Details

RoleTest Specialist (IN)
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Test Specialist (IN) at HCLTech | SkillMX | SkillMX