ETL DataStage & CP4D Developer

SORIM TECHNOLOGIES; Chennai District; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading technology firm in Chennai is seeking an ETL DataStage & CP4D Developer to lead various data integration projects. The ideal candidate will have over 5 years of experience with IBM Infosphere DataStage and Cloud Pak for Data, focusing on high-volume data management, compliance, and data security. Responsibilities include architecting ETL pipelines, optimizing performance, and ensuring adherence to security standards. This full-time role offers dynamic challenges in a fast-paced environment.

Qualifications

• 5+ years of hands-on experience in ETL development.
• Deep expertise in IBM Infosphere DataStage and Cloud Pak for Data.
• Proven track record in managing high-volume data integration projects.

Responsibilities

• Lead the design and development of DataStage parallel jobs.
• Architect and optimize ETL pipelines within CP4D.
• Implement transformation logic to ensure compliance for Credit Bureaus.
• Perform performance tuning of ETL jobs.
• Develop Unix shell scripts for file handling and automated alerting.
• Ensure data movements adhere to security requirements.
• Provide comprehensive documentation for ETL designs and procedures.

Skills

ETL Tooling: IBM Infosphere DataStage v11.x

Cloud Pak for Data (CP4D)

Google Big Query

Google Cloud Storage

Microsoft SQL Server

T-SQL

Big Query SQL

Unix/Linux Shell Scripting

Python

Metro2 reporting formats

PGP Encryption

secure SFTP protocols

Job description

Position Title: ETL DataStage & CP4D Developer

Brief description: Hands‑on experience in ETL development, with deep expertise in IBM Infosphere DataStage and Cloud Pak for Data (CP4D). Must have a proven track record of managing high‑volume data integration projects, specifically transitioning or integrating on‑premises ETL workloads with Google Big Query. This role requires technical autonomy to lead the development of complex interfaces for the Collections and Finance, Accounting & Tax portfolios, ensuring bank‑grade data integrity and compliance.

Employment: Full time

Experience level: 5+ years of experience

Key responsibilities:

• Lead the design and development of DataStage parallel jobs and sequences to ingest and transform FCB/IB data into the Core Platform.
• Architect and optimize ETL pipelines within CP4D to manage the 100 jobs and 50+ tables required for the Core systems.
• Implement complex transformation logic to ensure outbound files meet Metro2 compliance for all five Credit Bureaus within the Collections portfolio.
• Perform performance tuning of ETL jobs to ensure high‑volume batch processing completes within the Bank's defined nightly windows.
• Develop and maintain Unix shell scripts for advanced file handling, pre/post‑job processing, and automated alerting.
• Ensure all data movements adhere to bank‑grade security requirements, including the implementation of PGP encryption routines within DataStage.
• Provide comprehensive documentation for all ETL designs, mapping documents, and recovery procedures to ensure operational stability.

Required skills:

• ETL Tooling: IBM Infosphere DataStage v11.x and Cloud Pak for Data (CP4D).
• Google Cloud Platform (GCP): Google Big Query (BQ) and Google Cloud Storage.
• Database: Microsoft SQL Server, T‑SQL, and Big Query SQL.
• Scripting/OS: Unix/Linux Shell Scripting and Python.
• Compliance/Security: Metro2 reporting formats, PGP Encryption, and secure SFTP protocols

If you are interested, please share to [e-mail]