Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Oracle Data Integrator

P

Pomeroy IT Solutions

Oracle Data Integrator

San Francisco, CA
Full Time
Paid
Similar Jobs
  • Responsibilities

    Job Description

     

    Pomeroy is currently recruiting for a Oracle Data Integrator in San Francisco, CA. This role is a 6 + month contract with our local client. The main responsibility of this role is to lead the design and development of ELT and Data Integration routines using Oracle BI Cloud Connector (BICC) and Oracle Data Integrator Market Place (ODI). 

     

    Full life cycle experience (requirements gathering through production deployment) in all aspects of modern data warehousing, ETL/ EL-T, and data modeling

    • Manage and administer Extract, Transform, and Load (ETL)/ EL-T processes to ingest various data sources into a centralized data lake. 
    • Apply advanced comprehension of SQL to write, optimize, and debug database queries, procedures, and functions. Use relational database concepts and theories to cleanse data and identify anomalies which may lead to inaccurate reporting.
    • Profile, clean, and normalize large data sets for ingestion into a data lake using tools and programming languages, using Oracle Data Integrator (ODI12c), SQL and PL/SQL.
    • Design and develop or modify ELT Load Plans that load data for the Oracle ADW (Oracle Autonomous data warehouse) using Oracle ODI 12c and PL/SQL

    · Provide ELT performance tuning

    • Develop data strategies to successfully oversee data flow from ingestion to repository storage and then ultimately to dashboards, interfaces, tools, and other stakeholder databases.

     

    MUST HAVE:

    • 5+ years of experience with theoretical and practical application, best practices, methods and techniques pertaining to building Enterprise Data Warehouses, Transactional Data Marts, Data Analysis, BI, and ETL/ EL-T techniques.
    • 3+ years of experience with an ETL or ELT tool for data extraction, transformation and loading using Oracle Data Integrator (ODI).
    • 5 years of experience in designing and implementing transactional and analytical data marts or data warehouse.
    • 5 years of experience with writing and debugging complex SQL queries.
    • 3 years of experience with converting data from and to XML, CSV, and JSON file formats
    • Experience ingesting data from cloud data sources like Oracle Fusion SaaS, Oracle EPM cloud, Workday, Concur, Salesforce etc.
    • Experience working with Oracle BICC, Oracle ADW and Oracle BIP
    • 2+ Years of experience working with cloud DWH like Oracle ADW, Redshift, Snowflake
    • Well versed with dimensional data modeling and the construction of ETL or EL-T routines in a data warehouse environment.
    • Data warehousing and data modeling experience – cloud and on-premise – OLAP, Star/Snow Flake Schemas, Dimensional Data Modeling, Fact & Dimension tables, Physical and Logical Data Modeling
    • 3 years of experience managing complex data environments in a lead role architecting, designing and implementing solutions based on business requirements.

     

    GOOD TO HAVE:

    • Experience with one or more of the following BI tools: Tableau, Oracle BI, Oracle Analytics, Power BI
    • Experience with Cloud Integration Platform (iPaaS) is a big plus
    • Strong Project Management skills and a functional knowledge of common business concepts (Finance/Sales/Supply Chain, Etc).

     

     

    For over 35 years, Pomeroy has enabled technology that enhances and empowers people in the workplace.

    Today we partner with our clients to help them transform from a “one size fits all” delivery model to a personalized human experience that is a competitive differentiator and the key to delivering digital transformation and better business outcomes.

    It’s all about delivering an exceptional experience, one that is simple, intuitive and secure – anytime, anyplace and from any device. Our workplace is no longer a physical location or workstation, rather it’s the place where a person can work at any given time with full capacity to do their job productively and effectively.

    We deliver that experience by connecting the dots between people and their applications, across a network that is intuitive and automated to where the applications live, today that is in a hybrid IT environment, on premise and in the cloud, with security an integral part of everything we do.

    Company Description

    Pomeroy partners with our clients to deliver integrated solutions that enable the digital workplace. We understand the interdependence between today’s end users, the networks they rely on to stay connected and productive, and the critical data they need to drive positive business outcomes. Our holistic solutions create a digital workplace that is intelligent, highly available, fully enabled, and fully connected. One that is consumable by our clients in ways that best meet their specific business demands. One that delivers an intelligent, always-on user experience and helps organizations become digital disruptors in their markets.