Data Warehouse Architect
Lansing, MI · On-site
The successful candidate will collaborate with architects, database administrators, analysts, and ... Build and maintain DataStage parallel jobs, server jobs, job sequences, and performance ...
Data Warehouse Architect
Lansing, MI · On-site
The successful candidate will collaborate with architects, database administrators, analysts, and ... Build and maintain DataStage parallel jobs, server jobs, job sequences, and performance ...
... Core Java, Datastage Admin, ETL Validation Technology - Data Management Shift Day 9AM-7PM Roles & Responsibilities • Sr. Test Analyst Bachelors in science , engineering or equivalent. • ...
... Core Java, Datastage Admin, ETL Validation Technology - Data Management Shift Day 9AM-7PM Roles & Responsibilities • Sr. Test Analyst Bachelors in science , engineering or equivalent. • ...
Datastage Administrator information
What are the key skills and qualifications needed to thrive in the Datastage administrator position, and why are they important?
A Datastage Administrator needs expertise in data integration, ETL processes, server administration, and a solid understanding of database systems, often supported by a degree in computer science or IT-related fields. Familiarity with IBM InfoSphere DataStage, scripting languages, and certifications such as IBM Certified Solution Developer are highly valued. Strong problem-solving, attention to detail, and effective communication skills enable administrators to manage complex data flows and collaborate with various teams. These competencies are crucial for ensuring reliable data operations, high system availability, and smooth coordination within broader IT environments.
What are the typical responsibilities of a Datastage administrator on a day-to-day basis?
A Datastage Administrator's daily tasks often include monitoring ETL job performance, troubleshooting job failures, maintaining DataStage project environments, and managing user permissions. They regularly collaborate with data engineers, developers, and business analysts to ensure data integration processes meet both technical and business requirements. Administrators may also be responsible for applying software patches, performing system upgrades, and optimizing job schedules for better performance. This multifaceted role supports the continuity and reliability of critical data movement across the organization, making it both challenging and rewarding for those who enjoy problem-solving and teamwork.
What is a Datastage administrator?
A Datastage Administrator is responsible for managing, configuring, and maintaining IBM DataStage environments. They oversee installation, upgrades, and performance tuning to ensure smooth ETL operations. Their role includes monitoring jobs, troubleshooting issues, managing user access, and optimizing system resources. They also collaborate with developers and database administrators to maintain data workflows and ensure data integrity.
What are popular job titles related to Datastage Administrator jobs in Michigan? For Datastage Administrator jobs in Michigan, the most frequently searched job titles are:
What job categories do people searching Datastage Administrator jobs in Michigan look for? The top searched job categories for Datastage Administrator jobs in Michigan are:
Job description
Data Warehouse Architect 5
Location: Lansing, MI (Hybrid)
Duration: 12 Months
Job Type: Contract
We are seeking a highly experienced Data Warehouse Architect / Senior ETL Developer to support large-scale enterprise data modernization and analytics initiatives. The ideal candidate will possess extensive expertise in IBM DataStage, IBM Cloud Pak for Data (CP4D), Teradata 20, and enterprise ETL development. This role focuses on modernizing legacy data integration solutions, developing scalable ETL pipelines, optimizing enterprise data processing, and supporting data governance initiatives within a complex enterprise environment.
The successful candidate will collaborate with architects, database administrators, analysts, and business stakeholders to deliver high-quality data integration solutions while driving continuous improvement and modernization efforts.
Key Responsibilities- Design, develop, enhance, and optimize enterprise ETL solutions using IBM DataStage.
- Build and maintain DataStage parallel jobs, server jobs, job sequences, and performance optimization solutions.
- Support migration of legacy DataStage workloads to IBM Cloud Pak for Data (CP4D), including modernization, refactoring, testing, and validation.
- Develop and optimize complex SQL and BTEQ scripts for Teradata 20 supporting enterprise reporting and analytics.
- Create automation solutions using Python, Shell scripting, and XML for ETL workflows and data processing.
- Implement Master Data Management (MDM), data quality, and data governance best practices.
- Collaborate with architects, DBAs, analysts, business users, and technical teams to deliver scalable data integration solutions.
- Perform ETL troubleshooting, root cause analysis, performance tuning, and production support.
- Participate in Agile ceremonies, sprint planning, documentation, testing, and continuous improvement initiatives.
- Ensure data integrity, scalability, reliability, and performance across enterprise data platforms.
- 5+ years of experience developing enterprise ETL solutions using IBM DataStage.
- 1+ year of hands-on experience with IBM Cloud Pak for Data (CP4D).
- 3+ years of experience with Teradata 20, including SQL, BTEQ, and performance optimization.
- 5+ years of Unix/Linux scripting and system administration experience.
- 3+ years of advanced SQL development supporting ETL and enterprise analytics.
- Experience developing automation solutions using Python.
- Strong understanding of Master Data Management (MDM), data quality, and data governance principles.
- Proven ability to translate business and technical requirements into scalable ETL solutions.
- Experience working within large enterprise data environments supporting multiple data sources.
- Experience supporting public health, healthcare, or state government organizations.
- Prior experience supporting State of Michigan projects or other public-sector environments.
- Experience with IBM Knowledge Catalog, metadata management, and data lineage.
- Exposure to IBM Manta for lineage and impact analysis.
- Familiarity with OpenShift, Kubernetes, or cloud-native platforms.
- Experience with CI/CD pipelines, version control systems, and Agile development methodologies.
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
- IBM DataStage
- IBM Cloud Pak for Data (CP4D)
- Teradata 20
- SQL
- BTEQ
- Python
- Unix/Linux
- Shell Scripting
- XML
- ETL Development
- Data Warehouse
- Master Data Management (MDM)
- Data Governance
- Data Quality
- IBM Knowledge Catalog
- IBM Manta
- OpenShift
- Kubernetes
- CI/CD
- Agile
About SystemDomain
Sourced by ZipRecruiter
Company size
11 - 50 Employees
Headquarters location
Warrenville, IL, US
Year founded
1999