Systems Developer

Job Title: Systems Developer Location: 52 Washington Rensselaer, NY 12144 (HYBRID) Duration: 24 Months

• 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