Test Specialist (IN)

HCLTech

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

Job description

Seeking an experienced ETL Tester to ensure data accuracy and integrity across enterprise data warehouse and analytics platforms. This role involves collaborating with various teams to understand requirements, design test strategies, execute validation procedures, and pinpoint defects. The focus is on guaranteeing end-to-end data quality from source systems through to target environments.

Responsibilities

Analyze business requirements and technical documentation to define test scope. Develop detailed test scenarios, test cases, and SQL validation scripts for ETL and data warehouse testing. Conduct source-to-target data validation, verifying transformation logic, data quality, and consistency across databases and files. Execute backend database testing using complex SQL queries and perform data quality checks for completeness, accuracy, and integrity. Validate various file formats and utilize Unix/Linux commands for file analysis as needed. Identify, document, and track defects using JIRA or similar tools. Work closely with developers and business analysts to resolve data issues and support comprehensive testing cycles. Prepare status reports and participate in Agile ceremonies, including daily stand-ups and sprint planning.

Qualifications

Requires strong hands-on experience in ETL, data warehouse, database testing, and data migration. Must possess excellent SQL skills for complex query writing and data reconciliation. A solid understanding of ETL/ELT concepts, data warehouse architecture, and dimensional modeling is essential. Experience with relational databases like Oracle, SQL Server, Teradata, Snowflake, etc., and ETL tools such as Informatica, Azure Data Factory, or Talend is necessary. Familiarity with validating batch jobs, incremental loads, and scheduled workflows, along with working knowledge of Unix/Linux commands, is expected. Proficiency in test management and defect tracking tools like JIRA or Azure DevOps is required. The ability to perform root cause analysis and communicate findings effectively to technical and business stakeholders is key. A good grasp of SDLC, STLC, and Agile methodologies is also important.

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