Search Jobs | Dice.com

Job Details

Skills

Agile
Cloud Computing
IBM InfoSphere DataStage
IBM SmartCloud
Master Data Management
Extract, Transform, Load
Data Quality
Data Warehouse
Datastage
Python
Scripting
SQL
Data Extraction

Summary

Job Description

We are seeking an experienced ETL Data Warehouse Architect with strong expertise in IBM DataStage and IBM Cloud Pak for Data (CP4D) to support a large-scale enterprise data modernization initiative for the State of Michigan. The ideal candidate will have extensive experience designing, developing, and optimizing ETL solutions while supporting the migration of on-premises DataStage workloads to Cloud Pak for Data.

This role requires strong hands-on experience with ETL development, Linux/Unix, SQL, Python, XML, and Master Data Management (MDM) in an Agile environment.

Key Responsibilities

Design, develop, enhance, and maintain ETL pipelines using IBM DataStage.
Build and optimize parallel jobs, server jobs, job sequences, and reusable ETL components.
Support migration of on-premise IBM DataStage jobs to IBM Cloud Pak for Data (CP4D).
Refactor existing ETL code, perform testing, validation, and deployment activities.
Develop automation using Python, XML, and shell scripting.
Work in Linux/Unix environments for scripting, process monitoring, troubleshooting, and file management.
Create and optimize complex SQL queries for data extraction, transformation, and validation.
Apply Master Data Management (MDM) principles to improve data quality and governance.
Collaborate with architects, DBAs, business analysts, and cross-functional teams to deliver scalable data solutions.
Troubleshoot ETL issues, perform root cause analysis, and recommend performance improvements.
Participate in Agile ceremonies, sprint planning, documentation, and production support.

Required Skills

5+ years of hands-on experience with IBM DataStage ETL development.
1+ year of experience with IBM Cloud Pak for Data (CP4D).
5+ years of Linux/Unix experience.
3+ years of Master Data Management (MDM) experience.
Strong SQL development and performance tuning skills.
Experience with Python, XML, and Shell Scripting.
Experience supporting enterprise data warehouse environments.
Strong troubleshooting, analytical, and communication skills.
Experience working in Agile/Scrum environments.

Preferred Qualifications

Experience with enterprise data warehouse modernization initiatives.
Knowledge of ETL migration best practices.
Experience with performance tuning and optimization of DataStage jobs.
Government or public sector experience is a plus.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91162472
Position Id: 9025111
Posted 9 hours ago

Teradata Etl Data Architect

Hybrid in Michigan Center, Michigan

•

Today

Teradata ETL Data ArchitectIntroduction:The Teradata ETL Data Architect will play a crucial role in maintaining and optimizing the enterprise data warehouse built on the Teradata ecosystem. They will be responsible for overseeing various aspects of the data warehouse architecture and ensuring its smooth operation. Responsibilities:Manage Teradata database including upgrades, provisioning, software maintenance, and scriptingMonitor the health of the Teradata ecosystem and manage Teradata nodesAdm

Easy Apply

Third Party, Contract

Depends on Experience

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

ETL Datawarehouse with IBM Datastage

Skills

Summary

Job Description

Key Responsibilities

Required Skills

Preferred Qualifications

Dice Job Match Score™

Sravan Kumar

Similar Jobs

ETL Datawarehouse with IBM Datastage

Dia Software Solutions

Job Details

Skills

Summary

Job Description

Key Responsibilities

Required Skills

Preferred Qualifications

Dice Job Match Score™

Sravan Kumar

Similar Jobs