Sr. ETL Engineer

Sacramento, California, United States

SNAPSHOT

  • Contract
  • 1
  • Never
  • 7-10 years
  • Any work permit considered

Job Description

ETL Software Engineer - Sacramento, CA

Experience:

  • 8+ years of experience writing design/mapping specifications for ETL development using IBM
  • InfoSphere DataStage to design ETL jobs
  • Experience in using XML Stage in InfoSphere DataStage
  • Experience reading, understanding and importing COBOL copybooks into InfoSphere DataStage,
  • SQL skills
  • Knowledge of Business Intelligence (BI) concepts and experience in designing BI reports
  • Bachelors Degree in Engineering, Computer Science, Mathematics or a related field required
  • Ability to pass drug test
  • Ability to work on site M-F
  • Ability to work some weekends & Evenings doing ETL work (batch data)

Qualifications / Requirements:

  •  8+ years of experience writing design/mapping specifications for ETL development using IBM
  • InfoSphere DataStage to design ETL jobs
  •  Experience reading, understanding and importing COBOL copybooks into InfoSphere DataStage
  • 5+ years’ experience in using SQL
  • Experience in using XML Stage in InfoSphere DataStage.
  • Knowledge of Business Intelligence (BI) concepts and experience in designing BI reports
  • Bachelors Degree in Engineering, Computer Science, Mathematics or a related field required

Assets Desired:

  • Experience in Healthcare with Medicaid or Public Health
  • Control M experience
  • SAS experience
  • Knowledge of 837 and NCPDP HIPAA Transactions
  • Experience using ERwin to design data models

Position Description:

  • Responsible for the analysis of customer requirements, improving performance on existing scripts
    /process/procedures, and documenting detailed user requirements and program functions.
  • Determine feasibility of a requested program change/functionality and determine the impact of
    modification to the software solution.
  •  Monitor 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.
  •  Uses ERwin to design a data model for assigned projects.
  • Analyze source systems to determine required transformations.
  •  Writes the design and mapping specifications for ETL development.
  •  Identify methods of improving performance in ETL design and development.
  •  Analyze, identify, and recommend ways to improve the quality of data from the sources using IBM
    InfoSphere ProfileStage.
  •  Read, understand and import COBOL copybooks into InfoSphere DataStage.
  •  Experience in using XML stage
  •  Utilize knowledge of Business Intelligence (BI) concepts and experience in designing BI reports.
  •  Job also includes working with the Health Care Quality Assurance specialist in evaluating data
    quality and making recommendations to improve data quality.
    Some evening and weekend work required.