Find Jobs
DataStage Developer
Sacramento, California  |  Remote, Onsite
Contract to Hire Position
It appears that you have already applied to this job.
Applied on October 24, 2021
Job Id #49367 Posted July 27, 2021

Projects the candidate will be working on:

  • This position is for a Medi-Cal Data Warehouse project for State of California in Sacramento.
  • The ETL Developer position is for the ETL Operations Team which is primarily responsible for the periodic data releases from multiple source feeds, production maintenance, operations, data quality, system changes and fixes.


  • Level of expertise in top 3 skills outlined above and ability to quickly learn project specific knowledge.


  • Responsible for analysis of source systems to determine required transformations.
  • Writes the design and mapping specifications for ETL development.
  • Identifies methods of improving performance in ETL design and development.
  • Analyses customer requirements, improving performance on existing scripts /process/procedures, and document detailed user requirements and program functions.
  • Monitors database performance, support application users, determine cost of database changes, and train team members on applications.
  • Coordinates the work of others to develop, test, install, and modify programs and establish physical database parameters.


  • Bachelors Degree in Computer Science, Information technology (or related fields) from an accredited college or university or equivalent work experience.
  • Strong ETL experience 5-6 years using IBM Datastage V7 or higher
  • Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD
  • Strong SQL writing ability and data analysis skills
  • Unix commands and shell scripting
  • Good understanding of IT fundamentals, architecture, and the system development life cycle.
  • Ability to reason logically and creatively, and use a variety of analytical and research techniques to solve complex problems.
  • Communicate effectively both verbally and in writing with a variety of audience types

Top Requirements:

  • 1. Strong ETL experience using IBM Datastage V7 or higher - 5+ years
  • 2. Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD - 2+ years
  • 3. Strong SQL writing ability and data analysis skills - 2+ years

Team and Team size:

  • ETL Team has 6 ETL developers (DataStage, Teradata, SQL programming), 2 BusinessObjects (BusinessObjects) and Data Dictionary Librarian (Erwin, SAS) analysts, 2 QA testers, 6 Source Data Feeds developers (Mainframe Cobol, SQL), 1 ETL Lead(DataStage, Teradata, SQL programming), 1 Manager.

Interview Process:

  • a. How many rounds? 2-3
  • b. Video vs. phone? Video
  • c. How technical will the interviews be? Very technical, general and scenario based questions.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact

All applicants applying must be legally authorized to work in the country of employment.


What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.


You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.