Jobs
>
Pune

    ODI Lead - Pune, India - Growel Softech Pvt. Ltd.

    Growel Softech Pvt. Ltd.
    Growel Softech Pvt. Ltd. Pune, India

    Found in: Talent IN 2A C2 - 4 days ago

    Default job background
    permanent Technology / Internet
    Description

    Mandatory Skill combination:
    ODI Lead, Source Systems(flat files (csv and json), Oracle DB, etc.),Snowflake, Large Data

    IT Experience: 6 to 7 Years

    • Technical experience with the development of ETL processes in the Data Warehouse Oracle environment
    • Experience with Informatica Power Center, Power Exchange or Oracle ODI.


    • Expert in

    • SQL and PL/SQL.
    • Performs SQL queries design, code, test, and aggregate the results to create useful information
    • Responsible for building online analytical processes (OLAP) using relational and multidimensional databases
    • Knowledge of Business Intelligence
    • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI)
    • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis
    • Advanced SQL statements to interact with a database
    • Experience in profiling source and raw data
    • Define transformation logic of data from business requirements
    • Experience in Python
    • Knowledge of logical and physical database modeling concepts and techniques
    • Understand normalized and starschema physical models and logical modeling concepts
    • Works on APIs and frameworks to expose data for visualization and study
    )
  • Jade Global

    PBCS: Techno/Functional consultant

    Found in: Talent IN 2A C2 - 3 days ago

    Jade Global Pune, India

    PBCS: Techno/Functional consultant · Min 7 years' experience in Designer/Developer role in Hyperion Planning or Oracle PBCS projects/environments; · Business Analysis experience: Strong experience in requirements gathering and management, translation to the technical design and s ...