ODI

Job Description

Job Opening Details back to list Reference Code: AR1113 Job Title: ODI Category: 8+ years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects. Minimum 2 years of strong experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design. Must have worked on end to end implementation of DW and BI projects. Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure. Design and develop mappings, Process Flows and ETL scripts. Experience of performance tuning of mappings. Ability to tune mappings at ETL level and provide suggestion of tuning at database level. Ability to design ETL unit test cases and debug ETL Mappings. Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs. Managing Files, Oracle DB, XMLs through ODI Create Load-Plans and schedule the same. Create email notifications to alert on exceptions and error. Must be well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM. Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc. Ability to work with functional groups and different level of employees to effectively and professionally achieve results Strong follow-up skills; ability to organize applicable department timelines and follow up with internal and external customer needs Strong organizational skills, ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast paced environment Functional Proficiency on Packaged BI Application (Oracle) is preferred. Key Skills: ODI Location: Ahmedabad, Bangalore, Chennai, Delhi, Hyderabad, Kolkata, Mumbai, Pune, acity, Agartala, Agra, Aizawal, Ajman, Ajmer, Akola, Alappuzha / Alleppey, Aligarh, Allahabad, Ambala, Amravati, Amritsar, Anand, Anantapur, Anantnag, Asansol, Aurangabad, Aurora, Bahgalpur, Baramulla, Bareilly, Baroda, Batala, Bathinda, Beirut, Belgaum, Bellary, Bhagalpur, Bharuch, Bhatinda, Bhavnagar, Bhilai-Durg, Bhilaigarh, Bhillai, Bhiwani, Bhopal, Bhubaneshwar, Bhuj, Bidar, Bikaner, Bilaspur, Bokaro, Bongaigaon, Budgam, Buldhana, Burdwan, Calicut, Cape Town, Chamba, Chandigarh, Chandrapur, Cochin, Coimbatore, Cuddalore, Cuttack, Dadra & Nagar Haveli - Silvass, Dalhousie, Daman, Davanagere, Dehradun, Dhanbad, Dharamsala, Dharwad, Dhubri, Dhule, Dibrugarh, Dimapur, Dispur, Doda, durgapur, Ernakulam, Erode, Faizabad, Faridabad, Faridkot, Fatehabad, Fatehgarh Sahib, Ferozepur, Gandhidham, Gandhinagar, Gangtok, Ghaziabad, Gir, Goa, Gondia, Gorakhpur, Gulbarga, Guntakal, Guntur, Gurdaspur, Gurgaon, Guwahati, Gwalior, Haldia, Haldwani, Hamirpur, Haridwar, Hisar, Hoshiarpur, Hosur, Hubli, Idukki, Imphal, Indore, Itanagar, Jabalpur, jaipur, Jaisalmer, Jalandhar, Jalgaon, Jammu, Jamnagar, Jamshedpur, Jhajjar, Jharkhand, Jind, Jodhpur, Jullundhar, Junagarh, Kaithal, Kakinada, Kanchipuram, Kandla, Kangra, Kanniyakumari, Kannur, Kanpur, Kapurthala, Kargil, Karnal, Karur, Kasargod, Kasauli, Kathua, Katni, Kavaratti, Kharagpur, Kinnaur, Kochi, Kohima, Kolar, Kolhapur, Kollam, Kota, Kottayam, Kozhikode, Kullu, Kupwara, Kurnool, Kurukshetra, Lakshdweep, Latur, Leh, Lonavala, lucknow, Ludhiana, Madurai, Mahabaleshwar, Mahendergarh, Malappuram, Malaysia, Malda, Manali, Manama, Mandi, Mangalore, Manipur, Mansa, Margaon, Mathura, Meerut, Mehsana, Midnapur, Moga, Mohali, Moradabad, Muktsar, Muzaffarnagar, Muzaffarpur, Mysore, Nagercoil, Nagpur, Nainital, Nalagarh, Nanded, Narnaul, Nasik, Navi Mumbai, Nawanshahr, Nellore, Nizamabad, Noida, Ooty, Palakkad, Palghat, Pallakad, Panchkula, Panipat, Panjim, Paradeep, Parwanoo, Pathanamthitta, Pathankot, Patiala, Patna, Pondicherry, Poonch, Porbandar, Pulwama, Puri, Raipur, Rajahmundry, Rajkot, Rajouri, Raleigh, Ranchi, Raniganj, Ras Al Khaimah, Ratlam, Redmond, Rewari, Richmond, Rohtak, Roorkee, Ropar, Rourkela, Rudrapur, Sagar, Saharanpur, Salem, Sangli, Sangrur, Satara, Satna, Secunderabad, Shillong, Shimla, Shimoga, Sholapur, Sibsagar, Sikkim, Silchar, Siliguri, Silvassa, Sirmaur, Sirsa, Solan, Solapur, Sonepat, Srinagar, Sterling, Surat, Tamil Nadu, Test, Tezpur, Thane, Thanjavur, Thiruvananthapuram, Thrissur, Tinsukia, Tiruchirapalli, Tirunalveli, Tirupati, Trichy, Tripura, Trivandrum, Tuticorin, Udaipur, Udhampur, Ujjain, Una, Valsad, varanasi, Vasco Da Gama, Vellore, Vijayawada, Visakhapatnam, Warangal, Wayanad, Yamunanagar Required Experience: 8-10 yrs Positions: 1 Contact Person: Aravind Email ID: aravind@vegaintellisoft.com Qualification:,

Keyskills :
oracle data integratortest casesdata modelingoracle databasedata integratorcommercial modelsperformance tuningsystem integrationoracle data integrator odi