Search by job, company or skills

Vinirma Consulting Private Limited

Senior Oracle Data Integrator (ODI) ETL Developer

Early Applicant
Quick Apply
  • Posted 2 days ago
  • Be among the first 30 applicants
5-15 Years
INR 1 - 14 LPA

Information Technology

Job Description

VAM Systemsis a Business Consulting, IT Solutions and Servicescompany.

VAM Systems is currently looking for Senior Oracle Data Integrator (ODI) ETL Developer for our UAE operations with the following skillsets & terms and conditions:

Educational Background

Bachelor's or Master's Degree in:

Computer Science

Information Technology

Data Science

Business Intelligence

Related disciplines

Experience and Professional Expertise

  • 5+ years of hands-on experience in developing and managing ETL/ELT processes using ODI.
  • Proven experience in implementing large-scale, end-to-end data integration projects, including:
  • Requirements gathering
  • Data modeling
  • Designing scalable ETL/ELT solutions.
  • Experience in upgrading or migrating ODI environments (e.g., from ODI 11g to 12c).

Certifications (Optional but Advantageous)

  • Oracle Data Integrator (ODI) Certification
  • Oracle Database SQL Certified Associate
  • Certifications in data integration or related tools (e.g., Informatica, Talend) as complementary skills.

Technical Expertise

Core Expertise in Oracle Data Integrator (ODI):

  • Proficiency in designing and implementing data integration solutions using ODI 12c or later versions.
  • Strong knowledge of:
  • Knowledge Modules (KM): Creating and customizing reusable components for data integration processes.
  • Mappings, Packages, and Scenarios: Designing complex data flows, workflows, and automating ETL processes.
  • Topology Configuration: Configuring physical and logical schemas, data servers, and agents.
  • Expertise in ODI's ELT framework and knowledge of performance optimization techniques.
  • Experience in error handling, reconciliation frameworks, and debugging ODI processes.

Database Skills:

  • Strong SQL and PL/SQL skills for querying, transforming, and managing data.
  • Deep knowledge of Oracle Database concepts, including:
  • Indexing, partitioning, and materialized views.
  • Query optimization techniques.
  • Familiarity with other databases like SQL Server, MySQL, or PostgreSQL is advantageous.

Data Warehousing and ETL Concepts:

  • In-depth understanding of:
  • Dimensional modeling (Star and Snowflake schemas).
  • Fact and dimension tables, surrogate keys, slowly changing dimensions (SCDs), and hierarchies.
  • Data profiling, data cleansing, and data validation practices.
  • Hands-on experience in building and maintaining data warehouses and data lakes.

Integration and Data Sources:

  • Experience with integrating various types of data sources, such as:
  • Relational databases (Oracle, SQL Server, etc.)
  • Flat files (CSV, XML, JSON)
  • APIs for real-time data integration.
  • Familiarity with Big Data integration using ODI (e.g., Hadoop, Spark, Hive).

Cloud and Modern Technologies (Optional but Beneficial):

  • Experience with Oracle Cloud Infrastructure (OCI) and Autonomous Data Warehouse (ADW).
  • Knowledge of ODI Marketplace for hybrid and cloud-based deployments.

Integration with cloud data platforms like AWS, Azure, or Google BigQuery

Soft Skills and Leadership

  • Analytical Skills: Ability to understand complex data models and business requirements.
  • Problem-Solving Skills: Debugging data integration issues and optimizing performance.
  • Communication Skills: Effective in working with business stakeholders and translating their needs into technical solutions.
  • Project Leadership: Leading ETL development efforts, mentoring junior developers, and collaborating with cross-functional teams.

Additional Skills

Performance Optimization:

  • Optimizing ETL workflows to handle high-volume data efficiently.
  • Implementing ODI-specific performance enhancements like parallelism, bulk-loading, and tuning knowledge modules.

Scripting and Automation:

  • Scripting skills in Python, Bash, or Shell for task automation.
  • Familiarity with scheduling tools (e.g., Oracle Enterprise Scheduler, Cron jobs).

Security and Compliance:

  • Experience in securing data integration workflows using ODI's security features.
  • Knowledge of compliance frameworks such as GDPR, HIPAA, or CCPA.

Business Acumen

  • Familiarity with business intelligence tools (e.g., Oracle Analytics Server, Tableau, or Power BI) to ensure data readiness for reporting.
  • Understanding of industry-specific data requirements (e.g., financial, healthcare, or retail sectors).

Key Traits for Success

  • Proactive in keeping up with emerging trends in data integration and ELT methodologies.
  • Passion for problem-solving and building scalable, reliable data pipelines.
  • Strong commitment to delivering high-quality solutions that align with organizational goals.

Terms and conditions

Joining time frame: (15 - 30 days)

The selected candidates shall join VAM Systems UAEand shall be deputed to one of the leading Banks inUAE.

Should yoube interested in this opportunity, please send your latest resume at the earliest at [HIDDEN TEXT]

Skills Required

Login to check your skill match score

Login

Date Posted: 21/11/2024

Job ID: 101015845

Report Job

About Company

About Us:
Vinirma Consulting is a business consulting and technology service provider. We focus on fostering partnerships with clients in transforming them in to most effective and profitable organizations. Domain and global best industry practices knowledge coupled with insight into the emerging but practical technology enables us to deliver the dependable solutions and services.

Vinirma’s corporate objective is to assist its clients to focus on respective core competence to remain competent and profitable organizations.

For more details please visit our website
@ http://www.vinirma.com/index-11.html

User Avatar
0 Active Jobs
41 Followers
Follow

Hi , want to stand out? Get your resume crafted by experts.

Last Updated: 12-03-2025 06:42:27 AM
Home Jobs in United Arab Emirates Senior Oracle Data Integrator (ODI) ETL Developer