Banner Image

Skills

  • Analytics
  • Data Modeling
  • Data Warehouse
  • Design
  • Extract Transform and Load
  • Health
  • Informatica
  • Modeling
  • Oracle
  • Oracle Data Integrator (ODI)
  • Quality Assurance and Testing
  • Software Development

Services

  • 10+ years of IT experience in the DWH

    $10/hr Starting at $25 Ongoing

    Dedicated Resource

    10+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial and Telecom Sectors Highly Motivated,...

    AnalyticsData ModelingData WarehouseDesignExtract Transform and Load

About

10+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial and Telecom Sectors

? Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
? Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, ELT, OLAP, BI, Client/Server applications.
? Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
? Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
? Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle and SQL Server Databases.
? Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
? Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
? Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
? Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
? Experience in using Automation Scheduling tools like Autosys and Control-M.
? Worked extensively with slowly changing dimensions.
? Excellent analytical and logical skills with ability to provide quality Technology solutions within committed time frames.
? Strong experience in Data Warehousing and ETL using Informatica Power Cent