ETL Developer/ Warehouse Data Engineer

Position: ETL Developer/ Warehouse Data Engineer
Location : Albany, New York, xxxxxxxxxxxxxxxHybrid
Duration: 24+ Month

Experiences Required:

·        Experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
·        Experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
·        Experience working in an Oracle Data Warehouse performing development work using PL/SQL
·        Experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
·        Experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
·        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).
·        Experience working in UNIX or LINUX environment developing Unix Shell Scripting and SFTP protocols
·        Experience in building database schemas, tables, views, indexes, and stored procedures