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 building database schemas, tables, views, indexes,
and stored procedures