Description

- Architecture & Design: Lead end-to-end ETL architecture using IBM InfoSphere DataStage (v11.5 / v11.7), designing scalable data warehouse, ODS, and data mart schemas (Star and Snowflake).

- Development & Migration: Design, develop, and maintain complex DataStage parallel jobs, sequences, shared containers, and routines. Lead the migration of legacy DataStage versions to up-to-date or cloud-integrated environments.

- Performance Tuning: Troubleshoot and fine-tune long-running, high-volume ETL jobs, database queries (Oracle, Teradata, DB2, Snowflake, or SQL Server), and server/cluster bottlenecks.

- Environment & Administration: Handle DataStage administration tasks, including patch installations, upgrades, configuration of plug-ins/connectors, and managing user security/projects.

- DevOps & Automation: Integrate DataStage deployments with CI/CD pipelines (Jenkins, Git, GitHub, Ansible) and enterprise schedulers (Control-M, AutoSys).

- Leadership & Stakeholder Management:



Act as a technical bridge between business analysts, data architects, and executive leadership. Estimate project efforts, conduct code reviews, and enforce data governance and quality standards.

Enable Skills-Based Hiring

No

ECMS REQ IDAdditional Details

- ECMS REQ ID : 583777
- Project Location 1 : MAH | PUNE
- Project Location 2 : TELANGANA | HYDERABAD
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : Nitin
- Relevant Experience : 5Years
- Mandatory skills : Datastage, SQL,Python
- Desired skills : Devops,GCP
- Domain (Industry) : Banking
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 5 to 10 years
- BGC Details : Account Specific
- BGC Vendor : Account Specific
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : General
- Shift Timings : General

📌 583777_DNAFS_HSBC_Datastage (India)
🏢 Trigent Software
📍 India