ODI Developer Resume Samples

An ODI Developer is an Oracle Data Integrator Lead Developer who has wide experience in analyzing, designing, and developing the implementation of BI solutions using OBIEE and Siebel Analytics. Some of the core tasks and responsibilities associated to the role are listed on the ODI  Developer Resume as follows – supporting and administrating database software systems; planning and administering database systems including documentation process, providing database expertise to the software development team, developing cross-validation rules and ensuring mapping accuracy; taking responsibility for defining and monitoring all application support activities, and making effective recommendations and coding writings.

Summary of skills that can highlight a resume includes the following – experience with process documentation and process documentation tools; strong SQL and stores procedure experience; strong analytical and data analysis skills; familiarity with Java, MS Office Suite, project management skills; and familiarity with Java, and Windows Server Applications. An IT or Computer Science degree is commonplace among job applicants.

 

ODI Developer Resume example

Odi Developer Resume

Headline : As a Business Oriented Professional with 7+ years dedicated to full life cycle IT development, expertise includes Integration Analyst, Oracle Data Integrator (ODI) (Data Integration), ETL Developer, OBIEE Developer, PL/SQL developer and Data Warehouse Analyst with substantial experience in Financial and Supply Chain Management system.

Skills : ETL Developer, OBIEE Developer.

Description :

    1. Diversified financial services holding company with subsidiaries engaged primarily in investment and financial planning, in addition to investment banking and asset management.
    2. Categorized in multiple financial and other projects to extract data from multiple source system to oracle for business to query consolidate data for OBIEE ad hoc reports and analytical dashboards purpose.
    3. Responsible for Migration and conversion included in the project in order to eliminate cost and issues related to Microsoft Dynamics CRM.
    4. Gathered business requirement and prepared mapping specs.
    5. Installed ODI 12C on client and remote machine.
    6. Configured physical and logical topology.
    7. Worked on LKM (File to sql, sql to sql), IKM (Oracle global insert, Oracle incremental update), CKM (CKM oracle), RKM (Standard).
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science


Sr. Odi Developer Resume

Summary : 7+ years of experience in Analysis, Design, Development, Administration, Testing, Support and user training of Data Warehousing using ODI, Oracle Applications. Excellent experience in Dimensional Data modelling using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modelling. Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).

Skills : Data Warehousing, Testing.

Description :

    1. Modeled the data structure of the target warehouse to store the required information.
    2. Populated the indicators by implementing business rules Measuring the overall accuracy of the data by setting up data quality rules.
    3. Designed, developed ODI (Oracle Data Integrator) (Data Integration) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
    4. Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files(.txt, .csv, .xlxs) into oracle database.
    5. Created reusable mappings to implement in main mappings.
    6. Developed complete specifications for required ETLmappings.
    7. Worked closely with Business Analyst in understanding the Analytical requirements and generated reports as per the user specifications.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Science


Jr. Odi Developer Resume

Summary : Solid understanding of Relation database design and developed various data model-using Designer. Five years of hands-on experience using Oracle Data Integrator (ODI).

Skills : Administration, Testing.

Description :

    1. Expertised on database design.
    2. Created data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the DB.
    3. Created master and work repositories for ODI by coordinating with Oracle DBAs.
    4. Developed Mapping for multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
    5. Assisted Data Architect in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
    6. Analyzed the Business requirement for Oracle Data Integratorand mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
    7. Documented each and every detail that is implemented in ODI objects such as interfaces, procedures, variables, packages.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Science

Asst. Odi Developer Resume

Headline : As a Business Oriented Professional with 7+ years dedicated to full life cycle IT development, expertise includes Integration Analyst, Oracle Data Integrator (ODI) (Data Integration), ETL Developer, OBIEE Developer, PL/SQL developer and Data Warehouse Analyst with substantial experience in Financial and Supply Chain Management system.

Skills : ETL Developer, OBIEE Developer, PL/SQL developer.

Description :

    1. Performed environment migrations between the Development, Quality Assurance, and Production environments.
    2. Implemented Data-level security and Object-level Dashboards/Reports security among users, groups and web-groups.
    3. Worked on ODI Designer to create Mappings, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target.
    4. Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
    5. Implemented data transformation strategies by using LKM, RKM, IKM, CKM and JKM Knowledge modules.
    6. Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse (EDW).
    7. Developed complete specifications for required ETL mappings.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

Associate Odi Developer Resume

Objective : 8+ years of IT Industry experience in Data warehousing with ODI ,OBIEE And SQL PLSQ 4+ years of experience in OBIEE which includes building and creating repository (RPD), creating and managing the Oracle Intelligence Dashboards, Answers and creating Delivers and iBots. Worked in an Environment with Oracle DRM (Data Relationship Management) Expertise in documenting the client and technical information in a timely and well-organized manner.

Skills : ODI ,OBIEE And SQL PLSQ.

