We are hiring an experienced DataStage Developer with hands-on Google Cloud Platform exposure to build and modernize enterprise data pipelines. The role sits within our Data Engineering practice and involves both sustaining existing IBM InfoSphere DataStage workloads and migrating them to a cloud-native GCP stack.

Key Responsibilities

- Design, develop, and optimize ETL jobs using IBM InfoSphere DataStage (11.x / 12.x) parallel jobs, sequences, and shared containers
- Migrate legacy DataStage pipelines to GCP-native services (BigQuery, Cloud Storage, Dataflow, Cloud Composer)
- Build and schedule orchestration workflows using Cloud Composer / Apache Airflow
- Write and tune complex SQL for data transformation, reconciliation, and BigQuery performance optimization (partitioning, clustering, slot usage)
- Perform source-to-target mapping, data profiling, and impact analysis for migration workstreams
- Implement error handling, restartability, logging, and data quality checks across pipelines




- Tune DataStage job performance — partitioning strategies, buffer tuning, parallel configuration files (APT_CONFIG_FILE)
- Support UAT, production deployments, and post-go-live hypercare; troubleshoot job failures and SLA breaches
- Collaborate with data architects, BAs, and QA teams in an Agile/Scrum delivery model
- Maintain technical documentation, unit test cases, and deployment runbooks

Must-Have Skills

- 4+ years of robust hands-on IBM DataStage development (Designer, Director, Administrator)
- Solid SQL and RDBMS experience — Oracle, DB2, Teradata, or SQL Server
- Practical working experience on GCP: BigQuery + at least one of Dataflow, Cloud Composer, Dataproc, Pub/Sub
- Strong understanding of data warehousing concepts — dimensional modelling, SCD Types 1/2, star/snowflake schema
- Experience with Unix/Linux shell scripting
- Job scheduling tools — Control-M, Autosys, or Tivoli

📌 Datastage Consultant (Hyderabad)
🏢 Capgemini
📍 Hyderabad