DataStage Senior Technical Lead
India
Apply now
Job Description
DataStage Senior Technical Lead
Pune, Maharashtra

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

Other Requirements

  • Demonstrable experience of eliminating toil through the use of Unix and / or Powershell scripting, Ansible, dbDoes, dbRun, dbOrbit etc.
  • Demonstrable experience working with Oracle 19c and/or MSSQL Databases 2022, SQL Queries (Stored Procs, DML and DDL).
  • Preferably some experience with AI Agent bots.
  • Preferably some experience in automating the Application and Database Release & Deployments.
  • Knowledge of SDLC Governance and Release Management.
  • Should have promising investigative skills and problem-solving techniques.
  • Experience in code management and source code repo tools like GIT, BitBucket etc.
  • Exposure to working with Confluence, SharePoint, TeamCity, Udeploy and JIRA.
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 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.