Tower Lead - Extract Transform Load (ETL), Data Lakes
India
Apply now
Job Description
Tower Lead - Extract Transform Load (ETL), Data Lakes
Kolkata, West Bengal

Job Summary

The ETL resource will be a part of a back-office support team which supports the BI infrastructure for Volvo Group. The main components that this ETL specialist will be in touch with are Informatica Powercenter, Oracle, Unix scripting and integration products (WebSphere MQ).

Resource will participate both in operational ETL support and platform development activities.

The job will include the following activities (non-exhaustive list) : Installation of Informatica upgrades, including testing Analyze how current ETL setup integrates with the scripting framework, databases and integration products.

Informatica server administration (repository) (for example adding new users, setting up new projects in the repository Solving support cases regarding the ETL setup. This could be Informatica bugs, questions regarding performance, troubleshooting the interaction between the ETL tool, the integration products and the unix scheduling scripts.

Provide help in tuning ETL jobs

Answering question from developers regarding the ETL setup

Make proposals on how the ETL setup can be improved

Maintain, improve and add new functionality to the existing framework.

We are NOT looking for an ETL developer profile but some development experience will be useful.

Profile: At least 5 years of experience with Informatica Powercenter (including Informatica CD IPC) in a large company setup (DEV, TST, QA, PROD servers).

At least 5 years of experience with scripting in a Unix/Linux environment

Solid experience with using integration products like Webshpere MQ in an ETL setup. Experience with MQ connector and/or JMS connector.

Experience with server administration and installation (upgrades, patches,…) of Informatica

At least 2 years of experience with Oracle databases.

Good knowledge of SQL language: Oracle and Sqlserver.

Extensive knowledge of data warehouse design concepts.

Strong understanding of business continuity and recovery processes and procedures.

Ability and willingness to work effectively in a business-critical production, in a global, multi-cultural organization.

Team player and can work autonomous.

Structured and strong analytical skills.

Good knowledge of English (written and oral) and excellent communication and reporting skills.

Stress resistant and you can adjust easily to fast changing environments. Strive continuously for quality and customer's satisfaction.

Key Responsibilities

Installation of Informatica upgrades, including testing Analyze how current ETL setup integrates with the scripting framework, databases and integration products. Informatica server administration (repository) (for example adding new users, setting up new projects in the repository Solving support cases regarding the ETL setup. This could be Informatica bugs, questions regarding performance, troubleshooting the interaction between the ETL tool, the integration products and the unix scheduling scripts. Provide help in tuning ETL jobs Answering question from developers regarding the ETL setup Make proposals on how the ETL setup can be improved Maintain, improve and add new functionality to the existing framework.

Skill Requirements

At least 5 years of experience with Informatica Powercenter (including Informatica CD IPC) in a large company setup (DEV, TST, QA, PROD servers). At least 5 years of experience with scripting in a Unix/Linux environment Solid experience with using integration products like Webshpere MQ in an ETL setup. Experience with MQ connector and/or JMS connector.

Other Requirements

Experience with server administration and installation (upgrades, patches,…) of Informatica At least 2 years of experience with Oracle databases. Good knowledge of SQL language: Oracle and Sqlserver. Extensive knowledge of data warehouse design concepts. Strong understanding of business continuity and recovery processes and procedures. Ability and willingness to work effectively in a business-critical production, in a global, multi-cultural organization. Team player and can work autonomous. Structured and strong analytical skills. Good knowledge of English (written and oral) and excellent communication and reporting skills. Stress resistant and you can adjust easily to fast changing environments. Strive continuously for quality and customer\'s satisfaction.
Apply now
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 226,300 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 December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.