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.
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 :
Diversified financial services holding company with subsidiaries engaged primarily in investment and financial planning, in addition to investment banking and asset management.
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.
Responsible for Migration and conversion included in the project in order to eliminate cost and issues related to Microsoft Dynamics CRM.
Gathered business requirement and prepared mapping specs.
Installed ODI 12C on client and remote machine.
Configured physical and logical topology.
Worked on LKM (File to sql, sql to sql), IKM (Oracle global insert, Oracle incremental update), CKM (CKM oracle), RKM (Standard).
Experience
5-7 Years
Level
Executive
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 modeling using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling. 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 :
Modeled the data structure of the target warehouse to store the required information.
Populated the indicators by implementing business rules Measuring the overall accuracy of the data by setting up data quality rules.
Designed, developed ODI (Oracle Data Integrator) (Data Integration) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files(.txt, .csv, .xlxs) into oracle database.
Created reusable mappings to implement in main mappings.
Developed complete specifications for required ETLmappings.
Worked closely with Business Analyst in understanding the Analytical requirements and generated reports as per the user specifications.
Experience
7-10 Years
Level
Management
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 :
Expertised on database design.
Created data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the DB.
Created master and work repositories for ODI by coordinating with Oracle DBAs.
Developed Mapping for multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
Assisted Data Architect in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
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.
Documented each and every detail that is implemented in ODI objects such as interfaces, procedures, variables, packages.
Experience
10+ Years
Level
Senior
Education
Bachelor Of Science
Odi Developer Resume
Headline : To establish a long-term career in a company where I may utilize my Odi Developer professional skills and knowledge to be an effective Associate Program Manager and inspiration to those around me.
Skills : OBIEE Developer, PL/SQL developer.
Description :
Performed environment migrations between the Development, Quality Assurance, and Production environments.
Implemented Data-level security and Object-level Dashboards/Reports security among users, groups and web-groups.
Worked on ODI Designer to create Mappings, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target.
Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
Implemented data transformation strategies by using LKM, RKM, IKM, CKM and JKM Knowledge modules.
Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse (EDW).
Developed complete specifications for required ETL mappings.
Experience
5-7 Years
Level
Executive
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 its. 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 :
Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data Sources/targets.
Performed the unit testing, system integration testing and assist with user acceptance testing Documented the ETL detailed design and test results.
Created and maintained integration process using ODI and load rules.
Liaisoned with Oracle support for Service Requests (SRs) and resolution of any issues.
Documented new requirements, recommended and implement solution.
Coordinated testing and changes to the application.
Ensured data quality throughout entire ETL procedure.
Experience
2-5 Years
Level
Junior
Education
Bachelor Of Technology
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.
Involved in Business Analytical activities like Migration, Testing, User Training and Production Support.
Extensively used filter, update, lookup, expression, router and sequence generator transformations.
Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
Created workflows for the Initial load and refresh load.
Played a crucial role in assigning to developers.
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.
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.
Experience
2-5 Years
Level
Junior
Education
B.CA
Odi Developer II Resume
Headline : 7+ years of total IT experience and a 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 :
Performed Unit, Integration, and Regression testing to validate report.
Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
Worked with multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
Worked on ODI Designer to create Interfaces, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target.
Performed Query optimization, debugging, and performance tuning for improving performance.
Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
Developed and maintained project plans to manage scope and estimated delivery schedules on the project.
Experience
5-7 Years
Level
Executive
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 :
Created a utility to take the daily backups of the repositories.
Engaged primarily in investment and financial planning, in addition to investment banking and asset management.
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.
Gathered business requirement and prepared mapping specs.
Installed ODI 12C on client and remote machine.
Configured physical and logical topology.
Reversed engineered source and target models.
Experience
2-5 Years
Level
Junior
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 :
Understood organizations business requirements and functionality.
Interacted with client for appropriate requirement specifications.
Experienced with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Modeled the data structure of the target warehouse to store the required information.
Measured the overall accuracy of the data by setting up data quality rules.
Designed, developed ODI (Oracle Data Integrator) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.
Experience
2-5 Years
Level
Junior
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 a 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 :
Designed and developed table structures, stored procedures and functions to implement business rules.
Generated PL/SQL and Shell scripts for scheduling periodic load processes.
Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL.
Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
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.
Created ODI design documents from the existing Informatica mappings.
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).
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.
