• 8+ years of experience in design and implementation of Data Warehouses/Data Marts using IBM WebSphere DataStage. • Experience in developing ETL processes to extract, transform and load data from various source systems into Data Warehouses and Data Marts. • Understanding of Data Warehousing principles using Fact Tables, Dimension Tables, Star Schema modelling and Snowflake Schema modelling. •Experiance on XML stages.like to create or parse XML in datastage.• Experience in using various stages like Transformer, Aggregator, Join, Merge, Lookup, Surrogate Key Generator, Sequential File, Copy, Remove Duplicate, DB2 Enterprise, Funnel, Sort, Sequencer job stages such as Job Activity, Execute command. • Experience in Data Migration Project and Migrated Jobs from One ETL tool to another. • Implemented Local containers for same job and shared containers for multiple jobs, which have the same business logic. • Good knowledge in finding the Business logic for different domains in Insurance and Retail. •Experience on ssis n Informatica