Be an early applicantLess than 25 applicants

Company

ComResource · 7 hours ago

ODI Consultant

United States

Contract

Remote

Mid Level

Maximize your interview chances

CRMInformation Technology

Comp. & Benefits

H1B Sponsor Likely

Insider Connection @ComResource

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Develop and maintain ETL and Integration workflows using ODI, leveraging its declarative design approach and modular Knowledge Modules (KMs) to simplify integration tasks.

Design scalable, efficient, and secure data pipelines to support project requirements, ensuring compliance with enterprise data governance policies.

Implement and configure middleware solutions to facilitate seamless communication between Oracle systems, SQL Server, and GCP.

Optimize middleware configurations and troubleshoot issues to maintain high availability and reliability.

Perform in-depth analysis of source and target systems to define data mappings and complex transformation rules.

Utilize ODI’s mapping components and transformation logic to automate and validate data workflows.

Work with database administrators, developers, and business analysts to gather and refine data integration requirements.

Create detailed technical documentation of ETL workflows, middleware configurations, and integration processes for ongoing support and scalability.

Monitor ODI agents, repositories, and job executions to identify and address performance bottlenecks.

Implement best practices for ELT design, including efficient use of database indexes, partitioning, and parallel processing.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Oracle Data Integrator (ODI)ETL processesSQL ServerGCP data servicesAdvanced SQLPL/SQLMiddleware solutionsData modelingData warehousingCloud-based data integrationKnowledge Modules (KM)InformaticaTalendOracle Databases certificationGCP certification

Required

Bachelor’s degree in Computer Science, Information Systems, or a related field.

Proven experience as an ODI Consultant or in a similar role focusing on ETL and middleware.

Expertise in Oracle Data Integrator (ODI), including ODI Studio, Agent, and repository management.

Strong understanding of ELT architecture and Knowledge Modules (KM) customization.

Hands-on experience with SQL Server and GCP data services, such as BigQuery and Dataflow.

Advanced SQL and PL/SQL skills for complex data manipulation and transformation.

Familiarity with data modeling, data warehousing concepts, and cloud-based data integration solutions.

Experience with middleware tools and integration platforms.

Preferred

Experience with Loyalty applications, homegrown or out-of-box software.

Knowledge of additional GCP services such as Cloud Storage, Pub/Sub, and Data Catalog.

Experience with other ETL tools (e.g., Informatica, Talend) and cloud data platforms.

Relevant certifications in ODI, Oracle Databases, or GCP are a plus.

Company

ComResource

ComResource is one of IBM's preferred Business Partners in the the IBM Sterling Solutions.

Founded in 1991

Columbus, Ohio, USA

201-500 employees

http://comresource.com/

H1B Sponsorship

ComResource has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (4)

Funding

Current Stage

Growth Stage

Leadership Team

Monica Pennington

Director, Data Solutions / Chief Branding & Communications Officer

Company data provided by crunchbase

Orion

Your AI Copilot