Remote
Not Specified
Time and material
$ 15-20/Hr
Description
**About the Role** We are seeking an experienced Data Solutions Consultant with strong expertise in Data Vault, Oracle Data Integrator (ODI), and Snowflake. The role involves transforming complex data models and optimizing performance in a demanding and dynamic environment. This position focuses on the execution of large-scale data solutions for business intelligence and analytics applications, providing strategic insights to enhance business operations. **Key Responsibilities** - Develop and maintain Data Vault models and integrate them using Oracle Data Integrator 12c and Snowflake. - Perform expert-level SQL programming and Oracle performance tuning, including reading explain plans, indexing, and using set-based processing. - Triage and resolve issues within ODI 12c, utilizing operator and session logs effectively. - Execute and manage batch-controlled data load processes, ensuring accuracy and efficiency in Data Vault executions. - Utilize advanced ODI 12c navigation and concepts, working with knowledge modules, load plans, and reusable mappings. - Collaborate with stakeholders to understand data requirements and drive complex problem-solving initiatives. - Facilitate seamless data flows between systems while optimizing for performance and scalability. - Ensure the security and integrity of data systems, advising on best practices across platforms. **Must-Have Qualifications** - At least 5 years of experience in data engineering or a similar field with a focus on SQL and Oracle. - Strong practical experience with ODI 12c, including advanced user capabilities and problem-solving. - Proficiency in Snowflake operations and integration with other data tools. - In-depth knowledge of Data Vault 2.0 principles and implementation. - Excellent communication and stakeholder management skills. - Full legal right to live and work in the [Country] without restrictions. **Nice-to-Have** - Familiarity with data streaming or CDC tools like Kafka. - Hands-on experience with Data Vault implementations in production environments. - Exposure to CDC, data replication, or GoldenGate-style pipeline management.
Skills:
Batch execution,Data modeling,Data Vault 2.0,ODI 12c,Oracle performance tuning,Problem-solving,Snowflake,SQL

Interested in this project and numerous others like it?

Register on WorkWall now and get started