What are the responsibilities and job description for the `ON-SITE - Senior Oracle Data Integration Engineer - HBITS-06-13860 position at GreyCell Labs, Inc?
Job Details
Job Title: ON-SITE - Senior Oracle Data Integration Engineer
Job ID: HBITS-06-13860
Location: Albany NY 12210
Duration: Long-term
Job Description:
- 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
- 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment.
- 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL.
- 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
- 84 months experience developing and testing maps, performing source-to target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
- 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
- 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols.
- 84 months experience in build database schemas, tables, views, indexes, and stored procedures.
- Bachelor s Degree
_________________________________________________________
Agency: Office of Children & Family Services
Project: OCFS Data Warehouse
Detailed Job Description: This 14-month position for a Systems Developer with experience working on a Oracle Data Warehouse/Business Intelligence team is needed for the data quality and data collection requirements for state and federal reporting on the Comprehensive Child Welfare Information System (CCWIS). The developer will design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
Max: SEVEN 32.800.2838
Kevin:- SEVEN 32.800.2373
