Summary
Overview
Work History
Education
Skills
Projects
Technicalexperience
Timeline
Generic
Srinu Parimi

Srinu Parimi

Hyderabad

Summary

  • Oracle Data Integrator (ODI) 11g/12c.
  • Have experience in data Extraction, Loading and Transformation in data warehouse environment.
  • Designed and developed mappings to load the data from multiple sources like Relational databases, flat files into oracle database.
  • Developed packages, Load Plans, scenarios using Mappings, Procedures, and variables.
  • Worked with knowledge modules like LKM, IKM, RKM, CKM and JKM.
  • Have knowledge about Designer, Operator, Topology and Security in Oracle Data Integrator.
  • Experienced in developing SCD's using built in Knowledge modules.
  • Experience in creating Load Plans to execute the ODI object (Scenarios) in Serial, parallel and conditional.
  • Good Knowledge on Exception Handling in Load plans and Packages.
  • Experience in scheduling ODI Scenarios as per the business requirements
  • Knowledge on creating ODI procedures to create and populate in target systems.
  • Knowledge on ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment and Configuration of Standalone agent.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and Hints.
  • Ability to work individually as well as in a team with excellent problem solving skills.

Overview

5
5
years of professional experience

Work History

ODI Developer

Alshaya Group
03.2022 - Current
  • Company Overview: Alshaya Group (also called the M
  • H
  • Alshaya Co.) is a multinational retail franchise operator headquartered in Kuwait
  • It operates 90 consumer retail brands across the Middle East and North Africa, Russia, Turkey, and Europe
  • In addition to its retail operations, the Alshaya Group has holdings in real estate, construction, hotels, automotive and general trading, largely centered in the Middle East
  • Monitoring Logs and checking as for scheduling time they are running or not
  • Any failures happened create tickets in Jira Now and assign & Close the Tickets before breach the time
  • Attending internal CG meeting's regularly and Attending Client meeting regularly
  • Coordinated with the DBA teams and Source team and CGI team, Checking the Error and apply the fix
  • Reverse engineered the DB level Table into ODI and loaded data from source to Target, table using Mappings
  • Documenting all new and modified mappings according to standards as part of the Data Operations documentation
  • As per Requirement New mapping or packages are creating
  • Most of the time attending War Rooms
  • Alshaya Group (also called the M
  • H
  • Alshaya Co.) is a multinational retail franchise operator headquartered in Kuwait
  • It operates 90 consumer retail brands across the Middle East and North Africa, Russia, Turkey, and Europe
  • In addition to its retail operations, the Alshaya Group has holdings in real estate, construction, hotels, automotive and general trading, largely centered in the Middle East
  • Technologies/Tools Used: ODI 12c, Jira, SQL

ODI Developer

Capgemini services India
Hydrabad
03.2022 - 07.2023
  • Currently working as Capgemini services India, Hydrabad

ODI Developer

Nityo Infotech services india Pvt ltd
Bangalore
02.2021 - 03.2022
  • Worked as an ODI Developer in Nityo Infotech services india Pvt ltd, Bangalore

ODI Developer

Vodafone
02.2021 - 03.2022
  • Company Overview: This is Data warehouse project and Here data will flow in different layers and finally load into Semantic layer for report purpose
  • Here CRM data extracted from Seibel and Billing data extracted from BRM system on to the ODS (this we will call it as staging db) by using Oracle golden gate (This is real time replication and this enables transactional change data capture, and verification between operational and analytical enterprise systems)
  • Implemented best practices in Moving/Copying folders/mapping (Exporting and importing objects) between repositories and environments
  • Creating several reverse engineering Models as per the requirements
  • Imported and executed master jobs, scenarios in Execution repository
  • Monitoring the Execution Logs in operator navigator
  • Imported master job and executed as per the requirements
  • Creating Mappings and packages by using global and local variables for a Job
  • Creating Mappings by using components
  • Creating Topology connections and Standalone agent
  • Loading metadata data from Oracle, Sql server source system into RDBMS target system
  • Scheduling the scenarios by using ODI Scheduler
  • Performed Data validation, Testing, Debugged the mapping for failed session
  • This is Data warehouse project and Here data will flow in different layers and finally load into Semantic layer for report purpose
  • Here CRM data extracted from Seibel and Billing data extracted from BRM system on to the ODS (this we will call it as staging db) by using Oracle golden gate (This is real time replication and this enables transactional change data capture, and verification between operational and analytical enterprise systems)

ODI Developer

Abhudaya HR Business solutions
07.2019 - 02.2021
  • Worked as an ODI Developer in Abhudaya HR Business solutions

ODI Developer

British Telecom
  • Company Overview: British Telecom is one of the world's leading communications services companies, serving the needs of customers in the UK and across the world, where they provide fixed-line services, broadband, mobile and TV products and services as well as networked IT services
  • They also sell wholesale products and services to communications providers in the UK and around the world
  • Setting up Connection parameters in the topology Manager of ODI
  • Creating Physical schemas and Logical Schemas in Different Contexts
  • Mapped Logical resources and Physical resources in different contexts
  • Creating several reverse engineering Models as per the requirements
  • Developed several Interfaces as per the requirements
  • Developed Interfaces to Union Multiple tables of same structure using Datasets
  • Created and scheduled in ODI scenarios as per the requirements
  • Created ELT workflows in the package by using ODI Tools
  • Monitor interfaces and execution logs as per the requirements
  • Developed packages as per the requirements
  • Exported scenarios in the DEV and imported in Production environment
  • Written sql functions as per the requirement
  • Developed Interfaces for dimensional Incremental uploading
  • Imported KM as per the Requirement
  • Debug the sessions by utilizing the log of the sessions
  • Performed unit testing at various levels of ELT flow
  • British Telecom is one of the world's leading communications services companies, serving the needs of customers in the UK and across the world, where they provide fixed-line services, broadband, mobile and TV products and services as well as networked IT services
  • They also sell wholesale products and services to communications providers in the UK and around the world

Education

MCA -

JNTU College of Engineering
Kakinada

Skills

  • odi (oracle data integrator)
  • sql

Projects

Alshaya, Alshaya Group, Kuwait, 03/01/22 - Present, Multinational retail franchise operator. Phoenix, Vodafone, Greece, 02/01/21 - 03/31/22, Data warehouse project. IRS2, British Telecom, UK, 07/01/19 - 02/28/21, Migration project for Customer Services System.

Technicalexperience

Oracle 11g, Oracle 12c, Oracle Data Integrator (ODI) 11g/12c, Toad, Windows 2003 Server, Windows 7, Windows 10

Timeline

ODI Developer

Alshaya Group
03.2022 - Current

ODI Developer

Capgemini services India
03.2022 - 07.2023

ODI Developer

Nityo Infotech services india Pvt ltd
02.2021 - 03.2022

ODI Developer

Vodafone
02.2021 - 03.2022

ODI Developer

Abhudaya HR Business solutions
07.2019 - 02.2021

ODI Developer

British Telecom

MCA -

JNTU College of Engineering

Similar Profiles

CREATE PROFILE
Srinu Parimi