𝐄𝐱𝐩𝐞𝐫𝐢𝐞𝐧𝐜𝐞: 8+ Years
𝐋𝐨𝐜𝐚𝐭𝐢𝐨𝐧: Hyderabad
𝐊𝐞𝐲 & 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
- Design, develop, and maintain Oracle ODI interfaces, packages, scenarios, and load plans
- Analyze business requirements and translate them into effective ODI-based solutions
- Build and optimize mappings and transformations for multiple data sources including RDBMS, flat files, cloud platforms, and REST/SOAP APIs
- Ensure high performance, scalability, and reliability of ETL/ELT processes
- Develop, customize, and maintain ODI Knowledge Modules (KMs)
- Integrate ODI with Oracle Database, GoldenGate, SOA, Oracle Integration Cloud (OIC), and other cloud services
- Perform unit testing, support SIT and UAT phases, and resolve defects
- Collaborate with ODI administrators for deployment, monitoring, and performance tuning
- Mentor junior developers and conduct code reviews to maintain quality standards
𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝 𝐒𝐤𝐢𝐥𝐥𝐬 & 𝐐𝐮𝐚𝐥𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬:
- Extensive hands-on experience with Oracle ODI (interfaces, procedures, packages, load plans, and scenarios)
- Strong SQL and PL/SQL skills with solid Oracle database performance tuning experience
- In-depth knowledge of data warehousing concepts including star and snowflake schemas
- Experience in custom Knowledge Module (KM) development and API integrations (REST/SOAP)
- Exposure to OIC, SOA, or MuleSoft is an added advantage
- Excellent analytical, problem-solving, and communication skills
𝐀𝐩𝐩𝐥𝐲: hr@techfokes.com