DataStage Senior Technical Lead (India)

25 Sep

HCLTech

India

25 Sep

HCLTech

India

DataStage Senior Technical Lead

Bangalore, Karnataka

Job Summary

Job Summary

We are seeking an experienced Data Engineer with robust expertise in IBM DataStage, Oracle Database, and Linux/Unix environments to design, develop, optimize, and support enterprise-scale ETL solutions. The ideal candidate will have hands-on experience in data integration, performance tuning, batch processing, and production support within large-scale data warehouse ecosystems.

Key Responsibilities

- Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage .
- Build and maintain complex ETL jobs for extracting, transforming, and loading data from multiple source systems.
- Develop and optimize Oracle SQL, PL/SQL procedures, packages, functions, and triggers .
- Perform data profiling, data validation, reconciliation, and root cause analysis.
- Monitor and troubleshoot ETL workflows, batch jobs, and production issues.
- Optimize ETL processes for performance, scalability, and reliability.
- Work extensively in Linux/Unix environments for job scheduling, deployment, and automation.
- Implement shell scripts to automate operational and data-processing tasks.
- Collaborate with business analysts, architects, and application teams to understand data requirements.
- Participate in code reviews and ensure adherence to development standards and best practices.
- Support data migration, data quality initiatives, and system upgrades.

Required Technical Skills

ETL & Data Integration

- IBM DataStage (PX, Server Jobs, Sequence Jobs)
- ETL Design & Development
- Data Warehousing Concepts
- Metadata Management

Database

- Oracle Database (11g/12c/19c)
- Advanced SQL
- PL/SQL Development
- Query Performance Tuning
- Indexing & Partitioning

Linux/Unix

- Shell Scripting (Bash/Korn Shell)
- Linux Commands & File Handling
- Process Monitoring
- Job Scheduling

Data Management

- Data Profiling
- Data Validation & Reconciliation
- Data Quality Management
- Batch Processing

Preferred Skills

- Banking, Financial Services, or Insurance (BFSI) domain experience.
- Experience with scheduling tools such as Autosys, Control-M, or Cron.
- Exposure to cloud platforms (AWS, Azure, or GCP).
- Knowledge of Data Governance and Data Quality frameworks.
- Experience with Git, Jenkins, or CI/CD pipelines.
- Familiarity with Agile/Scrum methodology.

Key Responsibilities

Job Summary

We are seeking an experienced Data Engineer with strong expertise in IBM DataStage, Oracle Database, and Linux/Unix environments to design, develop, optimize, and support enterprise-scale ETL solutions. The ideal candidate will have hands-on experience in data integration, performance tuning, batch processing, and production support within large-scale data warehouse ecosystems.

Key Responsibilities

- Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage .
- Build and maintain complex ETL jobs for extracting, transforming, and loading data from multiple source systems.
- Develop and optimize Oracle SQL, PL/SQL procedures, packages, functions, and triggers .
- Perform data profiling, data validation, reconciliation, and root cause analysis.
- Monitor and troubleshoot ETL workflows, batch jobs, and production issues.

- Optimize ETL processes for performance, scalability, and reliability.
- Work extensively in Linux/Unix environments for job scheduling, deployment, and automation.
- Implement shell scripts to automate operational and data-processing tasks.
- Collaborate with business analysts, architects, and application teams to understand data requirements.
- Participate in code reviews and ensure adherence to development standards and best practices.
- Support data migration, data quality initiatives, and system upgrades.

Required Technical Skills

ETL & Data Integration

- IBM DataStage (PX, Server Jobs, Sequence Jobs)
- ETL Design & Development
- Data Warehousing Concepts
- Metadata Management

Database

- Oracle Database (11g/12c/19c)
- Advanced SQL
- PL/SQL Development
- Query Performance Tuning
- Indexing & Partitioning

Linux/Unix

- Shell Scripting (Bash/Korn Shell)
- Linux Commands & File Handling
- Process Monitoring
- Job Scheduling

Data Management

- Data Profiling
- Data Validation & Reconciliation
- Data Quality Management
- Batch Processing

Preferred Skills

- Banking, Financial Services, or Insurance (BFSI) domain experience.
- Experience with scheduling tools such as Autosys, Control-M, or Cron.
- Exposure to cloud platforms (AWS, Azure, or GCP).
- Knowledge of Data Governance and Data Quality frameworks.
- Experience with Git, Jenkins, or CI/CD pipelines.
- Familiarity with Agile/Scrum methodology.

Skill Requirements

Job Summary

We are seeking an experienced Data Engineer with strong expertise in IBM DataStage, Oracle Database, and Linux/Unix environments to design, develop, optimize, and support enterprise-scale ETL solutions. The ideal candidate will have hands-on experience in data integration, performance tuning, batch processing, and production support within large-scale data warehouse ecosystems.

Key Responsibilities

- Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage .
- Build and maintain complex ETL jobs for extracting, transforming, and loading data from multiple source systems.
- Develop and optimize Oracle SQL, PL/SQL procedures, packages, functions, and triggers .
- Perform data profiling, data validation, reconciliation, and root cause analysis.
- Monitor and troubleshoot ETL workflows, batch jobs, and production issues.
- Optimize ETL processes for performance, scalability, and reliability.
- Work extensively in Linux/Unix environments for job scheduling, deployment, and automation.
- Implement shell scripts to automate operational and data-processing tasks.
- Collaborate with business analysts, architects, and application teams to understand data requirements.
- Participate in code reviews and ensure adherence to development standards and best practices.
- Support data migration, data quality initiatives, and system upgrades.

Required Technical Skills

ETL & Data Integration

- IBM DataStage (PX, Server Jobs, Sequence Jobs)
- ETL Design & Development
- Data Warehousing Concepts
- Metadata Management

Database

- Oracle Database (11g/12c/19c)
- Advanced SQL
- PL/SQL Development
- Query Performance Tuning
- Indexing & Partitioning

Linux/Unix

- Shell Scripting (Bash/Korn Shell)
- Linux Commands & File Handling
- Process Monitoring
- Job Scheduling

Data Management

- Data Profiling
- Data Validation & Reconciliation
- Data Quality Management
- Batch Processing

Preferred Skills

- Banking, Financial Services, or Insurance (BFSI) domain experience.
- Experience with scheduling tools such as Autosys, Control-M, or Cron.
- Exposure to cloud platforms (AWS, Azure, or GCP).
- Knowledge of Data Governance and Data Quality frameworks.
- Experience with Git, Jenkins, or CI/CD pipelines.
- Familiarity with Agile/Scrum methodology.

Other Requirements

Job Summary

We are seeking an experienced Data Engineer with strong expertise in IBM DataStage, Oracle Database, and Linux/Unix environments to design, develop, optimize, and support enterprise-scale ETL solutions. The ideal candidate will have hands-on experience in data integration, performance tuning, batch processing, and production support within large-scale data warehouse ecosystems.

Key Responsibilities

- Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage .
- Build and maintain complex ETL jobs for extracting, transforming, and loading data from multiple source systems.
- Develop and optimize Oracle SQL, PL/SQL procedures, packages, functions, and triggers .
- Perform data profiling, data validation, reconciliation, and root cause analysis.
- Monitor and troubleshoot ETL workflows, batch jobs, and production issues.
- Optimize ETL processes for performance, scalability, and reliability.
- Work extensively in Linux/Unix environments for job scheduling, deployment, and automation.
- Implement shell scripts to automate operational and data-processing tasks.
- Collaborate with business analysts, architects, and application teams to understand data requirements.
- Participate in code reviews and ensure adherence to development standards and best practices.
- Support data migration, data quality initiatives, and system upgrades.

Required Technical Skills

ETL & Data Integration

- IBM DataStage (PX, Server Jobs, Sequence Jobs)
- ETL Design & Development
- Data Warehousing Concepts
- Metadata Management

Database

- Oracle Database (11g/12c/19c)
- Advanced SQL
- PL/SQL Development
- Query Performance Tuning
- Indexing & Partitioning

Linux/Unix

- Shell Scripting (Bash/Korn Shell)
- Linux Commands & File Handling
- Process Monitoring
- Job Scheduling

Data Management

- Data Profiling
- Data Validation & Reconciliation
- Data Quality Management
- Batch Processing

Preferred Skills

- Banking, Financial Services, or Insurance (BFSI) domain experience.
- Experience with scheduling tools such as Autosys, Control-M, or Cron.
- Exposure to cloud platforms (AWS, Azure, or GCP).
- Knowledge of Data Governance and Data Quality frameworks.
- Experience with Git, Jenkins, or CI/CD pipelines.
- Familiarity with Agile/Scrum methodology.

📌 DataStage Senior Technical Lead (India)
🏢 HCLTech
📍 India

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Social Media Executive (Gwalior)

26 Sep

RISHISHWAR INDUSTRY PRIVATE

Gwalior

26 Sep
RISHISHWAR INDUSTRY PRIVATE
Gwalior

This is a remote position. Summary We are seeking a dynamic and creative Social Media Executive to spearhead our digital presence and drive brand engagement across key platforms. In this pivotal [...]

Inside Sales Representative (Agra)

26 Sep

Credex Healthcare

Agra

26 Sep
Credex Healthcare
Agra

Inside Sales Representative (Closer) – US Healthcare - RCM (medical billing or credentialing) (Remote | EST Shift 9am-6pm) About the job We are seeking a motivated and results-driven RCM (med [...]

Growth & Lead Generation Manager (Remote) (Ajmer)

26 Sep

First Choice Business Debt Solutions

Ajmer

26 Sep
First Choice Business Debt Solutions
Ajmer

Company Description First Choice Business Debt Solutions is dedicated to helping small businesses, particularly Construction, Trade, and Trucking companies, overcome financial hardships caused by Me [...]