Oracle Data Integrator (ODI) Developer Job at ACS Consultancy Services, Albany, NY

dG8zbmhac1drMWM5alYvakFhTEx6Smtqd1E9PQ==
  • ACS Consultancy Services
  • Albany, NY

Job Description

Job Title : Oracle Data Integrator (ODI) Developer

Location : Remote

We are currently seeking candidates who meet the following qualification

Responsibilities:
  • Design, develop, and optimize ETL processes using Oracle Data Integrator (ODI).
  • Perform source-to-target mapping, data transformations, and incremental data loads.
  • Develop and maintain database schemas, tables, views, and stored procedures.
  • Work closely with data architects, business analysts, and stakeholders to understand data integration needs.
  • Troubleshoot and resolve ETL failures, performance bottlenecks, and data quality issues.
  • Implement ODI best practices for error handling, logging, and auditing.
  • Support data warehouse and business intelligence initiatives by ensuring efficient data movement.
  • Develop and maintain documentation for ETL processes, workflows, and technical specifications.
  • Collaborate with cross-functional teams to integrate data from various sources, including Oracle, SQL Server, and external APIs.
Qualifications:
  • Experience in ETL development using Oracle Data Integrator (ODI).
  • Strong experience in SQL and PL/SQL for Oracle databases.
  • Proficiency in data modeling, normalization, and performance tuning.
  • Hands-on experience in designing and optimizing ETL workflows and data pipelines.
  • Experience with data warehousing concepts and best practices.
  • Knowledge of UNIX/Linux shell scripting for automation and job scheduling.
  • Strong problem-solving and troubleshooting skills.
  • Experience in migrating ETL processes from Oracle Warehouse Builder (OWB) to ODI.
  • Experience in cloud-based data integration solutions (AWS, Azure, or GCP).
  • Experience with real-time data integration and streaming technologies (Kafka, GoldenGate, etc.).
  • Knowledge of Master Data Management (MDM) and Data Governance best practices.
  • Federal Experience is a plus.
  • Required Security clearance.


    If you meet these qualifications, please submit your application via link provided in Linkedin.
    Kindly do not call the general line to submit your application.

Job Tags

Remote job,

Similar Jobs

Kelsey-Seybold Clinic

Physician - Orthopedic Sports Medicine Job at Kelsey-Seybold Clinic

 ...is 11 years ~ Physician-led board of managers ~ A defined path to partnership Join multiple established primary care sports medicine physicians within the orthopedic department. This is a full-time position combining sports medicine, musculoskeletal medicine,... 

Delta-T Group Inc.

Staff Accountant / Bookkeeper Job at Delta-T Group Inc.

 ...Category: Accounting Education: Bachelor's Degree Delta-T Group is a nationwide provider of services to the social services, special-education,...  ...people and our processes. We aim to deliver high quality customer service for the betterment of those needing care and... 

Get It - Marketing

Insurance Account Representative - State Farm Agent Team Member - Remote Job at Get It - Marketing

 .... Remote Flexibility: Enjoy the freedom and flexibility of working from anywhere within Michigan. Growth Opportunities: Advance...  ...Sales Experience: 2+ years of full-time experience in a State Farm agency is required. Strong Insurance Knowledge: Basic insurance... 

Maximum Realty One

Real Estate Sales Agent Job at Maximum Realty One

An experienced Real Estate Agent with 0 to 3 years of experience. Bachelors Degree Required. Commercial Real Estate experience is an okay. Must have knowledge of reporting so that the corporate office can send it to CRM. Computers Skills an A plus . Real Estate Terminology...

FEMA

Local digital communications specialist Job at FEMA

 ...day increments, based on the needs of the disaster. Requirements Conditions of Employment To ensure the accomplishment of our mission, DHS requires every employee to be reliable and trustworthy. To meet those standards, all selected applicants must undergo, successfully...