ETL Developer with IBM DataStage (Fulltime - Seattle, WA)

K&K Global Talent Solutions Inc.

Seattle, WA

JOB DETAILS
SKILLS
Agile Programming Methodologies, Architectural Analysis, Automation, Business Analysis, CA Workload Automation AE (AutoSys Edition), Cloud Architecture, Cloud Computing, Data Management, Data Mapping, Data Processing, Data Quality, Database Extract Transform and Load (ETL), Design Document, Enterprise Protection, IBM WebSphere DataStage, Linux Operating System, Maintain Compliance, Metadata, Performance Tuning/Optimization, Problem Solving Skills, Quality Assurance, Quality Metrics, Root Cause Analysis, Scalable System Development, Security Compliance, Sprint Planning, Standup Meetings, Technical Writing, Technical/Engineering Design, Test Plan/Schedule, Unix Shell Programming
LOCATION
Seattle, WA
POSTED
9 days ago

Job Title - ETL Developer
Experience - 8+ years
Location - Seattle, WA
Hire Type - Fulltime

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 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 the Banking and Financial Services domain is highly preferred.
  • Experience working in large-scale enterprise data platforms handling high-volume data processing.
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.

About the Company

K

K&K Global Talent Solutions Inc.