* 3+ YEARS of experience with ETL tool IBM DATASTAGE 9.1/8.7/8.5/8.1/7.X (INFORMATION SERVER, WEB SPHERE, ASCENTIAL DATASTAGE).
* Designed and successfully implementedEnterprise Data warehouse and synchronized Data marts.
* Experience in development and effective implementation of DATA CLEANSING, DATA ACQUISITION AND DATA INTEGRATION TASKS using ETL tool DATASTAGE.
* Strong skills in design and implementation of STAR SCHEMA and SNOWFLAKE SCHEMA used in Dimensional and Multidimensional modelling
* Excellent technical and analytical skills with clear understanding of design goals of ER MODELING FOR OLTPand dimension modelingfor OLAPusing ERWIN
* Expertise with DataStage Designer to develop processes for EXTRACTING, CLEANSING, TRANSFORMING, INTEGRATING, and LOADING data into data warehouse database
* Extensively used Parallel Job Stages like STOREDPROCEDURE, DATASET/FILESET, AGGREGATOR, JOIN, TRANSFORMER, SORT, MERGE, FILTER, MODIFY, LOOKUP, FUNNEL and PIVOT.
* Extensive DATA WAREHOUSE EXPERIENCE using TERADATA, tools and utilities like BTEQ, FAST LOAD, MULTI LOAD, FAST EXPORT, TPUMP and Teradata SQL assistant.
* Extensively used SQL/PLSQL in creation and execution of Stored Procedures and Database Triggers.
* Expertise with SQL, complex queries, optimization and fine tuning.
* Worked on Quality Stage for address standardization, match passing, country wide segregation of data
* Expertise in Data Warehousing techniques for Data Cleansing, SLOWLY CHANGING DIMENSION phenomenon (SCD), SURROGATE KEY assignment and CDC (Change Data Capture).