Senior ETL Developer - OHIO Only

TP Resources - Columbus, OH

Contract

Job Description

Great consulting opportunity with the State of Ohio ! Candidates within 100 miles of Columbus, Ohio preferred. We also offer 1099 rates for this position. If this opportunity is not right for you , visit TPROhio.com for more consulting opportunities.

***Must be authorized to work in the United States. We are not able to sponsor H1-B visas.

***No Agencies or recruiters.

***Candidate will need to be available for face to face interview with 48 hours notice

Key Role Responsibilities

  • Participates in multi-organizational, multi-disciplinary teams to determine, articulate, & codify business requirements; models/designs and is responsible for Extract, Transformation & Loading (ETL) design and development;
  • Design and development of ETLs in data warehouse (with Informatica/Oracle) environment;
  • Conducts facilitated discussions with customers to review current & gather additional business requirements; analyzes & writes business requirements, scope documents, program specifications & system documentation;
  • Designs test procedures & tests system for validity & reliability; ensures logical & systematic conversion of customer requirements into total systems solutions that acknowledge scope, schedule & cost constraints; provides data analysis, data architecture & design assistance to functional/systems analysts, application developers & users;
  • Creates and maintains logical & physical data models & data dictionaries; writes system requirements, general & detailed design documents; participates in management short & long-term planning & assists in agency-wide policy & program development as impacts automated systems.

Candidate responding must demonstrate the following experience:

  • A minimum of two (2) recent years of experience in ETL development (Informatica) and system analysis;
  • Two (2) years of Dimensional Data Modeling and Data Profiling experience for data warehouse development;
  • Experience integrating disparate systems of record into conformed dimensions and fact tables;
  • Excellent documentation and communication skills;
  • Strong performance tuning skills with ETLs.

Job Type: Contract

Salary: $72.00 to $90.00 /hour

Experience:

  • tuning skills with ETLs: 3 years (Required)
  • in ETL development (Informatica) and system analysis: 2 years (Required)
  • integrating disparate systems of record into conformed dimen: 3 years (Required)
  • Informatica/Oracle: 2 years (Required)
  • Dimensional Data Modeling and Data Profiling: 2 years (Required)

Full Time Opportunity:

  • Yes