18 Nov
|
Proso.ai
|
Noida
We are looking for an experienced Data Integration Consultant with strong expertise in Oracle Data Integrator (ODI) 12c, SQL, Oracle performance tuning, and Snowflake. The ideal candidate should be capable of independently troubleshooting complex ODI environments, managing batch-driven data loads, and supporting Data Vault executions with minimal hand-holding. Roles and Responsibilities
• Troubleshoot and resolve ODI 12c issues using Operator, session logs, scenarios, agents, and generated code.
• Develop, maintain, and manage ODI mappings, reusable components, knowledge modules, load plans, variables, scenarios, and topology configurations.
• Perform advanced SQL development and Oracle database performance tuning, including explain plan analysis, indexing, partitioning, statistics, and bulk/set-based processing.
• Execute and monitor batch-driven data loads using batch-control tables, batch IDs, dependency management, and restart/recovery mechanisms.
• Work with Snowflake for SQL development, data loading, warehouse management, and query execution.
• Support Data Vault implementations and apply Data Vault 2.0 modeling concepts within data integration workflows.
• Independently analyze complex technical issues, identify root causes, and implement effective solutions.
• Collaborate with project teams to ensure reliable, efficient, and scalable data integration processes. Must-Have Skills
• Expert-level SQL and strong hands-on Oracle database performance tuning.
• Proven experience troubleshooting and resolving issues in ODI 12c.
• Robust knowledge of ODI 12c navigation and advanced concepts, including Knowledge Modules, Load Plans, Variables, Scenarios, Reusable Mappings, and Topology.
• Hands-on experience with batch execution, batch-control tables, dependencies, restart, and recovery processes.
• Practical experience with Snowflake SQL, data loading, and warehouse/query fundamentals.
• Strong understanding of Data Vault 2.0 or the ability to quickly learn and apply complex data modeling concepts.
• Self-driven problem-solving skills and the ability to work independently in complex technical environments.
📌 Data Vault + ODI + Snowflake Developer (Noida)
🏢 Proso.ai
📍 Noida