Sign upLog in

Data Warehouse Architect 3

Sunrise Systems Inc

Lansing, MI

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Architectural Analysis, Automation, Cloud Computing, Continuous Improvement, Data Analysis, Data Management, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, File Management, File Systems, Government, IBM WebSphere DataStage, Identify Issues, Information/Data Security (InfoSec), Linux Operating System, Maintain Compliance, Master Data Management (MDM), Multiplatform/Cross-Platform, Performance Management, Performance Tuning/Optimization, Python Programming/Scripting Language, Quality Management, Refactoring, Relational Databases (RDBMS), Root Cause Analysis, SQL (Structured Query Language), Systems Administration/Management, Unix Operating Systems, Unix Shell Programming, Validation Testing, XML (EXtensible Markup Language)
LOCATION
Lansing, MI
POSTED
1 day ago
Job title: Data Warehouse Architect 3
Job ID: 26-03283
Location: Lansing, MI, 48933
Duration: 06 months of contract
 
Job Description:
 
Top Skills & Years of Experience:
 
  • 5+ years of experience with 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
 
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.
 
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 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.
 
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
 
Contact:
Vinay Kumar:  Vinay.c@sunrisesys.com Direct: (732) 837-0448 | URL: Sunrise Systems Inc.

About the Company

S

Sunrise Systems Inc

Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.

We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.

Our collective business experience spans over two and a half decades and ranges from:

  • Business, management, and technical fields
  • Information technology consulting and software solutions.
  • Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
  • Motivating technology staff and establishing partnerships with Fortune 500 companies

Sunrise Systems has a vast range of competence in:

  • Design, development, and support of cloud-based solutions from simple to highly complexed
  • Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
  • Data processing and data migration
  • Application re-engineering and platform migration
  • Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.
COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1990
WEBSITE
http://www.sunrisesys.com/

Resume Resources

Free Resume TemplatesFree Resume Builder