Datastage Consultant

HCLTech; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

HCLTech in Chennai, India, seeks a DataStage Technical Lead to guide delivery of data integration projects. You will oversee design, development, and deployment of IBM Infosphere DataStage jobs and workflows, collaborating with stakeholders to translate requirements into robust ETL solutions.

You will mentor a team, optimize SQL and Oracle PL/SQL routines, and automate data loading with Unix shell scripts, while championing best practices and continuous improvement in a fast-paced, client-facing

Qualifications

• Experience leading ETL projects using IBM Infosphere DataStage.
• Strong SQL skills with Oracle database proficiency.
• Proficient in Oracle PL/SQL development and tuning.
• Unix shell scripting for automation.
• Excellent communication and leadership abilities.
• Project management experience.
• Knowledge of Azure DevOps for CI/CD.

Responsibilities

• Lead and manage a team of developers in DataStage ETL design and deployment.
• Collaborate with cross-functional teams to gather data integration requirements.
• Develop and optimize ETL processes using DataStage.
• Design, implement, and optimize SQL queries in Oracle databases.
• Create Unix shell scripts to automate data loading and system tasks.
• Troubleshoot issues, perform performance tuning, and ensure data integrity.
• Provide technical guidance and ensure best practices.
• Stay updated on data integration technologies to improve delivery.

Skills

InfoSphere DataStage

SQL

Oracle PL/SQL

Unix Shell Scripting

Data Integration

ETL

Leadership

Azure DevOps

Analytical Thinking

Job description

Job description

Key Responsibilities

Role: DataStage Technical Lead

Job Summary

The Technical Lead will be responsible for overseeing and leading the technical aspects of projects involving IBM Infosphere DataStage Suite, SQL, Oracle PL/SQL, and Unix Shell Scripting. The role involves designing, developing, and implementing data integration solutions utilizing these technologies to meet business requirements and objectives efficiently.

Key Responsibilities

1. Lead and manage a team of developers in the design, development, and deployment of ibm infosphere datastage jobs and workflows.
2. Collaborate with cross functional teams to gather and analyze requirements for data integration projects.
3. Develop and maintain etl processes using ibm infosphere datastage, ensuring optimal performance and data quality.
4. Design, implement, and optimize sql queries in oracle databases for data retrieval and manipulation.
5. Create and maintain unix shell scripts to automate data loading processes and perform system tasks efficiently.
6. Troubleshoot technical issues, conduct performance tuning, and ensure data integrity across all systems.
7. Provide technical guidance and support to team members, ensuring adherence to best practices and standards.
8. Stay updated on the latest technologies and tools in data integration to drive innovation and efficiency in project delivery.

Skill Requirements

1. Proficiency in ibm infosphere datastage suite for designing and implementing etl solutions.
2. Strong sql skills with the ability to write complex queries, stored procedures, and functions in oracle databases.
3. Experience in oracle pl/sql for database programming and optimization.
4. Proficient in unix shell scripting for automation of data processes and system tasks.
5. Strong analytical and problem-solving skills to troubleshoot and resolve technical issues efficiently.
6. Excellent communication and leadership skills to effectively lead a technical team and collaborate with stakeholders.
7. Proven experience in project management, including planning, organizing, and executing technical projects effectively.
8. Strong knowledge of azure devops to build and deploy