We use cookies for the best user experience on our website, including to personalize content & offerings, to provide social media features and to analyze traffic. By clicking “Accept All Cookies” you agree to our use of cookies. You can also manage your cookies by clicking on the "Cookie Preferences" and selecting the categories you would like to accept. For more information on how we use cookies please visit our and Modify Cookie Preferences

Reject All Cookies Accept All Cookies

Technical Lead

India

Job Description

Technical Lead

Pune, Maharashtra

Job Summary

ETL Developer / Data TechnologistWe are seeking a highly motivated and skilled ETL Developer / Data Technologist to join our dynamic team. The ideal candidate will be a proactive problem-solver with a strong commitment to delivery, bringing cutting-edge ideas to complex data challenges.Candidate will play a crucial role in designing, developing, and maintaining robust data integration solutions that support critical business operations.

Key Responsibilities

Key Responsibilities:Design, develop, and implement efficient and scalable ETL processes using Informatica PowerCenter (10.x series).Create and optimize medium to complex Informatica mappings, transformations, and workflows.Perform root cause analysis and debug production issues within the Informatica environment.Develop and optimize complex SQL queries, stored procedures, and database objects in Oracle and SQL Server environments.Debug database query performance issues and ensure data integrity.Develop and maintain shell scripts on RHEL 8 for automation, data processing, and system administration tasks.Integrate diverse data sources and targets, including flat files (.txt, .csv) and XML files, into ETL processes.Schedule, monitor, and manage batch jobs using Control-M.Collaborate with business analysts and other technical teams to understand requirements and translate them into technical specifications.Contribute to the continuous improvement of data architecture and ETL best practices.

Skill Requirements

Required Technical Skills & Experience:ETL Tools: Minimum of 10 years of hands-on experience with Informatica PowerCenter (version 10.x preferred), including:Developing medium to complex mappings and workflows.Performance tuning and optimization techniques.Debugging and resolving production ETL issues.Operating Systems: Proficiency in working with Red Hat Enterprise Linux (RHEL 8), including command-line navigation and basic administration.Databases: Strong expertise in both Oracle and SQL Server, encompassing:Ability to write and optimize complex SQL queries.In-depth understanding and application of various join types.Proven experience in debugging database queries for performance and correctness.File Handling:



Experience in processing and integrating various file formats within ETL solutions, such as .txt, .csv, and .xml.Scripting: Solid shell scripting abilities (Bash, Ksh, etc.) for Linux environments, including script creation and debugging for automation and data manipulation.Job Scheduling: Practical experience with job scheduling tools, specifically Control-M.Understanding and knowledge of MQ , API , JAVA , certificates , ssh keys and integration with other technologies would be better to have

Other Requirements

Professional Attributes:Proactive & Self-Driven: Demonstrates initiative and takes ownership of tasks and projects.Dedicated & Accountable: Committed to delivering high-quality work and meeting deadlines consistently.Problem Solver: Possesses strong analytical skills to troubleshoot complex issues and propose effective solutions.Innovative Thinker: Eager to explore new technologies, suggest improvements, and bring fresh ideas to the team.Team Player: Excellent communication and collaboration skills, with a willingness to share knowledge and contribute to a positive team environment.

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.

Copyright © 2026 HCL Technologies Limited

×

Cookie Consent Manager

When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

Required Cookies





These cookies are required to use this website and can't be turned off.

Required Cookies

Show More Details

Required Cookies Provider Description Enabled
SAP as service provider

We use the following session cookies, which are all required to enable the website to function:

- "route" is used for session stickiness
- "careerSiteCompanyId" is used to send the request to the correct data center
- "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor
- "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another

Cookies from provider SAPasserviceprovider are required and cannot be turned off

Functional Cookies

These cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies.

Consent to all Functional Cookies

Show More Details

Functional Cookies Provider Description Enabled
Vimeo

Vimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos.

Consent to cookies from provider Vimeo

YouTube

YouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos.

Consent to cookies from provider YouTube

Advertising Cookies

These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies.

Consent to all Advertising Cookies

Show More Details

Advertising Cookies Provider Description Enabled
Google Analytics

Google Analytics is a web analytics service offered by Google that tracks and reports website traffic.

Consent to cookies from provider GoogleAnalytics

Google Tag Manager

Google Tag Manager is a tag management system for conversion tracking, site analytics, remarketing, and more.

Consent to cookies from provider GoogleTagManager

LinkedIn

LinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn.

📌 Technical Lead (India)
🏢 HCLTech
📍 India