ODI Developer at Technovert · Hyderabad · 5 - 8 years · ₹12.5L - ₹24L / yr · Profitable · Posted 8 Nov 2022
Role: ODI Developer
Location: Hyderabad (Initially remote)
Experience: 5-8 Years
Technovert is not your typical IT services firm. We have to credit two of our successful products generating $2M+ in licensing/SaaS revenues which is rare in the industry.
We are Obsessed with our love for technology and the infinite possibilities it can create for making this world a better place. Our clients find us at our best when we are challenged with their toughest of problems and we love chasing the problems. It thrills us and motivates us to deliver more. Our global delivery model has earned the trust and reputation of being a partner of choice.
We have a strong heritage built on great people who put customers first and deliver exceptional results with no surprises - every time. We partner with you to understand the interconnection of user experience, business goals, and information technology. It's the optimal fusing of these three drivers that deliver.
Must have:
- Experience with DWH Implementation experience, with experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc.
- Responsible for creation of ELT maps, Migrations into different environments, Maintenance and Monitoring of the infrastructure, working with DBA's as well as creation of new reports to assist executive and managerial levels in analyzing the business needs to target the customers.
- Should be able to implement reusability, parameterization, workflow design, etc.
- Expertise in the Oracle ODI toolset and OAC & knowledge of ODI Master and work repository &data modeling and ETL design.
- Used ODI Topology Manager to create connections to various technologies such as Oracle, SQL Server, Flat files, XML, etc.
- Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects.
- Ability to design ETL unit test cases and debug ETL Mappings, expertise in developing Load Plans, Scheduling Jobs.
- Integrate ODI with multiple Sources/targets.
Nice to have:
- Exposure towards Oracle Cloud Infrastructure (OCI) is preferable.
- Knowledge in Oracle Analytics Cloud to Explore data through visualizations, load, and model data.
- Hands-on experience of ODI 12c would be an added advantage.
Qualification:
- Overall 3+ years of experience in Oracle Data Integrator (ODI) and Oracle Data Integrator Cloud Service (ODICS).
- Experience in designing and implementing the E-LT architecture that is required to build a data warehouse, including source-to-staging area, staging-to-target area, data transformations, and EL-T process flows.
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM) and experience of performance tuning of mappings.
- Must be self-starting, have strong attention to detail and accuracy, and able to fill multiple roles within the Oracle environment.
- Should be good with Oracle/SQL and should have a good understanding of DDL Deployments.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Technovert
About
We are a team of problem solvers passionate about design and technology, delivering Digital transformation and increasing productivity.
Connect with the team
Company social profiles
Similar jobs (2)
OBIEE Developer + ETL Lead
🔹 Experience: 8+ Years
🔹 Location: PAN India
🔹 Work Mode: Work From Office – 5 Days
🔹 Joining: Immediate Joiners Preferred
🔹 Communication: Excellent communication skills required
💼 Key Skills:
• #OBIEE Development
• #ETL / #DataIntegration
• #BIReporting & Analytics
• #ETL Lead / Technical Leadership
• Strong #SQL & #Database Concepts
Role Summary
We are looking for a Senior OIC Developer with 5 to 8 years of experience to design, develop, and deliver enterprise integration solutions using Oracle Integration Cloud Gen3. The ideal candidate should have strong hands-on experience in OIC, relational databases, and integrations across Oracle Cloud Warehouse Management System, Oracle Fusion, and Oracle Transportation Management. This role requires someone who can translate business requirements into scalable technical designs, lead project execution, and collaborate effectively with functional and technical stakeholders.
Key Responsibilities
• Design, develop, test, deploy, and support integrations using Oracle Integration Cloud Gen3.
• Convert business and functional requirements into integration designs, technical specifications, mappings, and implementation plans.
• Build and maintain integrations between OIC, OCWMS, Oracle Fusion, OTM, relational databases, and other enterprise systems.
• Work with REST, SOAP, database adapters, file-based integrations, transformations, mappings, lookups, error handling, and monitoring capabilities in OIC.
• Lead small to medium integration work streams, coordinate with cross functional teams, and ensure timely delivery of project milestones.
• Perform troubleshooting, root-cause analysis, performance tuning, and production support for integration issues.
• Follow integration best practices for security, reusability, scalability, observability, documentation, and change management.
• Collaborate with business analysts, functional consultants, architects, developers, and support teams to deliver reliable integration solutions.
Must-Have Skills
• Strong hands-on experience with Oracle Integration Cloud Gen3.
• Strong hands-on experience with relational databases and SQL.
• Experience integrating OIC with OCWMS, Oracle Fusion.
• Experience leading a project or integration work stream.
• Ability to convert requirements into clear technical designs and implementation plans.
• Good understanding of integration patterns, data mapping, API-based integrations, error handling, monitoring, and debugging.
• Strong communication, problem-solving, and stakeholder coordination skills.
Good-to-Have Skills
• Functional knowledge of OCWMS, Oracle Transportation Management, and Oracle Fusion applications.
• Awareness of AI capabilities in Oracle Integration Cloud, including natural language-assisted development, AI-assisted troubleshooting, and OCI AI service actions.
• Familiarity with cloud computing concepts and cloud-native integration approaches.
• Oracle Integration Cloud certification.
• Familiarity with Oracle Cloud Infrastructure, including basic understanding of OCI services, security, connectivity, and deployment concepts.
Qualifications
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 5 to 8 years of relevant experience in integration development, preferably with Oracle Integration Cloud.
• Oracle Integration Cloud certification is required.
• Experience in Oracle SCM, logistics, warehouse management, transportation, or enterprise application integration projects will be an advantage.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon