Role: ODI Developer
Location: Tampa/St. Petersburg
Duration: 3+ months
(all of our contractors get extended each quarter; average contract duration is 18+ months)
MOI: Phone and Skype or In-Person
Visa: H4-EAD, GC-EAD, GC, USC
(Target start date: 4/1)
MUST HAVE: SQL,Analytical Skills,Requirements Analysis,Data Analytics, Data Mining
Short Role Description:
- Source system data analysis and profiling
- Data mapping
- Conceptual and physical data modeling
- ETL program design
- ETL program development and unit testing
- ETL program deployment support
- Knowledge sharing with client and CCG resources
- Technical documentation as directed by CCG and the client
Extended Description:
As an ODI Developer, the consultant will be responsible for the following duties:
- Collaborate with project managers, business users, analysts and developers in conceptualizing and development of new software programs and applications.
- Design, develop, document, analyze, test and modify Oracle Database and ETL/ELT Data Warehouse computer applications.
- Assist in defining software development project plans, including scoping, scheduling and implementation using Microsoft Office Suite.
- Write programming scripts to enhance functionality and performance of organization applications as necessary using ODI, SQL, PL/SQL.
- Execute and monitor software performance tests on new and existing programs for the purpose of correcting errors, isolating areas for improvement and general debugging.
- Administer critical analysis of test results and deliver solutions to problem areas.
- Research, evaluate and recommend solutions and appropriate technology to meet user's needs.
- Arrange project requirements in programming sequence by analyzing requirements, preparing a workflow chart and diagram using knowledge of computer capabilities, subject matter, programming language and logic.
- Monitor tickets, critical jobs, alerts and ODI (Oracle Data Integrator) jobs. Troubleshoot the problems and failures, and work to resolve issues.
- Perform data analysis and provide data fixes to remove inconsistent data from the systems.
- Deliver solid scalable, robust BI reporting analytic solutions to users.
•
Last updated on Mar 23, 2020