Tek08055

ODI Developer - 5 + Year


B.com

Highlights

  • Having 5 years of experience in ODI Implementation and support.

  • Strong Team player, Core Contributor and Quick self-Learner.

  • Hard working and aggressive in acquiring new skills ability to excel under pressure and self-motivated, good problem-solving skills.

  • Strong levels communication and interpersonal skills to maintain effective work relationships with all of personnel.

  • Received Appreciation mails from the client side for handling critical tasks in time without errors.



ODI:




  • Good understanding in ELT Design development ODI 11G &12 cloud.

  • Ability to setting up the connection parameters in the Topology Manager.

  • Experienceon Knowledge modules like LKM, IKM, CKM, RKM and JKM.

  • Good Understanding on ODI Navigators like Designer,Topology,Operator, and Security  Navigator.

  • Understanding of the architecture of ODI.

  • Resolving Upgrade issues to make sure daily loads run effectively.

  • Good knowledge SDLC implementations.

  • Good Knowledge about ODI metadata navigator and ODI Console.

  • Ability with loading metadata and data from Different Source Systems and into target Systems (Oracle, File, XML, SQL server).

  • Ability with Exporting a Flat file source system to different target systems.

  • Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.

  • Extensively worked with large Databases in Development, Testing and Production environments.

  • Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing.

  • Expertise in creating stored procedures, functions, packages, triggers, collections and bulk collections using SQL.

  • Experience with Oracle DML and DDL scripting.

  • Experience in planning space allocation, partitioning, creating and managing table spaces.

  • Experience with Application development in an Oracle Environment, Data Modelling / Relational Database Design.

  • Strong Knowledge on SQL .


Skills
Primary Skills
  • Data Integration
  • ETL
  • ODI tools

Secondary Skills
  • PL/SQL
  • SQL
Other Skills
  • Operating System                                 :           Windows /Linux.
  • ETL Tools                                                 :           ODI 11.1.1.6, 11.1.1.7,12.2.1.3.0, SQL,PL/SQL
  • Databases                                               :           Oracle, SQL Server, MySQL.
  • Reporting Tools                                  :           OBIEE 11G
  • Database Tools                                      :           SQL Developer, SQL * Plus.
  • Ticket Tracking Tools                           :            Service Now
Projects

Project 1- TEP Finance - IT Industry (48 months)

    Roles and Responsibilities:




    • Setting up Connection parameters in the topology Manager.

    • Created Physical schemas and Logical Schemas in Different Contexts.

    • Mapped Logical resources and Physical resources.

    • Creating several reverse engineering Models.

    • Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups.

    • Developed Interfaces to Populate Business Data to Target tables.

    • Created ODI procedures as per the requirement and populate in target systems.

    • Exported scenarios in the dev and imported in Test and Production environments.

    • Developed Interfaces for dimensional Incremental uploading.

    • Identified and Imported KM as per the Requirement.

    • Created and scheduled in ODI scenarios.

    • Monitor the execution logs in the Operator.

    • Performed scheduling by using ODI Scheduler.

    • Debug the sessions by utilizing the log of the sessions.


Project 2- TEP Finance and HCM - IT Industry (24 months)

    Roles and Responsibilities:




    • Worked on Object level and data level security.

    • Setting up Connection parameters in the topology Manager.

    • Created Physical schemas and Logical Schemas in Different Contexts.

    • Mapped Logical resources and Physical resources.

    • Creating several reverse engineering Models.

    • Involved in RPD Deployment and Metrics creation in BMM Layer of OBIEE.

    • Created Test Case documents to test the new objects added and Migration document to migrate the code units across environments.

    • Created OBIEE Agents to generate alerts and delivered it to target users.

    • Identified and Imported KM as per the Requirement.

    • Monitoring the ELT workflows by using ODI tools.

    • Debug the sessions by utilizing the log of the sessions.

    • Performed unit testing at various levels of ELT flows.


Similar Talent