Job description:

About HCLTech
HCLTech is a global technology company, spread 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. We re powered by our people a global, diverse, multi-generational talent - representing 161 nationalities whose unique spark, perspective and boundless passion drive our culture of proactive value creation and problem-solving.
Our purpose is to bring together the best of technology and our people to supercharge progress for everyone, everywhere our clients, partners, their stakeholders, communities, and the planet. As a company, we are deeply focused on accelerating our ESG agenda. We are also creating technology-enabled sustainable solutions with and for our clients and partners. We embed ESG imperatives into every aspect of our business and ensure that the progress we supercharge is responsible, inclusive and beneficial to all our stakeholders in the long term. We have committed to achieving net zero by 2040.

To learn more about how we can supercharge progress for you, visit www.hcltech.com

Datastage Senior Technical Lead with IBM Infosphere Datastage Suite,SQL,Oracle PL/SQL,Unix Shell Scripting

Job Summary
The Senior Technical Lead will be responsible for leading technical teams and implementing projects utilizing IBM Infosphere DataStage Suite, SQL, Oracle PL/SQL, and Unix Shell Scripting. The role involves designing, developing, and maintaining complex ETL processes and databases while ensuring high performance and reliability of data workflows.

• Key Responsibilities
  1. Lead technical teams in the implementation of projects using ibm infosphere datastage suite, sql, oracle pl/sql, and unix shell scripting.
  2. Design, develop, and optimize etl processes to extract, transform, and load data efficiently.
  3. Collaborate with cross functional teams to gather business requirements and translate them into technical solutions.
  4. Provide technical guidance and mentorship to junior team members.
  5. Perform code reviews, identify areas for improvement, and ensure best practices are followed.
  6. Troubleshoot and resolve complex technical issues related to data processing and integration.
  7. Monitor system performance and ensure data accuracy and integrity.
  8. Stay updated with industry trends and technologies to recommend innovative solutions for continuous improvement.
  
  Skill Requirements
  1. Proficiency in ibm infosphere datastage suite for etl development.
  2. Strong expertise in sql for data manipulation and querying.
  3. In-depth knowledge of oracle pl/sql for database development and management.
  4. Proficient in unix shell scripting for automation and scheduling tasks.
  5. Ability to work collaboratively in a team environment and lead technical discussions.
  6. Strong problem-solving skills and attention to detail with excellent communication and interpersonal skills
  7. Experience in performance tuning and optimization of etl processes.
  8. Knowledge of data warehouse concepts and methodologies.
  9. Knowledge of using azure devops for build and deploy
  10. Familiarity with creating physical data model based on the data model logic