Systems - Albany, United States - Five Cubes, Inc.

    Five Cubes, Inc.
    Five Cubes, Inc. Albany, United States

    3 weeks ago

    Default job background
    Description
    Job Title: Systems Developer_Expert-13178
    Location: Albany, NY
    Duration: 24+ Months
    Direct Client

    Job Description:
    • Work in coordination with a team of developers to expand the current Data Warehouse.
    • Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
    • Work with Business Analyst & customers on analysis and logical design for mappings and ETL. Perform unit testing and correct all identified bugs.
    • Perform complex PL/SQL coding in a Data Warehouse environment.
    • Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements
    • Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI The individual in this position will work under the direction of a Technical Lead & Project Manager
    Required Skills:
    • 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
    Benefits:
    Rate: $50.39 to $60.39/Hr DOE
    Onsite Role.
    Subcontracting Allowed or C2C Allowed.
    Any Visa.