Current jobs related to Oracle Data Integrator - Hamilton - ThoughtStorm Inc


  • Hamilton, Canada Renesas Electronics Corporation Full time

    Job DescriptionWe are seeking a highly skilled Oracle SQL Developer to join our team, focusing on semiconductor production master data management and the development of ETL (Extract, Transform, Load) tools. In this role, you will be responsible for designing, developing, and maintaining SQL-based solutions to ensure the integrity, efficiency, and scalability...


  • Hamilton, Canada Renesas Electronics Corporation Full time

    Job DescriptionWe are seeking a highly skilled Oracle SQL Developer to join our team, focusing on semiconductor production master data management and the development of ETL (Extract, Transform, Load) tools. In this role, you will be responsible for designing, developing, and maintaining SQL-based solutions to ensure the integrity, efficiency, and scalability...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe Data Integrity Specialist is responsible for ensuring compliance and data integrity through verification of records generated in sampling, preparation, instrumental analysis, data evaluation and calculation of reportable results related to radiopharmaceuticals at AtomVie Global Radiopharma Inc. This role is critical in sustaining data...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe Data Integrity Specialist is responsible for ensuring compliance and data integrity through verification of records generated in sampling, preparation, instrumental analysis, data evaluation and calculation of reportable results related to radiopharmaceuticals at AtomVie Global Radiopharma Inc. This role is critical in sustaining data...


  • Hamilton, Canada Renesas Electronics Corporation Full time

    Job DescriptionManage databases through multiple product lifecycle environments, from development to mission-critical production systemsConfigure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and securityIndependently analyze, solve, and correct issues...

  • Contract Oracle Dba

    3 weeks ago


    Hamilton, Canada Renesas Electronics Corporation Full time

    Job DescriptionManage databases through multiple product lifecycle environments, from development to mission-critical production systemsConfigure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and securityIndependently analyze, solve, and correct issues...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe QA – Data Reviewer plays a critical role in ensuring the integrity of data generated in our Analytical Development and Quality Control laboratories.This position is responsible for verifying the accuracy and completeness of records related to radiopharmaceuticals, ensuring compliance with Good Documentation Practices (GDP) and 21 CFR Part...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe QA – Data Reviewer plays a critical role in ensuring the integrity of data generated in our Analytical Development and Quality Control laboratories.This position is responsible for verifying the accuracy and completeness of records related to radiopharmaceuticals, ensuring compliance with Good Documentation Practices (GDP) and 21 CFR Part...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleAt AtomVie Global Radiopharma Inc., we are seeking a highly skilled QA - Data Reviewer to join our team. As a key member of our Analytical Development and Quality Control laboratories, you will play a critical role in ensuring the integrity of our data and maintaining compliance with Good Documentation Principles (GDP) and 21 CFR Part 11...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleAt AtomVie Global Radiopharma Inc., we are seeking a highly skilled QA - Data Reviewer to join our team. As a key member of our Analytical Development and Quality Control laboratories, you will play a critical role in ensuring the integrity of our data and maintaining compliance with Good Documentation Principles (GDP) and 21 CFR Part 11...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe Quality Assurance Specialist, Data Reviewer plays a critical role in ensuring the integrity of data generated in our Analytical Development and Quality Control laboratories.This position is responsible for verifying the accuracy and completeness of records related to radiopharmaceuticals, ensuring compliance with Good Manufacturing...


  • Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    About the RoleThe Quality Assurance Specialist, Data Reviewer plays a critical role in ensuring the integrity of data generated in our Analytical Development and Quality Control laboratories.This position is responsible for verifying the accuracy and completeness of records related to radiopharmaceuticals, ensuring compliance with Good Manufacturing...


  • Hamilton, Ontario, Canada AFP Golden Horseshoe Chapter Full time

    About AFP Golden Horseshoe ChapterWe are a leading organization in the field of hospice palliative care, dedicated to serving the emotional, physical, social, and spiritual needs of individuals living with a progressive life-limiting illness. Our mission is to provide compassionate care and support to our clients, their families, and our community.Job...


  • Hamilton, Ontario, Canada AFP Golden Horseshoe Chapter Full time

    About AFP Golden Horseshoe ChapterWe are a leading organization in the field of hospice palliative care, dedicated to serving the emotional, physical, social, and spiritual needs of individuals living with a progressive life-limiting illness. Our mission is to provide compassionate care and support to our clients, their families, and our community.Job...


  • Hamilton, Canada McMaster University Full time

    **_Human Resources Services Mission:_**: - As value-added service partners we cultivate human potential and champion an inclusive culture by: Enabling University strategy; Collaborating with our community; Delivering service excellence; and Empowering learning & growth._ McMaster University is multi-faceted with multiple locations and constituencies. As a...


  • Hamilton, Ontario, Canada Hamilton Family Health Team Full time

    Job Title: Integration Director, Primary HealthcareHamilton Family Health TeamWe are seeking an experienced Integration Director, Primary Healthcare to join our team at Hamilton Family Health Team. As a key member of our leadership team, you will play a critical role in advancing our strategic plan and driving the development of a primary healthcare...


  • Hamilton, Ontario, Canada Hamilton Family Health Team Full time

    Job Title: Integration Director, Primary HealthcareHamilton Family Health TeamWe are seeking an experienced Integration Director, Primary Healthcare to join our team at Hamilton Family Health Team. As a key member of our leadership team, you will play a critical role in advancing our strategic plan and driving the development of a primary healthcare...


  • Hamilton, Ontario, Canada Hamilton Family Health Team Full time

    Job Title: Integration Director, Primary HealthcareHamilton Family Health Team is seeking an experienced Integration Director, Primary Healthcare to join our team. As a key member of our leadership team, you will play a critical role in advancing our strategic plan through the development and implementation of four geographical neighbourhoods across...


  • Hamilton, Ontario, Canada Hamilton Family Health Team Full time

    Job Title: Integration Director, Primary HealthcareHamilton Family Health Team is seeking an experienced Integration Director, Primary Healthcare to join our team. As a key member of our leadership team, you will play a critical role in advancing our strategic plan through the development and implementation of four geographical neighbourhoods across...

  • Data Scientist

    1 week ago


    Hamilton, Ontario, Canada SHIL Technologies, Inc Full time

    About SHIL Technologies, Inc.We are a leading technology company that specializes in data-driven solutions. Our team is passionate about leveraging data to drive business growth and improve operational efficiency.Job SummaryWe are seeking a highly skilled Data Engineer to join our team. The successful candidate will be responsible for designing, developing,...

