Data Warehouse Architect

Company : Zenfreed, Llc

Job Type : Full Time

Lansing, United States

Job Description - Data Warehouse Architect

The ETL Developer is responsible for designing, developing, and maintaining high -quality data integration solutions using IBM DataStage and related technologies.

This role supports both on -premise 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

Job Duties

Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
Support the migration of on -premise 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 root -cause analysis, recommend improvements, and ensure adherence to data standards and security policies.

Requirements

5+ years:

Experience ETL (IBM DataStage)
Experience with Unix/Linux

3+ years:

Experience with Master Data Management

1+ years:

Exposure to Cloud Pak for data

Desired Skills

Previous Government experience

Minimum Education

None

Location

Local candidates ONLY candidates must be located in Michigan at time of submission
Position
is a hybrid schedule with NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Monday/Tuesday)
Working hours
Monday -Friday, approximately 8:00 a.m. to
5:00 p.m.

Additional
Requirements

Must be authorized to
work in the United States; We are unable to offer
sponsorships at this time
Must undergo a background check
and drug screening for employment.

Employment
Terms

This is a W2 position
40 hrs per week
HYBRID schedule - NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Monday/Tuesday)

About
Zenfreed

At
Zenfreed, we are more than an IT company. We bridge the
gap between people wanting to do the work they were meant to do
and organizations needing the right talent.

We are dedicated to building a diverse,
inclusive and authentic workplace, so if you’re excited
about this role but your past experience doesn’t align
perfectly with every qualification in the job description,
we encourage you to apply anyway. You may be just the right
candidate for this or other roles.

Benefits

We understand a comprehensive benefits package is crucial to
employment satisfaction. We offer medical, dental and vision coverage
options for all employees.

Email address

Why are you reporting this job?

I think it’s a discriminatory or offensive

I think it’s fraudulent or a scam

I think it’s trying to sell something unrelated to the job / it’s asking for money

I think it contains incorrect or broken information

Other

All Job Ads are subject to GrabJobs’s Terms of Service. We allow users to flag postings that may be in violation of those terms. Job Ads may also be flagged by GrabJobs moderation team. However, no moderation system is perfect, and flagging a posting does not ensure that it will be removed.

Setup your job alert:

Frequency

Email

By activating job alerts, I agree to GrabJobs Terms & Privacy Policy. I can unsubscribe to job alerts anytime. Skip

GrabJobs is the no1 job portal in the US, connecting you to thousands of jobs fast! Find the best jobs in the US, apply in 1 click and get a job today!