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
- 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: