← Back to jobsJob ID col-cmwp6z9lq0722d8haws2tncee

DexianPosted 1 day ago

Data Engineering Lead – IBM DataStage / CP4DNew

Full-time
Hybrid
12+ years
Competitive
Posted 1 day ago

Dexian is recruiting for an unspecified client seeking a Data Transformation & Data Engineering Lead. The role designs, develops, implements, and supports enterprise data integration solutions using IBM DataStage and CP4D, with a focus on data quality, performance, scalability, and reliability.

Posted
1 day ago
Source
linkedin.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Lead the design, development, and implementation of enterprise-scale ETL and data integration solutions using IBM DataStage
  • Develop and maintain DataStage jobs and workflows within IBM Cloud Pak for Data (CP4D) 4.5
  • Design and implement complex data transformation, extraction, and loading processes
  • Develop and optimize advanced SQL queries, PL/SQL procedures, and database operations
  • Work with Oracle and IBM DB2 databases to support enterprise data integration initiatives
  • Design, develop, and support large-scale batch processing workflows
  • Perform performance tuning, troubleshooting, root-cause analysis, and production support for ETL processes
  • Develop data mapping specifications, transformation rules, and data validation processes
  • Work with Linux/Unix environments and shell scripting to automate and support data integration workflows
  • Collaborate with architects, business stakeholders, and engineering teams to understand requirements and deliver scalable solutions
  • Ensure data accuracy, integrity, and consistency across integrated systems

Qualifications

  • 12+ years of experience in Data Engineering, ETL Development, or Data Integration
  • Strong hands-on experience with IBM DataStage development
  • Hands-on experience with IBM Cloud Pak for Data (CP4D), specifically version 4.5
  • Advanced SQL and PL/SQL development experience
  • Strong working experience with Oracle and IBM DB2 databases
  • Experience designing and supporting enterprise data integration and transformation solutions
  • Strong understanding of data modeling, source-to-target mapping, and data validation
  • Experience with large-scale batch processing and ETL workflow management
  • Hands-on experience with performance tuning and troubleshooting complex ETL jobs
  • Experience working in Linux/Unix environments
  • Strong communication, problem-solving, and stakeholder management skills

Preferred

  • Experience with CockroachDB or MemSQL
  • Python scripting and automation experience
  • Exposure to Oracle GoldenGate, Change Data Capture (CDC), or similar data replication technologies
  • Change Data Capture (CDC)

Required skills

Data Integration and TransformationData ModelingData ValidationIBM DB2IBM DataStageLarge-Scale Batch ProcessingLinux/UnixOraclePL/SQLSQLSource-to-Target MappingStakeholder Management

Full job description

Dexian is recruiting for an unspecified client seeking a Data Transformation & Data Engineering Lead. The role designs, develops, implements, and supports enterprise data integration solutions using IBM DataStage and CP4D, with a focus on data quality, performance, scalability, and reliability.

Responsibilities

  • Lead the design, development, and implementation of enterprise-scale ETL and data integration solutions using IBM DataStage
  • Develop and maintain DataStage jobs and workflows within IBM Cloud Pak for Data (CP4D) 4.5
  • Design and implement complex data transformation, extraction, and loading processes
  • Develop and optimize advanced SQL queries, PL/SQL procedures, and database operations
  • Work with Oracle and IBM DB2 databases to support enterprise data integration initiatives
  • Design, develop, and support large-scale batch processing workflows
  • Perform performance tuning, troubleshooting, root-cause analysis, and production support for ETL processes
  • Develop data mapping specifications, transformation rules, and data validation processes
  • Work with Linux/Unix environments and shell scripting to automate and support data integration workflows
  • Collaborate with architects, business stakeholders, and engineering teams to understand requirements and deliver scalable solutions
  • Ensure data accuracy, integrity, and consistency across integrated systems

Preferred

  • Experience with CockroachDB or MemSQL
  • Python scripting and automation experience
  • Exposure to Oracle GoldenGate, Change Data Capture (CDC), or similar data replication technologies
  • CockroachDB
  • MemSQL
  • Python Scripting
  • Oracle GoldenGate
  • Change Data Capture (CDC)
  • Data Replication

Benefits

  • Hybrid – 3 days onsite; Addison, TX

Company

  • IT staffing and workforce solutions provider
  • Mclean, Virginia, USA
  • https://dexian.com/
  • Founded in 1994
  • 1001-5000 employees

Qualifications

  • 12+ years of experience in Data Engineering, ETL Development, or Data Integration
  • Strong hands-on experience with IBM DataStage development
  • Hands-on experience with IBM Cloud Pak for Data (CP4D), specifically version 4.5
  • Advanced SQL and PL/SQL development experience
  • Strong working experience with Oracle and IBM DB2 databases
  • Experience designing and supporting enterprise data integration and transformation solutions
  • Strong understanding of data modeling, source-to-target mapping, and data validation
  • Experience with large-scale batch processing and ETL workflow management
  • Hands-on experience with performance tuning and troubleshooting complex ETL jobs
  • Experience working in Linux/Unix environments
  • Strong communication, problem-solving, and stakeholder management skills
  • Experience with CockroachDB or MemSQL
  • Python scripting and automation experience
  • Exposure to Oracle GoldenGate, Change Data Capture (CDC), or similar data replication technologies
  • 12+ years of experience in Data Engineering, ETL Development, or Data Integration.

Required skills

  • Data Integration and Transformation, Data Modeling, Data Validation, IBM Cloud Pak for Data (CP4D) 4.5, IBM DB2, IBM DataStage, Large-Scale Batch Processing, Linux/Unix, Oracle, PL/SQL, SQL, Source-to-Target Mapping, Stakeholder Management

Preferred skills

  • Experience with CockroachDB or MemSQL, Python scripting and automation experience

Experience

  • 12+ years

Job details

Employment type

Full-time

Seniority level

12+ years

Date posted

Nov 20, 2026

Work mode

Hybrid

Job source

linkedin.com

Company

Dexian

Information Technology & AI

IT staffing and workforce solutions provider

See all 12 jobs from Dexian →
  • Mclean, Virginia, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 1994
  • dexian.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Addison

Dice

1d ago

New

Data Transformation Engineer

TemporaryHybridCharlotte, NCCompetitive

BCforward is seeking a Data Transformation Engineer to support enterprise-scale data integration and transformation work within SI&DS Operational Datastores and Real-time Data Replication.

Why similarSame roleData ModelingLinux/Unix

#Data Engineering Opportunities

1d ago

New

#Data Engineering Opportunities | Data Engineer, Senior & Lead

Full-timeOn-siteNew York, NY$140K – $190K/yr

Lakeview Loan Servicing, LLC is hiring Data Engineers at multiple levels to build and evolve the data foundation supporting analytics, reporting, AI, products, and operational decisions.

Why similarSame roleData ModelingSQL

Net2Source (N2S)

1d ago

New

Sr. Data Engineer

Full-timeOn-siteNew York, NYCompetitive

Net2Source is recruiting for a confidential client seeking a Senior Data Engineer. The role focuses on designing and supporting data pipelines and solutions, performing data analysis and ingestion, and implementing CI/CD pipelines for reliable data delivery.

Why similarSame roleOraclePL/SQL

Get new Data Engineer jobs in Addison by email

Create job alert

Data Engineering Lead – IBM DataStage / CP4D

Dexian · Competitive

Apply on company site