Oracle Data Integrator

4 months ago


Hamilton, Canada ThoughtStorm Inc Full time

We are seeking a highly skilled ODI Developer with extensive experience in upgrading from Oracle Data Integrator (ODI) 11g to 12c Cloud Edition, particularly in conjunction with Oracle Business Intelligence Applications (OBIA) Out-of-the-Box (OOTB) solutions.

The term of the engagement is 6 months with an option to renew for up to an additional 6 months, starting this April 2024.

Kindly indicate if you have a resource that meets the requirements and responsibilities of the Lead ODI Developer as described below and provide a cost for the services at your earliest convenience.

**Requirements**:
1. Proven experience as an ODI Developer, with a minimum of 8+ years of hands-on experience in Oracle Data Integrator 11g/12c.

2. In-depth knowledge of ODI 11g and 12c Cloud Edition, including installation, configuration, and administration.

3. Proficiency in Oracle Business Intelligence Applications (OBIA) and familiarity with Out-of-the-Box (OOTB) solutions.

4. Strong SQL and PL/SQL programming skills, with the ability to write complex queries and stored procedures.

5. Extensive experience with Oracle databases and data warehousing concepts.

**Responsibilities**:
1. Lead the upgrade process from ODI 11g to 12c Cloud Edition, ensuring all components, workflows, and integrations are migrated successfully.

2. Collaborate with cross-functional teams including database administrators, business analysts, and developers to understand requirements and identify upgrade dependencies.

3. Develop and implement upgrade strategies, ensuring mínimal downtime and data integrity during the migration process.

4. Must have experience in Moving ETL customizations from 11g to 12c.

5. Customize and extend OBIA Out-of-the-Box solutions to meet specific business requirements, leveraging ODI's capabilities for data transformation and integration.

6. Design, develop, and maintain ODI interfaces, packages, and workflows to support data extraction, transformation, and loading (ETL) processes.

7. Perform troubleshooting and debugging of ODI workflows, identifying and resolving performance bottlenecks, errors, and issues.

8. Develop expertise in the Oracle ODI tool set (12c) and Oracle PL/SQL, ODI. Should be able to create ODI Mapping, Packages, Scenarios, and load plans.

9. Set up topology, build objects in Designer, Monitoring Operator, different types of KMs, Agents, etc.

10. Package components, perform database operations like Aggregate, union, etc.

11. Optimize ODI 12c Cloud Edition environments for enhanced performance and scalability.

12. Develop topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.

13. Collaborate with stakeholders to gather requirements, define data integration workflows, and provide technical guidance and expertise.

14. Document technical specifications, upgrade processes, and best practices for knowledge sharing and future reference.

15. Stay up-to-date with the latest trends and advancements in ODI, OBIA, and Oracle technologies, recommending and implementing improvements to enhance system performance and efficiency.
- _Reply__Reply all__ForwardAttendee panel closed

**Job Type**: Contract

**Salary**: From $80.00 per hour

Expected hours: 37.5 per week

Ability to Commute:

- Hamilton, ON (required)

Ability to Relocate:

- Hamilton, ON: Relocate before starting work (required)

Application deadline: 2024-03-12