Technical Lead (IN)

HCLTech

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

Job description

We are seeking a seasoned DataStage Engineer with extensive experience in ETL development and data warehousing. The ideal candidate will lead the design, development, and support of enterprise-scale ETL solutions, demonstrating strong technical leadership and the ability to work across diverse business domains. This role requires a proactive approach to delivering high-quality data integration outcomes.

Responsibilities

Key responsibilities include designing, developing, testing, and deploying robust ETL solutions using IBM DataStage. This involves translating business requirements into scalable ETL designs, optimizing complex workflows, and working on projects within various domains like Banking and Finance. The role also entails leading development teams, mentoring junior members, conducting code reviews, and ensuring adherence to development standards. Collaboration with business analysts, architects, DBAs, and stakeholders is crucial. Responsibilities extend to troubleshooting production issues, implementing data quality measures, participating in architectural discussions, and optimizing ETL jobs and SQL queries for peak performance and scalability.

Qualifications

Essential skills include strong hands-on experience with IBM DataStage, covering features like Parallel Jobs, Sequence Jobs, Shared Containers, Job Sequencing, Change Data Capture (CDC), performance tuning, and troubleshooting. Proficiency in multiple RDBMS platforms such as Oracle, SQL Server, and PostgreSQL is required, along with the ability to write complex SQL queries. A solid understanding of ETL/ELT concepts, data warehousing architecture, and data modeling is fundamental. Preferred experience includes other ETL tools like Informatica PowerCenter, SSIS, Talend, or Azure Data Factory. Nice-to-have skills encompass cloud data platforms (Azure, AWS, GCP), Databricks, Spark, Hadoop, DevOps/CI-CD for ETL, and an IBM DataStage certification. Knowledge of Data Quality Frameworks, Metadata Management, and Data Governance concepts is also beneficial.

Essential Skills

IBM DataStageETL DevelopmentData WarehousingSQLRDBMSParallel JobsSequence JobsShared ContainersJob SequencingChange Data Capture (CDC)DataStage Performance TuningJob Monitoring and TroubleshootingOracleSQL ServerPostgreSQLETL/ELT ConceptsData Warehousing ArchitectureData Modeling

Good to Have

Informatica PowerCenterSSISTalendAzure Data Factory (ADF)AzureAWSGCPDatabricksSparkHadoopDevOpsCI/CDData Quality FrameworksMetadata ManagementData Governance Concepts

Highlights

  • Actively hiring

More Details

RoleTechnical Lead (IN)
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Technical Lead (IN) at HCLTech | SkillMX | SkillMX