Data Warehouse Architect 3 #161004

Data Warehouse Architect 3
Lansing Michigan (Need Only Locals)
1 Year Contract on W2 (NO C2C)

Hybrid Job (Will need to be onsite from day 1 two days a week. ((Monday/Tuesday)

The ETL Developer is responsible for designing developing and
maintaining highquality data integration solutions using IBM DataStage
and related technologies. This role supports both onpremise and cloud
environments contributes to enterprise data modernization efforts and
plays a key role in migrating DataStage workloads to IBM Cloud Pak for
Data (CP4D). The developer will collaborate with technical and business
teams to deliver reliable scalable and secure data pipelines aligned
with organizational objectives.
Responsibilities and Technical Skills
- Develop enhance and optimize ETL pipelines using IBM DataStage
including parallel and server jobs job sequencing and performance
tuning.
- Support the migration of onpremise DataStage jobs to IBM Cloud Pak
for Data (CP4D) including code refactoring testing validation
and workflow modernization.
- Use Python and XML to automate processes perform data
transformations and integrate automation into ETL workflows.
- Work extensively in Linux/Unix environments to write shell scripts
manage file systems monitor processes and troubleshoot runtime
issues.
- Apply Master Data Management (MDM) principles to ensure data
quality governance and consistency across enterprise systems.
- Develop complex SQL queries for data extraction transformation
validation and performance improvement across relational database
platforms.
- Work within Agile teams to support sprint activities deployments
documentation and continuous improvement practices.
- Collaborate with data architects analysts DBAs and business users
to ensure successful and accurate delivery of data solutions.
- Troubleshoot ETL issues perform rootcause analysis recommend
improvements and ensure adherence to data standards and security
policies.

Required Skills
- 5 years of experience ETL (IBM DataStage) - Required
- 1 years of exposure to Cloud Pak for data - Required
- 5 years of experience with Unix/Linux
- 3 years of experience with Master Data Management

Desired Skills

- Previous Government experience

Required Skills:

PYTHONMASTER DATA MANAGEMENTUNIXXMLLINUXSHELL SCRIPTS