We provide IT Staff Augmentation Services!

Sr Dw Odi Developer Resume

Jersey City New, JerseY


  • 8+ years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Relational Data Modeling, Designing, Coding, Development, Testing and Implementation of Business applications with RDBMS, Data Warehouse/Datamarts, ETL, OLAP, Client/Server environment applications in Financial Services, Healthcare, and Insurance industries
  • Focused experience in Data Warehousing and ETL using ODI 11g & 10g, OWB 11gR2/R1, 10g, 9i, Oracle 11g/10g/9i, SQL, PL/SQL, and Shell Scripting
  • 7+ years of experience working on End - To-End implementation of Data warehouses.
  • Strong understanding of Data warehouse concepts, ETL, Star Schema
  • Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, Physical & logical data modeling
  • Exposure to Business Intelligence tools Business Objects and OBIEE
  • Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
  • Profound experience in performing all functions of System Development Life Cycle including writing Design documents and Test plans and conduct Unit and System testing.


Data Warehousing: ODI & OWB ;Oracle DB 11g/10g/9i/8i; SQL, PL/SQL, Shell Scripting, Stored Procedures

Dimensional Data Modeling: Erwin, Oracle Designer and Visio

Data Profiling: Trillium, Firstlogic

Business Intelligence: Business Objects, OBIEE

Programming: SQL, PL/SQL, HTML, Unix Shell Scripting.

Databases: Oracle 11g/10g/9i/8i, Exadata, MS SQL Server 2005/2008, MS Access


Confidential, Jersey City, New Jersey

SR DW ODI Developer


  • Gathering and analyzing business requirements: Interacting with business owners, SMEs, and users to gather requirements to drive the creation of DW solution
  • Creating ODI packages and interfaces to load ODS and DWH/EDW tables
  • Translating business process diagrams, UMLs into ODI packages and load plans
  • Designing and implementing ODI process flow from source to staging to Operational Data Store to Data Warehouse
  • Upgrading ODI 10.1.6 to
  • Customizing CKMs, LKMs and IKMs for performance enhancements
  • Creating NRT infrastructure using ODI’s Journalizing
  • Creating and maintaining ODI Topology, setting up Physical and Logical Architecture, Models, Contexts, Variables
  • Creating shell scripts for batch and automated jobs calling ODI scenarios
  • Creating and managing ODI user privileges in Security
  • Patching ODI for GUI slowness
  • Creating Master and Work Repositories
  • Creating Error Handling process in ODI
  • Tuning interfaces and packages
  • Creating data models for Trading, Position, General Ledger, Pricing, and Risk subject areas using Erwin
  • Developing conceptual models based on business requirements
  • Reverse engineering to ODS to create graphical representation in the form of Entity Relationships
  • Building physical model from logical models
  • Designing and implementing ETL processes for Enterprise DW
  • Writing technical specifications for business requirements using current system capabilities
  • Enhancing current DW processes to meet changing business requirements
  • Expanding scope of DW to cater to multiple source systems from middle and back offices
  • Performing functional, regression, unit, and system testing
  • Designing dimensional model for EDW (multiple source systems)
  • Creating test cases and validation scripts
  • Creating documentation for QA, UAT, and Release Management teams for deployment to multiple environments
  • Maintaining data model updates along with metadata and data dictionary
  • Deploying scenarios and Work Repositories across multiple environments
  • Designing Technical Architecture for the EDW solution, including Logical Data Model, Physical Database design, and Capacity Plans
  • Debugging failed QA/UAT/PROD loads and providing solutions
  • Creating Partition Exchange Loading strategies for FACT tables
  • Reverse Engineering Source to Target mappings from ETL code

Environment: ODI, , Oracle 11gR2, SQL, PL/SQL, Oracle Enterprise Manager, UNIX, SQL * Loader, WinScp 5.1, Autosys, OBIEE, Erwin, Exadata, GoldenGate

Confidential, South Plainfield, NJ

DWH ODI/OWB Developer


  • Requirements and Gathering analysis from the Business Analysts to fill out the Design Document, which details the technical design and development effort that will be implemented to achieve the interface/extract’s business need
  • Creating logical and physical models using Erwin
  • Dimension model design for EDW Facts and Dimensions
  • Designing STAR schemas for detailed data marts
  • Reverse engineering of physical data models from databases and SQL scripts.
  • Serve as liaison between technical team and the business team leads
  • Working closely with testing team to come up with test scenarios for each interface
  • Coordinating offshore development
  • Designing and developing OWB mappings to provide business with the interface specific product
  • Creating ETL Interfaces and Packages using ODI
  • Modifying interfaces based on the requirement documents
  • Creating packages and scheduling them. Addressing the failed jobs
  • Performance Tuning of long running interfaces and packages
  • Developing Database Objects including triggers, stored procedures, Functions, Packages, Indexes, Views and Materialized views
  • Responsible for viewing and managing production integration jobs using ODI Operator.
  • Handle slowly changing dimension (Type I and Type II) based on the business
  • Installing OWB for Oracle 10 G Release 2 and upgrade to patch 4, and migrate to 11 g Release 2
  • Designing and developing ETL processes for moving data from source systems (IDX and QNXT) to the old and new data warehouses
  • Exporting MDL files across multiple environments
  • Converting old legacy system code to current system specifications
  • Designing data models for every subject area as relating to the interface’s business requirements
  • Unit testing the results of each interface’s execution (Test Level 1)
  • Providing unit testing level 2 and integrated testing preparation support
  • Designing and developing stand-alone Pl/Sql procedures, as well as procedures to be used as Pre and Post map processes in mappings
  • Support deployment of packages across multiple environments
  • Monitoring jobs and developing error handling procedures
  • Design and develop incremental OWB mappings
  • Configuring locations, modules (Oracle and SQL Server) in Design Center
  • Designing and developing data flow from QNXT to the new warehouse to flat files and data marts
  • Providing documentation to support design and code changes
  • Defect remediation for production support
  • Debugging failure of extracts’ execution in production environment
  • Identifying EDW dependencies for successful execution of units
  • Creating and running complex queries in SQL Server for QNXT related extract
  • Developing automated testing scripts that can be used across multiple units
  • Providing updates on fixes in Quality Center
  • Participating in failed test results meetings to provide solutions

Environment: ODI 11g/, Oracle Warehouse Builder 11g Release 2, Oracle 11g Release 2, Oracle Warehouse Builder 10g Release 2 (, Oracle 10g Release 2 (, SQL, PL/SQL, Toad 9.5, Erwin 7.2, Oracle Enterprise Manager, UNIX, Citrix, SQL * Loader, TFS (MS Visual Studio 2008), FileZilla, MS SQL Server 2005, Autosys

Confidential, South Plainfield, NJ



  • Gathering and analysis of business requirements
  • Defining source and target metadata.
  • Dimension model design for EDW Facts and Dimensions
  • Updating logical and physical data models to support new projects.
  • Designing STAR schemas for detailed data marts
  • Cleansing data using OWB Data Profiling, analyzing data quality of all the file maintenance data and creating data rules.
  • Debugging and resolving various Change Control Requests submitted by the business team.
  • Developing Pl/Sql procedures and functions to convert data from XML and CSV files
  • Building control files to load staging tables using SQL Loader
  • Providing production support for business units
  • Developing prototypes of PDF reports for different business units
  • Modifying existing ETL processes to accommodate different business units with different business rules
  • Building shell scripts to parse through server files and manipulate according to business requirements

Environment: ODI, Oracle Warehouse Builder 11g, Oracle Warehouse Builder 10g Release 2 (, Oracle 11g, Oracle 10g, SQL, PL/SQL, XML, Toad, Erwin, Oracle Enterprise Manager, Oracle Workflow Manager, Windows XP, UNIX

Hire Now