Data Warehouse Architect
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)
- 1+ years of exposure to Cloud Pak for data
- 5+ years of experience with Unix/Linux
- 3+ years of experience with Master Data Management
Desired Skills
- Previous Government experience
Additional Info
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra. We act responsibly, give back to the communities we serve and have a little fun along the way.
FastTek Global is a financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
- Medical and Dental (FastTek pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023!
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/
AI & Hiring Disclosure: We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight. All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits. If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out. Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring.
To learn more or exercise your rights, please contact us at info@fasttek.com.