Location: MUST BE Local to the Sacramento, CA region and be available to work onsite, although the position is mostly remote work currently. Office hours are between the hours of 8am and 5pm Monday through Friday.
Compensation: DOE and compensation package of benefits. Range of W2 Salaried $100K - 110K, W2 hourly $55-65/hr. (Open to negotiate based on experience)
Pre-employment Requirements: Professional References, I-9 Employment eligibility, Successful criminal background and drug screen. Stanfield Systems does not sponsor Visa holding candidates.
If you meet and exceed the following skills sets, please respond with your full contact information, resume, date available and desired compensation target amount and arrangement and Apply at on the Career Page, Job ID 4327 or email your resume and contact information to with “IBM DataStage Data Engineer for 4327” in the subject line
Responsibilities:
· Design, develop, and maintain ETL pipelines using IBM DataStage
· Build and optimize parallel jobs, server jobs, and sequences
· Work with source-to-target mappings, data transformations, and business rules
· Collaborate with Tech leads and analysts to understand data requirements
· Perform unit testing, debugging, and performance tuning of DataStage jobs
· Support data migration, integration, and warehouse loading activities
· Manage job scheduling and monitoring via DataStage Director/Control Center
Required Skills:
· Strong hands-on experience with IBM DataStage (Parallel Extender/PX)
· Proficiency in complex SQL and data transformation logic
· Experience with data warehousing concepts (Star/Snowflake schema, SCD types)
· Knowledge of Unix/Linux shell scripting
· Familiarity with job scheduling tools (Control-M, AutoSys)
· Experience with QualityStage
Teradata Skills (Additional):
· Working knowledge of Teradata SQL and utilities (BTEQ, FastLoad, MultiLoad, TPT)
· Experience loading/extracting data from Teradata using DataStage connectors
· Basic understanding of Teradata architecture and performance tuning
Good to Have:
· Experience with Mainframes/ COBOL, JCL
· Knowledge of metadata management and data lineage tools
· Medicaid knowledge
Questions: Answers to be submitted with application
How many years of experience working on State of California government projects?
How many State of California government proposals have you been submitted to in the past 5 years roughly?
What are the largest data integration or ETL projects you have worked on in the past five years involving IBM DataStage (Parallel Extender/PX)? Please describe the project size, duration, your role, and your key responsibilities, including DataStage PX development, complex SQL and data transformation logic, data warehousing concepts (Star/Snowflake schema, SCD types), Unix/Linux shell scripting, job scheduling tools such as Control-M or AutoSys, and any experience with QualityStage.
Stanfield Systems Inc. is an equal opportunity employer and does not discriminate against race, color, sex, national origin, religion, age, equal pay, disability or genetic information. Some positions posted by our company will require an individual to pass a thorough criminal background check, drug screen and may require the ability to obtain various national security clearance levels. Demonstrates proficiency with on-line search engines and/or sophisticated searching strategies. More desirable if familiar with searching job boards, for sourcing & recruiting candidates and posting positions/information to the web.
Never miss an opportunity! Create an alert based on the job you applied for.
