Technical Lead (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Join our team as a Technical Lead and spearhead the delivery of robust Data Warehouse (DWH) solutions. This role focuses on leveraging cutting-edge ETL technologies like Informatica (IICS/IDMC), Databricks, and Spark, alongside database expertise in PostgreSQL and Oracle. You will be instrumental in architecting and implementing efficient DWH solutions, driving performance optimizations, and ensuring seamless production support. This position also emphasizes championing automation and continuous improvement initiatives within the data landscape.

Responsibilities

Drive ETL development using Informatica (IICS/IDMC) and Databricks. Develop and optimize complex SQL, PL/SQL, Spark SQL, Hive, and Presto queries. Design and maintain database objects like procedures, functions, and triggers. Implement query tuning and ETL performance enhancements. Interpret data models and design scalable ETL architectures prioritizing data quality and error handling. Support existing infrastructure and contribute to future architecture designs. Evaluate emerging technologies through proof-of-concept projects. Execute all SDLC phases, adhere to SAFe Agile principles, and participate in release and post-production support activities.

Qualifications

Proven expertise in ETL development and data warehousing. Strong command over Informatica (IICS/IDMC) and Databricks. Proficient with database technologies including PostgreSQL, Oracle, SQL Server, and DB2 UDB. Skilled in developing and tuning SQL, PL/SQL, Spark SQL, Hive, and Presto. Experience with Big Data technologies like Spark and querying languages. Programming and scripting capabilities in Python and UNIX are essential. Knowledge of data modeling and data warehousing principles is required. Experience with SDLC, Agile methodologies, and SAFe is expected.

Essential Skills

InformaticaIICSIDMCDatabricksSparkPostgreSQLOracleSQLPL/SQLSpark SQLHivePrestoPythonUNIXData WarehousingData ModelingSQL ServerDB2 UDB

Highlights

  • Actively hiring

More Details

RoleTechnical Lead (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting