Sample ODI Developer Resume
Professional Summary:
- Around 7+ years of experience in Architecture, Analysis, Design, Development, Testing, Support and user training of Data Warehousing and Business Intelligence applications using ODI and Oracle Applications.
- Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
- Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
- Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
- Experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
- Extensively worked with large Databases in Development, Testing and Production environments.
- Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
- Strong working experience with Data migration and Data integration projects
- Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing
- Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
- Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
- Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
- Expertise in creating stored procedures, functions, packages, triggers, collections and bulk collections using PL/SQL.
- Experience with Oracle DML and DDL scripting.
- Experience in planning space allocation, partitioning, creating and managing table spaces.
- Expert in installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
- Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
- Experience with Application development in an Oracle Environment, Data Modeling / Relational Database Design
- Strong experience with data transfers and data sharing using flat files, database links, and web services
- Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-Ã -vis new technology.
Technology Proficiency
|
Database
|
Oracle /8i/9i/10g/11g, MS SQL Server 2000/2005/2008, Teradata, IBM DB2
|
|
ETL Tools
|
ODI 12c, ODI 11g, ODI 10g, Informatica Power Center 9.5/9.0/8.x/7.x/6.x, SSIS
|
|
Database Skills
|
Cursors, Stored Procedures, Functions, Views, Triggers, Packages, SQL Optimization
|
|
Operating Systems
|
Windows 2000/2003/XP/Vista/Windows 7, UNIX/Solaris, Red Hat Linux
|
|
Languages & Utilities
|
SQL, PL/SQL, Linux, UNIX shell scripts
|
|
Database Tools
|
Toad, AutoSys, TPump, Fast Load, Sql Developer, SQL Loader
|
|
Others
|
Oracle Hyperion, Cognos, Autosys, Oracle Web Services, Tidal, Microsoft Office
|
Professional Experience:
Genuine Parts, Atlanta, GA Feb 2015 - Till Date
ODI Developer
Description: Genuine Parts Company (GPC) is a service organization engaged in the distribution of automotive replacement parts, industrial replacement parts, office products and electrical/electronic materials. Our products and services are offered through a network of over 2, 000 operations, geographically located across the United States, Canada and Mexico.
Responsibilities:
· Gathered ELT requirements from Business team and designed its high level and low level technical documents.
· Involved with the ODI Integrator Development and Understood Source systems attributes and come up with gap analysis and target system attributes mapping
· Implemented Advance interfaces to integrate data from JDE and Accustart systems and loaded them into staging tables.
· Comprehensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
· Creating/Building and Running Sessions/Workflows and Worklets using the Workflow Manager/ Workflow Monitor in Informatica.
· Designed and implemented proper error handling procedures
· Prepared and maintained technical documentation for all new or modified Repository objects and ETL Mapping
· Involved in designing of Star Schema based data model with dimensions and facts
· Participated in designing, creating and implementing physical databases from relational and dimensional logical data models as per need
· Designed and conducted unit tests for new or changed repository objects and ETL mappings
· Extensive experience in Performance Tuning where I need to Identify and fix bottlenecks and tune the complex Informatica mappings for better performance
· Responsible for creating staging area through Informatica tool
· Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implemented PL/SQL packages as steps in ODI Procedures.
· Created staging, dimensions and fact loading ODI packages
· Wrote unit test case to test ODI packages
· Designed end-to-end ELT process flow and implemented it using ODI packages.
· Experience in Oracle DML and DDL Scripts.
· Implemented Shell Script to purge operator logs.
· Implemented complex ELT logics using Yellow Interfaces.
· Created static and dynamic variables and used them as declare, set, evaluates and refresh types.
· Implemented ODI procedures to execute pre and post process commands such as disable and enable Indexes.
· Implemented Success and Failure Notifications into ODI Packages.
· Involved in UAT with business and reporting team to make sure that the ODI processes populating correct data
· Analysis of data issue reported by business team and provided its resolutions
· Analyzed current ODI packages and provided suggestion for performance improvement.
· Participated in daily stand up meeting to give update on project tasks.
Environment: Oracle 11g, ODI 11g, TOAD, PL/SQL, DB2, JDE, SQL Loader, Microsoft SQL Server, Unix
PNC Bank, Cleveland OH Nov 2013 - Jan 2015
ODI Developer
Description: PNC Financial Services Group, Inc. (PNC) is an American financial services corporation (headquartered in Pittsburgh, PA). PNC operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia (also offering online and mobile services), specialized financial businesses serving companies and government entities, and asset management and processing businesses. PNC offers a wide range of financial services such as tailored investments, wealth planning, trust, risk management and estate administration and private banking services for customers, from individuals and small businesses, to corporations and government entities. PNC is the #2 syndicator of middle market loan transactions in the United States.
Responsibilities:
· Assess the system requirement for Oracle Data Integrator (ODI) software Installation as per Oracle guidance.
· Gathered ELT requirements from Business team and designed its high level documents.
· Installed and configured the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings.
· Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
· Configured ODI Agents on Windows server and tested them to execute and schedule ODI Scenarios.
· Setup Security for accessing ODI s/w by creating groups and users into Security Manager.
· Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.
· Involved in planning of Upgrading ODI s/w from 10g to 11g versions.
· Installed and configured ODI 12c on windows environments.
· Created and configured ODI 12c Agent and Installed it as a window services.
· Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and Implemented ODI 12c mapping to load multiple target tables.
· Created and Implemented physical databases from relational and dimensional logical data models
· Debug the mappings using debugger to resolve code issue.
· Used RCC (Repository consistency check) utility to check consistency of both master and work repositories before doing upgrade
· Analyzed Repositories consistency issues from RCC logs and resolved it to make repositories consistence.
· Resolved Upgrade issues occurred during upgrade assistant utility run.
· Wrote PL/SQL overloading stored procedures, functions, packages and package constructors to enforce business rules.
· Wrote Oracle DML and DDL Scripts and Created control file scripts and used SQL Loader to load data into the staging table.
· Involved in Dimensional Modeling such as star schema, snowflake schema, creating Facts, Dimensions and Measures.
· Worked with data transfers and data sharing using heterogeneous data sources like database links, flat file and web services.
· Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
· Export/Import interfaces, packages and its scenarios across different environments.
· Implemented Interfaces for loading Source data into Staging area and Staging data into Dimension and Fact tables of Reporting Data mart.
· Designed end to end ELT process flow and implemented it using ODI packages.
· Implemented Shell Script to purge operator logs and Implemented complex ELT logics using Yellow Interfaces.
· Created static and dynamic variables and used them as declare, set, evaluates and refresh types.
· Implemented ODI procedures to execute pre and post process commands such as disable and enable Indexes.
· Implemented Success and Failure Notifications into ODI Packages.
· Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
· Performed unit and system testing of ELT Packages.
· Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using the agent. These scenarios are finally deployed to production.
· Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
Environment: Oracle 11g, ODI 10g, ODI 11g, ODI 12c, SQL Loader, SQL Developer, TOAD, PL/SQL, DB2
Matrix Healthcare, Phoenix, AZ May 2012 - Oct 2013
Informatica Developer
Description: Matrix medical network is a health care organization which was composed with more than 400+ nurse practitioners. Nurses are currently providing health care services by going home and they also do the schedule visits to providing the right health care services
Responsibilities:
· Extracted structured and unstructured data from source systems, transforming them to fit dimensional models. Data source formats include relational databases, flat files and non-relational structures such as XML
· ODI and configured according to the business requirement.
· Drafted the Technical specification documents along with the architecture diagram in Visio.
· Helped the mainframe team to pull out data from IMS database to flat file.
· Designed the target tables according to the requirement with the Siebel team.
· Data converted from mainframe to Siebel, one time load of data.
· Created Master and Work Repository and developed the ODI mappings.
· Used Topology Manager to define data servers and physical schemas for source and target databases.
· Used ODI Designer to develop complex interfaces to load the data from the various sources into dimensions and facts.
· Implemented and enhanced different Knowledge Modules in mappings for loading and integrating the data from sources to targets.
· Used Siebel Knowledge Module as the target was Siebel.
· Used Security to control privileges and responsibilities for different users.
· Documenting all new and modified mappings according to standards as part of the Data Operations documentation.
· Debug the sessions by utilizing the logs of the sessions.
· Created ODI agent and monitored the daily update loads.
· Performed unit testing at various levels of the ELT experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
· Working closely with Informatica team for performing mapping and data loading which is same as ODI tool.
· Experience in increasing efficiency of data load from source to target by doing performance tuning.
· Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository
Environment: Oracle Data Integrator (ODI)11g , Informatica 9.0.1/8.6.1, SQL server 2008, Oracle 10g/11g, SQL, PL/SQL, DB2, Erwin, UNIX, Windows XP
Northwestern Mutual, WI June 2010 – April 2012
ODI and PL/SQL Developer
Description: Northwestern Mutual is the nation's largest direct provider of individual life insurance, Long-term care insurance, disability insurance and employee benefit services. it offers one of the most technologically advanced processes for quoting and issuing insurance policies
Responsibilities:
· Designed ETL processes by leveraging SQL scripting and Enterprise Data Integration tools
· Installed and configured ODI 10g into DEV and PROD environments
· Created ODI jobs to replicate the existing process of Shell scripts and SQL scripts
· Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target
· Created ODI Package of various complexity and automated process data flow
· Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment
· Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same.
· Created Topology connection for reading xml logs and writing into oracle db.
· Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
· Created ODI Interfaces to load data into ODS for downstream systems.
· Created ODI Interfaces to load data into dimension and fact tables for traffic and billing data mart.
· Used IKM, LKM, JKM & CKM knowledge modules to create ODI Jobs for data loading.
· Created packages and it's scenario to automate loading jobs.
· Created Shell scripts to archive source files in the server
· Used ODI to build performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
· Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
· Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
Environment: Oracle 10g, ODI 10g/11g, PL/SQL, Informatica 9.0.1/8.6.1, Business Objects, SQL server 2008, Oracle 10g/11g, SQL, PL/SQL, DB2, Erwin, UNIX, Windows XP, TOAD, SQL*Loader, SQL, UNIX shell scripting.
CMC, hyderabad, india March 2008 to June 2010
ODI and PL/SQL Developer
Description: CMC is a leading IT solutions company and a subsidiary of Tata Consultancy Services Limited. Customer Services (CS) is one of the strategic business unit (SBU) in CMC which will handles the business-critical IT needs of large and medium corporate organizations in India and abroad. CMC offer customized services in the areas of hardware, software support, environmental engineering, networking projects and turnkey projects, including equipment supply, installation, and commissioning and facilities management. CMC also provide consultancy services for various information technologies.
Responsibilities:
· Responsible for data modeling using Erwin, Star Schema Modeling and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
· Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
· Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
· Created the users, profiles using the ODI security manager.
· Implemented CDC through ODI Journalization Knowledge Modules.
· Extensively worked and utilized ODI Knowledge Modules (Reverse Engineering, Loading, Integration, Check, Journalizing and service)
· Created various procedures and variables.
· Created ODI Packages, Jobs of various complexities and automated process data flow
· Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment.
· Prepared project plan with deliverables and time lines.
· Created the tables and sequences for the experimental data load capture.
· Extracted the data from Iron Port SFDC database by using Data Loader into the Excel.
· Used the Bulk binding techniques for query optimization.
· Created indexes on tables and optimized procedure queries.
· Created PLSQL procedure, to validate the data.
· Created PLSQL procedure, used the DBMS_SCHEDULER for automatic weakly sending emails to the users.
· Developed Excel Report using the procedural code.
· Experience in using Informatica ETL Tool.
· Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
· Effort also included development of stored procedures.
· Handled Production issues with high pace and efficiency.
· Created Mappings, Map-let designing, Work Flows, tasks and sessions.
· Optimized existing queries for better performance and less impact on database and used Materialized views in places where the data does not change very frequently.
Environment: Oracle 10g/9i, PL/SQL, SQL*Plus, SQL developer, TOAD, Serena Dimensions.
