Technical Lead (IN)
HCLTech
HCLTech
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.
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.
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.
HCLTech
IT Consulting