Description :

    1. Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data Sources/targets.
    2. Performed the unit testing, system integration testing and assist with user acceptance testing Documented the ETL detailed design and test results.
    3. Created and maintained integration process using ODI and load rules.
    4. Liaisoned with Oracle support for Service Requests (SRs) and resolution of any issues.
    5. Documented new requirements, recommended and implement solution.
    6. Coordinated testing and changes to the application.
    7. Ensured data quality throughout entire ETL procedure.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Technology In Computer Science

Odi Developer III Resume

Objective : With around 7 years of experience as a dedicated Business Oriented Professional, worked as Oracle PL/SQL Developer using the Oracle Relational Database Management System (RDBMS), Integration Analyst, Oracle Data Integrator (ODI)12c,11g, Informatica 9x/8x, Oracle Business Intelligence (OBIEE)12c/11g, Experience in Data Modeling, OLAP, ETL Design and involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in ETL process using ODI, with timely delivery against aggressive deadlines.

Skills : Oracle PL/SQL Developer, Database Management.

Description :

    1. Involved in Business Analytical activities like Migration, Testing, User Training and Production Support.
    2. Extensively used filter, update, lookup, expression, router and sequence generator transformations.
    3. Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
    4. Created workflows for the Initial load and refresh load.
    5. Played a crucial role in assigning to developers.
    6. Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer(design of hierarchies, dimensions, and aggregates) by defining appropriate joins, calculations, dimensions and measures in the repository.
    7. Developed technical understanding of the application, as well as, an understanding of how the business uses this information and the data flows from system to system in order to define and execute cross-functional data movements for business intelligence.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
B.CA

Odi Developer II Resume

Headline : 7+ years of total IT experience and strong background in Data Modeling, OLAP, ETL Design, Analysis, Development, Testing, Performance Tuning, Troubleshooting and error handling in the field of Data Warehousing in ETL process using ODI Experience with the entire Software Development Life Cycle SDLC viz.

Skills : Design, Analysis, Development, Testing.

Description :

    1. Performed Unit, Integration, and Regression testing to validate report.
    2. Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
    3. Worked with multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
    4. Worked on ODI Designer to create Interfaces, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target.
    5. Performed Query optimization, debugging, and performance tuning for improving performance.
    6. Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
    7. Developed and maintained project plans to manage scope and estimated delivery schedules on the project.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Science

Odi Developer I Resume

Objective : 10+ years of professional experience in Oracle Data Integrator (ODI) working on all phases of development life-cycle, from gathering requirements to testing, implementation and support Extensive SQL Development experience in Health, Banking, Insurance, Financial industries with a strong understanding of data & analytics.

Skills : Developer, Leadership.

Description :

    1. Created a utility to take the daily backups of the repositories.
    2. Engaged primarily in investment and financial planning, in addition to investment banking and asset management.
    3. Categorized in multiple financial and other projects to extract data from multiple source system to oracle for business to query consolidate data for OBIEE ad hoc reports and analytical dashboards purpose.
    4. Gathered business requirement and prepared mapping specs.
    5. Installed ODI 12C on client and remote machine.
    6. Configured physical and logical topology.
    7. Reversed engineered source and target models.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Masters In Computer Applications

Lead Odi Developer Resume

Objective : Extensive development experience for the Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server, DB2, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems Good experience in handling interfaces and implementing complex business rules.

Skills : Developer, Leadership.

Description :

    1. Understood organizations business requirements and functionality.
    2. Interacted with client for appropriate requirement specifications.
    3. Experienced with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
    4. Modeled the data structure of the target warehouse to store the required information.
    5. Measured the overall accuracy of the data by setting up data quality rules.
    6. Designed, developed ODI (Oracle Data Integrator) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
    7. Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science

Odi Developer Resume

Objective : As a Business Oriented Professional with over 8+ years dedicated to full life cycle IT development, expertise includes Integration Analyst, Oracle ETL Developer, Data Warehouse Analyst. Involved in wide variety of Data Integration projects using technologies and applications such as, Hyperion Essbase/Planning, OBIA with substantial experience in Telecom, Automobile, Healthcare(EPIC),Manufacture and Distribution .

Skills : Analyst, Oracle ETL Developer.

Description :

    1. Designed and developed table structures, stored procedures and functions to implement business rules.
    2. Generated PL/SQL and Shell scripts for scheduling periodic load processes.
    3. Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL.
    4. Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
    5. Designed and developed complex Interfaces using oracle data integrator (ODI) that involved Slowly Changing Dimensions, Error handling, SCD types, Golden gate Change Data Capture and Business logic implementation.
    6. Created ODI design documents from the existing Informatica mappings.
    7. Created projects and interfaces to load metadata and data into the Hyperion Planning applications using both Planning and Essbase Knowledge Modules (KMs) in Oracle Data Integrator (ODI, formerly known as Sunopsis).
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
MS In Computer Science