ETL DataStage Developer

Job Title : ETL DataStage Developer

Job Location : Seattle, WA (ONSITE)

Job Type : Full-Time

Job Description:

ETL Developer :

10 years of experience

Role Summary

We are seeking a highly skilled and results-driven ETL Developer with extensive hands-on experience in IBM DataStage and IBM Cloud Pak for Data (CP4D). The ideal candidate will be responsible for designing, developing, optimizing, and supporting enterprise-scale ETL solutions, data integration pipelines, and modernization initiatives involving migration from legacy DataStage environments to cloud-native data platforms.

The candidate should possess strong expertise in data warehousing, data transformation, performance optimization, and production support while collaborating with cross-functional teams in an Agile delivery environment.

Key Responsibilities

•              Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage (latest versions).

•              Develop scalable and high-performance data pipelines for batch and near real-time processing.

•              Lead migration and modernization initiatives from traditional DataStage environments to IBM Cloud Pak for Data (CP4D).

•              Design and implement reusable ETL frameworks, shared containers, parameter sets, and automation components.

•              Perform complex data mapping, transformation, cleansing, enrichment, and validation activities.

•              Conduct performance tuning and optimization of ETL jobs, databases, and data flows.

•              Analyze production issues, perform root-cause analysis, and implement permanent fixes.

•              Collaborate with Data Architects, Business Analysts, Product Owners, and QA teams during solution design and delivery.

•              Participate in Agile ceremonies including Sprint Planning, Daily Standups, Reviews, and Retrospectives.

•              Create and maintain technical design documents, source-to-target mappings, and operational runbooks.

•              Ensure compliance with enterprise security, governance, and data quality standards.

Mandatory Technical Skills

Primary Skills

•              IBM DataStage (11.x and above) – Expert Level

•              IBM Cloud Pak for Data (CP4D)

•              ETL Design & Development

•              Data Warehousing Concepts

•              SQL (Advanced)

•              Data Modeling

•              Data Migration & Modernization

•              Performance Tuning and Optimization

•              Unix/Linux Shell Scripting

Preferred Skills

•              Experience migrating ETL workloads from IBM DataStage to Cloud Pak for Data.

•              Exposure to cloud-native architecture and enterprise modernization programs.

•              Experience with Autosys, Control-M, or enterprise scheduling tools.

•              Understanding of data governance, metadata management, and data lineage.

•              Knowledge of DevOps and automated deployment pipelines for ETL applications.

•              Exposure to Banking and Financial Services domain is highly preferred.

•              Experience working in large-scale enterprise data platforms handling high-volume data processing.