ODI Developer/ Lead

5 days ago

Bengaluru, Karnataka, India Oracle Full time ₹ 20,00,000 - ₹ 25,00,000 per year
Job Description:Responsibilities:
  • Minimum 4-5 years hands-on, end to end DWH Implementation experience using ODI.
  • Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
  • Expertise in the Oracle ODI tool set and Oracle PL/SQL,ODI
  • knowledge of ODI Master and work repository
  • Knowledge of data modelling and ETL design
  • Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
  • Packaging components, database operations like Aggregate pivot, union etc.
  • using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • Experience of performance tuning of mappings
  • Ability to design ETL unit test cases and debug ETL Mappings
  • Expertise in developing Load Plans, Scheduling Jobs
  • Ability to design data quality and reconciliation framework using ODI
  • Integrate ODI with multiple Source / Target
  • Experience on Error recycling / management using ODI,PL/SQL
  • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
  • Experience of creating PL/SQL packages, procedures, Functions , Triggers, views, Mat Views and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
  • Experience in Data Migration using Sql loader, import/export
  • Experience in SQL tuning and optimization using explain plan and Sql trace files.
  • Strong knowledge of ELT/ETL concepts, design and coding
  • Partitioning and Indexing strategy for optimal performance
  • Must have Good verbal and written communication in English, and good interpersonal, analytical and problem-solving abilities.
  • Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.
  • Experience in understanding sophisticated source system data structures preferably in Financial services (preferred) Industry
  • Ability to work with minimal guidance or supervision in a time critical environment.
  • Work with Oracle's world class technology to develop, implement, and support Oracle's global infrastructure.
  • As a member of the IT organization, assist with the design, development, modifications, debugging, and evaluation of programs for use in internal systems within a specific function area.
  • Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. BS or equivalent experience in programming on enterprise or department servers or systems.
Qualifications:About Us:

Oracle

  • ODI Developer

    1 week ago

    Bengaluru, Karnataka, India Systechcorp Inc Full time ₹ 10,40,000 - ₹ 26,00,000 per year

    Role: ODI DeveloperExperience: 7+yrsNotice period: Only 15-30daysLocation: BangalorePackage: 13LPA maxWe are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator (ODI), Oracle Analytics...

  • ODI Developer

    3 days ago

    Bengaluru, Karnataka, India Vinncraft Software Pvt Ltd Full time ₹ 1,80,000 - ₹ 8,32,00,000 per year

    . Job description5+ Yrs. in-depth hands-on experience in developing ETL/ELT interfaces in Oracle Data Integrator (ODI) 11g.Develop medium to complex ODI interfaces and using various transformation packages and knowledge modules.Ability to diagnose and debug data reconciliation issues and identify fix.Migrate and deploy Code to multiple environments.Create...

  • ODI Developer

    5 days ago

    Bengaluru, Karnataka, India SysTechCorp Inc Full time ₹ 10,00,000 - ₹ 13,00,000 per year

    Role : ODI Developer.Experience : 7+yrs.Notice period : Only 15-30days.Location : Bangalore.Package : 13LPA max. We are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator...

  • ODI Developer with PLSQl

    1 week ago

    Bengaluru, Karnataka, India Systechcorp Inc Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role & responsibilitiesODI Developer with PLSQLPreferred candidate profileJob Description: Job Summary:We are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator (ODI), Oracle Analytics...

  • ODI Developer

    4 weeks ago

    Bengaluru, Karnataka, India iNetFrame Technologies Private Limited Full time

    Job Title : ODI DeveloperExperience : 5+ YearsLocation : Bengaluru.Required Skills : - Strong hands-on experience with Oracle Data Integrator (ODI).- Proficient in data modeling and relational database design.- Demonstrated expertise in Oracle Analytics Cloud (OAC).- Advanced PL/SQL programming and performance tuning skills.- Solid understanding of data...

  • ODI developer

    3 days ago

    Bengaluru, Karnataka, India Rapidcloud Systems and Solutions Private Limited Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    We are looking for a highly skilledData Integration Specialistwith a minimum of 5 years of hands-on experience in designing and implementing robust data solutions usingOracle Data Integrator (ODI). The ideal candidate will possess deep expertise indata modeling,ETL/ELT development, andSQL, complemented by practical exposure toPython scriptingforAPI-driven...

  • ODI Consultant

    3 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Skill: ODI ConsultantYears of experience :3+ YearsLocation: Pan India (LTIMindtree office)Technical RequirementTools and Technology ODI 12c and ORACLE database 12c Additional Skills Snowflake and DBTJob description1. Design interfaces packages and load plans in ODI 12c2. Ensure correctness and completeness of Data loading Full load Incremental load3....

  • ODI Consultant

    3 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Skill: ODI Consultant Years of experience :3+ Years Location: Pan India (LTIMindtree office) Technical Requirement Tools and Technology ODI 12c and ORACLE database 12c Additional Skills Snowflake and DBT Job description Design interfaces packages and load plans in ODI 12c Ensure correctness and completeness of Data loading Full load Incremental...

  • ETL ODI developer

    1 day ago

    Bengaluru, Karnataka, India Addnectar Solutions Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    END client of AddnectarShift: 9PM IST to 6 AM ISTRequirementsWe are seeking a skilled and experienced Data Integration Specialist with over 5 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, and SQL, along with exposure to...

  • Principal Consultant

    3 weeks ago

    Bengaluru, Karnataka, India Oracle Full time

    Job DescriptionJob Description: Senior ODI Developer (OCI PaaS/IaaS Expertise)Role Overview:We are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL, PL/SQL, and Oracle Data Integrator (ODI) projects, particularly on OCI (Oracle Cloud Infrastructure) PaaS or IaaS platforms. The ideal candidate will design, implement, and...