ETL Developer

Propertyvalue Quantum Technologies Llc

United States

24 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$166,400.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Agile Methodology CA Workload Automation Ae Cloud Computing Cloud Engineering Databases Data Governance Data Integration Extract Transform Load (ETL) Data Mapping Data Transformation Data Migration Data Warehousing

+15 more

IBM InfoSphere DataStage DevOps IBM Cloud Computing Meta-Data Management Performance Tuning Scrum Methodology Cloud Services Shell Script SQL Databases Data Streaming Data Processing Data Lineage Deployment Automation Data Pipelines Control M

Job description

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., * 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.

Requirements

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.